.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS Designer runs very slowly with large number of groups

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

I've developed a workaround for the recursive Parent-Child issue where groups do not export out to Excel properly (no expand\collapse navigation, no stepped groups) that involves setting up a group for each parent and then applying a filter for the parent on the UniqueName.  Children groups can then be set up with the Group set to ParentUniqueName.  This works great, except that I now have 30+ groups.  The designer (both the BIDS and ReportBuilder) have slowed down to a crawl where each click or keyboard navigation etc. takes 7+ seconds.  This has made report building extremely painful!  It is not a hardware problem, as I have tried it on a number of high powered machines with the same results.  The report itself runs relatively quickly.

Is there an upper limit for the number of groups that SSRS designer is meant to work with, or a workaround that I am not aware of?

View Complete Post

More Related Resource Links

SSRS 2008 Export to PDF fails for large data with System.Exception: Parameter is not valid

Hi, We are working on Range Bar Chart using SSRS 2008. The report has huge data. It is properly displaying the data, but when we tried to export to pdf it is failing with the following exception. Exporting to excel works fine. Also if the report has small/medium data it is property exporting to PDF. It is failing only in case of huge data (we have custom page size of 28" X 14"). Of course the report has lot of expressions we used to customize the colors/text as per our requirements.   Server Error in '/Reports_SQLDEV2008' Application. Parameter is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Parameter is not valid. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:   [Exception: Parameter is not valid.]   [Exception: An error occurred during rendering of the report.]   [Exception: An error occurred during rendering of the report.]    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream ou

SSRS 2008 group footer totals on a new page has a non-expected large cell height

SSRS 2008 group footer totals on a new page has a non-expected large cell height. When the group total is the first component on a new page, then this happens, but when it is part of the group on but not the first component, then it reverts to normal cell height. I have played with the advance settings now for hours, but cannot get this to work. Any ideas?  

ASP.NET Events and Pageload not firing when Datagrid containing large number of rows of data

Hi All, I have a datagrid in aspx page.Inside of datagrid i am using around 15 controls such as Button,dropdownlist and text box controls.Once the datagrid binds then the events in the aspx page not firing.Issue occured when the number of rowsgreater than 500.The number of rows less then its works fine.If anybody knows the solution please let me know."Platform i am working on ASP.NET1.1"Regards Hareesh

Data Driven Subscription problem - sub runs slowly, has 40 errors out of 300, but report server trac

I have two report servers and a single separate SQL Server 2008 server hosting the data source database and the report server catalogues. There is a data driven subscription that runs off a sproc that returns 300 rows with email addresses for this report to be emailed to. The report itself contains around 30 subreports each with its own sproc to retrieve data. As the report is executing there are long pauses between the times when emails are actually sent out, and the subscription status will finally end with something like "Done: 300 processed of 300 total; 40 errors." I am not sure how to go about troubleshooting this problem. Details: I kicked it off at (say) 2:00 PM. Within 3 minutes in the report server execution log I saw 300 entries. There were exactly 300 people who should receive reports, so the master report should have executed 300 times and sent out 300 emails. So this looked good in the execution log. But when I checked report manager's status page for the subscription it was listed as processing 50 out of 300... Then all activity stopped, about 15 minutes some more reports started emailing out, and now I see there are around 590 rows in the execution log and maybe 97 emails sent out... Then finally I get a grand total of 846 rows in the execution log and a grand total of 260 of 300 emails sent out with 40 errors so 260+40=300 exactly. The time betw

Nested Groups in SSRS

Hi All    How should display  the groups in  Top to bottom manner , instead of left to right in SSRS  As shown below + Category+ Subcategory+ Product

Unable to use XML datasource to run a report on Report server( Report runs fines in Report designer

We are trying to run a report which uses a xml file  to load a report on SSRS. We have copied the xml to the Pages folder  and are able to access the xml via the link https://<servername>/Reports/Pages/test.xml This runs fine in the report designer.(i,e we are able to get create xml data source and use a dataset to retrieve the data from xml to the report designer) However when I try to create a XML datasource on the development server and try to run the report , we get the following error Error: An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. Failed to execute web request for the specified URL. Unauthorized: The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized. I have updated the XML datasource to use Windows Account which is in the adminstrators group.   Any suggestions or hints are appreciated  

SSRS Query Designer (in BIDS) does not generate ANSI SQL

Hello, I have a problem when using SQL Server 2005 BIDS (Business Intelligence Development Studio) when connected to an Oracle data source.  The Query Designer generates the old Oracle SQL syntax instead of ANSI SQL.  This is with the Oracle 10g client installed. So, I would really appreciate it if anybody knows how to get the Query Designer to generate the ANSI SQL.   Thanks, Stuart

Large number of items in SharePoint calendar


We have a department with a calendar that has over 400,000 items.  We're thinking it somehow got that big due to them linking with outlook.  We've turned that off but the items are still in SharePoint in the calendar.  This is causing a great deal of blocking when that calendar is accessed (CAML queries).  They take several minutes to run and block anyone from doing anything in SharePoint (like saving documents or even accessing SharePoint).  We'd like to just delete the 400,00+ items but I'm not sure what all tables are involved.  I've found that the tables docs and UserData each have the 400,000+ records relating to the calendar in question.  I don't want to simply delete the records from these tables only.  Does anyone know what I need to do to clear the calendar?  Is there a way in SharePoint to just delete the whole calendar and it delete the records where needed and then add the calendar back (and it be empty)?



Not able to export a large SSRS report into Excel



I have a requirement to export a large SSRS report into Excel. The report has more than 52 columns and around 70000 lines. The requirement is to export the report into a single excel(different sheets also would do ). Can you suggest some help in this regards?

Thanks in advance!

Handling a large number of structs



I have to parse a CSV file, filter out lines,  add values and store it to disk again. My idea is to create a struct for the values of each line:

struct LineValues
  int Value0;
  double Value1;
  string Value3;

Then I want to initialize LineValue instances with values from the file (reding it via StreamReader.ReadLine()) and put them into a List<LineValue>.

The generic List is a reference type so it is put onto the heap. But where do the LineValue instances go? I am afraid this is gonna cause a big GC job after doing this on a file with thousands of lines.

Is there a better solution in terms of performance?

Thx for your help,


Variable number of colomns in ssrs report



I have a stored procedure which is built on PIVOT fuction. I am using the stored procedure to generate a report.

some time the stored procedure will generate the variable no of colomns, in ssrs dataet is updating with variable no of colomns, at that time report is not supporting.

i am using table control in SSRS. some one suggested me matrix control, but i need to change my stored procedure to work with matirx control.

i dont want to change the stored procedure.

can any one suggest me how to resolve this in SSRS.



In SSRS 2008, after export to Excel report loses nested visibility groups


I have a report  created in SSRS 2005 which is running on our new SSRS 2008 box.  It has 3 nested levels of visibility so the recipient can click the twist tie to view different levels of detail.  Each Zone has many Districts and each District has many Stores.  The report renders displaying the summary of the Zones.  If you click on the twist tie on the Zone it opens up a list of Districts.  If you click on the twist tie on a district, it opens up a list of stores.  If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.

The report renders fine in report manager.  The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.  The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts and Stores.  The client is not happy about this.  This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.

I tried converting the report to SSRS 2008, but that did not solve my problem. 

Is there anyway to fix the export process to Excel? 


P.S. I tried to upload the code, but it caused my question to be too many characters

SSRS report runs slow


I developed a report with BIDS  which uses a stored procedure on MS SQL 2008 Database to populate its dataset used as Datasource. The report runs very slow (10 mins) and if the stored procedure is executed separately on MS Server Management Studio (SMS) it takes only a few seconds with the same parameters. Appreciate if anyone could help on this issue.

Thanks. VisaAde

SSRS Column Groups


We are developing a report based upon an RS model which requires a specific format for the output i.e.

C_A, C_B, C_C (Column group on ID, query filter where ID between 1 and 14).

The issue we have come across and are unsure how to progress is for a specific date it is possible to have a maximum ID of 6, per say.  How is it possible to make the column group create columns for 7 - 14 when no ID values exist in the RS model for a given date?



How to retreive week number in SSRS


How to retreive week number in SSRS if i have date 09/25/2010 in Expression



Execute SQL tasks runs continuously when updating big number of recrods in foxpro


I have an SSIS package execute SQL task that updates a foxpro table where it has more than 2 million records. The update is done after importing foxpro data to a sql database. The update task indicates as running (yellow color) continuously but nothing is updated. The same update command if given within foxpro, it works and update is completed within few seconds. If I try to update only a subset (for example only about 2000 records in the concerned table) from SSIS then it works as well. This indicates I presume that the failure is as a result of a waiting cause by higher number of records. Is there any way make this work? What are the alternative work arounds? Any help is greatly appreciated.


SSRS 2005 report export to excel - show text as number


When exports the report to excel, some columns are numbers(something like 00125987). We need these columns to be text,  but excel convert these columns in numbers and in result we received not "00125987" but "125987".  

How to fix that? 

We need all these columns to be text.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend