June 26, 2012 at 5:06 am
Hi All,
Would you please suggest me whether there is any data limit in an SSRS report?
Actually I have one report using multiple sub-reports. If I use 10 sub-reports, there is no issue. But if I use more than 10 sub-reports, format layout gets distorted in my final report. What may be the reason?
Your suggestions are highly appreciated.
Regards,
Pradeep
June 26, 2012 at 10:07 am
There is no limit for subreports as per my understanding because I am currently working with 30 subreports for my KPI.
Adjust the size and location of each subreport in properties window.
I did the same way and I am getting my report correctly.
June 27, 2012 at 12:23 am
thanks for reply.
Actually original report (having 15 subreports) was working fine. As per business requirement we had to add more data and we just changed the sql-query of dataset to fetch desired no of rows. Since then report is behaving weirdly.
Then I started removing subreports from main report and found that till 10 subreports, main rpeort is working fine but for more than that its format getting distorted. I have not done any change in subreport location and width.
For your information, subreport's left location is 0. With of subreports is 0.25in.
Interactivesize length is 0 in both main report and subreports.
one more thing:- I have created this report in BIDS 2005 and working fine but creating problem only when deployed in report manager. Also exporting to excel/pdf is fine.
Please give your inputs.
Regards,
Pradeep
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply