Skip to Content
avatar image
Former Member

Subreport Linkage Problem with prompts

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2008 at 03:39 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded