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

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

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.

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.

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.

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

No i did not get you ... because its says customer value and then customerid .. Could you clarify on this

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.

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