March 6, 2012 at 9:04 am
The report I have developed has a main report and four subreports.
The main report receives three parameters from a user. Each of these parameters is allowed multiple values ... one or more or even all available values.
Two of those parameters are passed to each of the subreports.
My problem is this. If I select two values each for those two parameters, the subreports work right. But if I select more than two values then the subreports return only it's heading ... not the data even though two of the values are the same ones for which the subreport formerly returned data. (And if I knock out the third value then the subreports return that data again.)
March 6, 2012 at 9:08 am
Please don't cross post.
direct all replies here. http://www.sqlservercentral.com/Forums/Topic1262308-392-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply