locked
parameters to subreport in Main report RRS feed

  • Question

  • Hello I have a main report and i have 5 parameters for main report which pass over to sub report. But i if the user chooses to only see the subreport.. then i need to pass in extra 2 parameters..

    SO i want is .

    I input 5 parameters for the main report . I run the report , Now i want to see details regarding this record. So i click on a field name to see details and all parameters are passed into subreport but the subreport needs 2 more parameters other than the 5 passed in .

    So only when the user wants to view the detail and clicks on it it should ask for extra 2 parameters. How can i do this

     

    Thanks

     

    Friday, September 23, 2011 5:52 PM

Answers

  • Hi madhuajj,

    Thanks for your feedback.

    I mean if you want to pass the two more parameters to the subreport, which need the users to type in manually(interactive with users), then you must create them( the two parameters) in your main report the same way as the other five parameters created, you can review the solution I posted for you in the previouse reply, if you have anything unclear, please not hesitate to let me know.

    Thanks,
    Bill Lu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by Zilong Lu Thursday, September 29, 2011 1:25 AM
    • Marked as answer by Zilong Lu Friday, September 30, 2011 2:03 AM
    Tuesday, September 27, 2011 6:37 AM

All replies

  • Are parameters decided while after  main report generation ?you can pass 5+2 parameters in main report and then on link section right click and properties and pass parameters to sub report.
    Gaur
    Friday, September 23, 2011 6:24 PM
  • yes. After the main report is run, if the user chooses to run the subreport thats when he will input extra 2 inputs..

    Is this possible.

    Sunday, September 25, 2011 3:05 AM
  • Hi,
    Yes, you can do it from the main report. Below is the process you need to follow to achieve it.
    Main Report:
    Parameters: 
    1. Country
    2. State
    3. City
    Fields:
    Country, State, City, CustomerId, CustomerName
    CustomerName should be a link to the subreport. Pass the parameters to the subreport from the properties->Action cell of the CustomerName
    Country  = Parameters!Country.Value
    State  = Parameters!State.Value
    City  = Parameters!City.Value
    CustomerId = Fields!CustomerId.Value
    SubReport:
    Parameters:
    1. Country
    2. State
    3. City
    4. CustomerId
    Fields:
    Country, State, City, CustomerId, CustomerName, CustomerDetails
    Hope its clear & helpful....

    Pavan Kokkula Tata Consultancy Services.
    Sunday, September 25, 2011 5:28 AM
  • Hi madhuajj,

     

    Thanks for your post.

     

    According to your description, you have 2 more parameters which need users type in manaually and then pass into the subreport, if so, you must create the 2 more parameters together with the other 5 parameters in the main report, moreover, if you don’t want to specify values for the 2 parameter when you load the main report firstly, you can set the allow null value item to true in the parameter property , so once you want to see the detailed subreport, you can type in values to the 2 parameters textbox at first, then click the relevant field to jump to the subreport.

     

    Additionally, if you would like to make it more flexiable like you mentioned above, you may need to create a programm to customize this behavior by youself.

     

    Thanks,

    Bill Lu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by Zilong Lu Tuesday, September 27, 2011 6:28 AM
    Monday, September 26, 2011 9:13 AM
  • As I replied earlier,yes you can do it .And Bill's suggestion is perfect create parameters at the time of report creation and pass null if you don't have value at that time.Once you get to subreport level calculate and pass values on those 2 parameters.


    Gaur
    Monday, September 26, 2011 3:24 PM
  • No i did not get you ... because its says customer value and then customerid ..

    Could you clarify on this

    Monday, September 26, 2011 3:39 PM
  • Hi madhuajj,

    Thanks for your feedback.

    I mean if you want to pass the two more parameters to the subreport, which need the users to type in manually(interactive with users), then you must create them( the two parameters) in your main report the same way as the other five parameters created, you can review the solution I posted for you in the previouse reply, if you have anything unclear, please not hesitate to let me know.

    Thanks,
    Bill Lu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by Zilong Lu Thursday, September 29, 2011 1:25 AM
    • Marked as answer by Zilong Lu Friday, September 30, 2011 2:03 AM
    Tuesday, September 27, 2011 6:37 AM
  • Thank you very much so there is no way that after i run the main report , have a choice to select my next 2 paramters fo rthe subreport. in case i want to see.. it..thanks

    very much for the reply

    Wednesday, October 5, 2011 8:26 PM