Build reports dynamically in ssrs

Question

Post reply

Build reports dynamically in ssrs

SqlServerNinja

Ten Centuries

Points: 1238
More actions
November 19, 2013 at 4:00 pm

#282655

I have data in my database table which looks similar to the data below :
Time Name Sales
Aug-11 A 33
Aug-12 B 34
Aug-13 C 31
Aug-14 D 39
Sep-11 A 99
Sep-12 B 34
The requirement is that I need to build a report for A details ,another report for B details ,and another for C details and so on. There Could be a D and E added to the database table next month and some more data the month later...
I want to know if there is a way that I can create the reports dynamically , rather than creating a report for A, B and C now and then going into the report and creating another report for D and E next month and soo on..
Please let me know.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

...and you can't have a single report with a parameter for A,B,C etc?

If Not, you can create the report with the parameter as a hidden parameter with a default of A, then create a linked report with a default of B etc., but you would still need to do that bit of work to create the linked report (under a minute to do)

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

SqlServerNinja Ten Centuries Points: 1238 More actions · Answer 2

mister.magoo (11/19/2013)
...and you can't have a single report with a parameter for A,B,C etc?
If Not, you can create the report with the parameter as a hidden parameter with a default of A, then create a linked report with a default of B etc., but you would still need to do that bit of work to create the linked report (under a minute to do)

The thing is I would need reports for A , B and C .. So I dont think I will have benefit of using parameters here .. Will I ?

I havent looked at linked reports ..I will read about them now..

I wanted to know if there is a way, I can create a basic report and the SSRS would create a report for each of the Names , A, B C and soo on ??

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

Not automatically, but linked reports are very cool and will let you achieve your requirement without any additional report development

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);