How to make a common parameter for two subreports in the main report.

[Former Member]

Hi,

I have a crystal report which has 2 subreports in it. Both the subreports have the same code and I need to create a parameter for Project Cost in both the subreports for filtering the data.

When i create the same parameter in both the subreports, i see two parameters with same name on my prompt page while refreshing the report. however I just want 1 parameter on my prompt page and data should get filtered in both the reports.

Can anyone please suggest something, How can I do that? is there a way for sharing same parameter between two subreports?

Thanks!

Neha.

[JWiseman · Accepted solution]

hi Neha,

here's how to do this:

1) create a new parameter with the same name on the main report

2) right click on your first subreport and choose Change Subreport Links

3) in the Field to Link To list drag over your new main report parameter

4) open the Subreport Parameter Field to Use select menu and choose your subreport parameter

5) repeat steps for the 2nd subreport

now you'll only get prompted once.

cheers,

jamie

[Former Member · Accepted solution]

Thanks for the help it worked out!

[Former Member]

Yes Neha:

1-right click sub report

2- pick "change sub report links"

3- link the values from the main report to sub report.

make sure the data type is same for linking values.