Generating Reports DYNAMICALLY in SSRS-2005..

• Aswanth

  Mr or Mrs. 500

  Points: 548

  More actions

  March 19, 2008 at 10:23 pm

  #185451

  I'm Working with Asp.Net with C#.. & I'm Generating Reports in SSRS-2005..

  Till Now I'm Generating Reports in SSRS-2005 with Stored Procedure.. in Which I'm Generating Reports for One Particular User Details(ie I wrote Stored Procedure for Getting One Users Details)..

  Now I Want to Generate the Reports for Different Users DYNAMICALLY (Here, I wrote another Stored Procedure which contains UsersID's as Input Parameters.. when we give the User ID then that Particular User's Details will be Executed).. Here I want to Place one Dropdownlist Control which contains All the User's ID's.. After selecting the Particular User ID, I Want to Generate that User's Details REPORT..

  I done this as like that I generated Report for One User(ie as like First Report).. But it is Not Working..

  Please give me the Suggestions for Generating Reports DYNAMICALLY..

  Thank You..

• lost in SQL

  SSC Enthusiast

  Points: 163

  More actions

  March 20, 2008 at 1:25 am

  #791869

  Ok,

  Here you go...

  1. Create New dataset returning UserID and UserName as result.

  2. Add a parameter User in report

  3. Select the same parameter then goto Available values, select from query and then

  select Dataset, Value Field, Label Field

  4. Now you have created a parameter that generates a DropDown list of Users.

  5. Now link this parameter with your SP parameter.

  a. Goto Data

  b. Select main report Dataset.

  c. Click on "..." button to edit dataset

  d. goto Parameters window

  e. Select SP parameter from "Name" and RS parameter from"Value"

  And this should work fine. Let me know if face any difficulty.

  RB:cool: