Subreport Linkage Problem with prompts

[Former Member]

Hi all,

I have built some report templates used as the source of subreport. Each subreport is having a parameter field "username", which is mapping to a "user" column field in the mySQL datasource . When I built the main report, I will insert those subreports with linkage point with "user".

What I want to do is when I view the report, it will show only one prompt and ask for a username. Once the user entered from the LOVs, the report is able to output each subreport part with particular user only. How can I achieve this?

( My ultimate goal is to view the report from the BOE, using the link:

http://BOE_SERVER:PORT/OpenDocument/opendoc/openDocument.jsp?lsSusername=USERNAME&iDocID=REPORT_ID )

Any help is highly appreciated.

Regards,

Gary

[Former Member · Accepted solution]

Hi Gary,

After inserting all the subreports in the main report do the following for each subreport.

1.Right click the subreport, and select "Change Subreport Links..".

2.In the Available Fields option, select the "Username" parameter and click on ">" button.

3.Automatically ?Pm-?Username will appear in the "Subreport parameter field to use" option.

4.Select the database field in the option next to "Subreport parameter field to use". Make sure "Select data in subreport based on field" is checked.

Hope this helps.