January 12, 2013 at 4:56 pm
Hi Everyone
I've got 20 unrelated tables.
The report request is that for a certain date range (I know how to do this), show the count of each of the first ten tables, and the sum of the values in one field in each of the next 10 tables.
I'm not even sure it's possible within a single report in SSRS, but if it is, any hints, tips or help as to where to start would be grand!
Thanks in advance,
Robert
January 13, 2013 at 4:41 pm
Hi,
I'm not sure if I've understood the problem but as per my understanding, you can create 20 data sets for each individual table. It need not be related... You should be able to show individual results in one report..
Hope this helps.
January 13, 2013 at 7:53 pm
What should the output look like?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 13, 2013 at 8:28 pm
SQLRNNR (1/13/2013)
What should the output look like?
😛
--Jeff Moden
Change is inevitable... Change for the better is not.
January 13, 2013 at 8:31 pm
Jeff Moden (1/13/2013)
SQLRNNR (1/13/2013)
What should the output look like?😛
Ok, that makes sense then.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 1, 2013 at 3:28 am
???
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply