how to create dynamic report in ssrs2005 RRS feed

  • Question

  • Our company is planning to use SSAS cubes as data source for report generation [.rdl] in SSRS.I am able to generate static .rdl reports which uses cubes of SSAS and display it in a web application.


    1) How to generate reports at runtime i.e.


    The end user access the report generation page in which they select


    • The data file which contains the employee enrollment to some Schemes
    • The output type (Table or chart (Pie, Clustered, Stacked etc)or both)
    • The Metrics(Measure) Type(Count of Employee or Percentage or both AND if Percentage then select sub metrics like Industry std or Client Target or both)
    • The Category[x,y] variables [by Age band 0-30,30-60 etc,by Schemes] and Series values[by Gender]
    • The filters [Gender]


    Do we need to generate rdl code programmatically? Or is there any other option available? If yes plz provide some reference to some articles which help me doing that as I am new to reporting

     2) How to generate AgeBand Category variable [0-20,20-40] [either in x or y axis] from Date of Birth Data?


    3) How to swap between x and y data at runtime [Dicing]?


    we are using ssrs 2005

    Wednesday, July 29, 2009 1:54 PM

All replies