March 6, 2012 at 9:06 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/
March 6, 2012 at 9:15 am
If you mean posting the same question in multiple forums ... I'm sorry, and won't do it again. I was advised it would be a good idea to increase the likelihood of a response.
I find helps provided at your cite very helpful and it's a service I want to not abuse.
Is there a way to delete a post I made but later decided I don't need it to stay there?
March 6, 2012 at 9:35 am
No problem. 😀 No you can't delete them, unless you send an email to the moderator asking for it to be deleted. Probably not worth it because it will fall off the radar quickly with no activity anyway.
This forum is a bit different than many other around the web. The problem of posting in multiple spots is that it fragments your responses because you will end up with different people on each thread.
_______________________________________________________________
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply