Sunday, March 25, 2012

Additional area in main report after sub-report

I have a main report that has 17 sub-reports in it. I have had some problems with additional space in the main report, after sub-reports that have no data in them. In the actual sub reports I have expressions set up for each line in the tables to hide the row if there is an empty string in it. (IIF(Fields!FieldName.Value = "", True, False)).

Is there a way to set up in the main report is the sub report has no data in it to hide the sub-report, and not show the additional space in them. I have tried putting the sub reports in the main report by themselves, and also put them into a table, and have encountered the same results each time.

I did find a site that suggests referencing a Field in the expression for that row, but this would involve us changing the stored procedure and adding additional Fields into the main report stored procedure. Also each sub-report has its own stored procedure to return the data needed for that sub report.

Any ideas?

Hi,

Though the post is a year old and I dint find any answer to ur post so I was just wondering if you were able to find out a fix for this. I am facing a similar problem. I also have a subreport that has some fields where as their visibility is dependent on a parameter. If that's set to yes then the field will show up else not. I can acheive this in the subreport but not in the main report. THe main report doesn't show the field at all. Any suggestions?

Thanks,

Rashi

|||

Another way is to create a custom assembly in .net and have a shared variable. In the subreport, set the shared variable value to 0 based on your condition. In your main report, refer to that shared variable and set the visibility of the subreport based on that.

Shyam

|||

Thanks!

Rgds,

Rashi

|||Can you please mark the post as answer?|||Sure, I can but I dint implement it since I had some other problem related to my report..

No comments:

Post a Comment