Sub Report Parameters

Is there a way to have more than 3 parameters passed to a LiveReport sub report? I am using the 3 that are available when I create the main LiveReport, but I do not see an option to add others. I would like 2 more if possible.
thanks!

Find more posts tagged with

Comments

Bhupinder_Singh

I've forwarded this question to a colleague here at OpenText who specializes in WebReports, and he will be replying to your question this week. Does your organization have the optional WebReports module?

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Systems Administrator, Cloud Services
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

Donna_Pellett

Yes, we do have the Webreports module. I have used it to schedule some of the Livereports we have created. Maybe my function would be better built in webreports. I have 5 input parameters the client enters and then we insert into a reporting table we have set up that drives a lot of our reports from the database. Thanks for checking for us. Donna

Ian_Whitfield

Hi Donna,

This should be possible with WebReports. The general way you'd go about this is as follows:

1) Create 2 WebReports based on the basic_report template (or using whichever template you need). Set your two LiveReports as the Data Source for the 2 WebReports.

2) Go to the Parameters tab for the parent WebReport and click the blue down arrow on the right to automatically import the LiveReport data source parameters. These will then be available in the main edit window from the 'Parm' dropdown so you can drag and drop the values into the report if required.

3) Add a column header in the header section and change the columns as require for the rest of your data e.g.

<TR>

<TD>[LL_REPTAG_COLNAME1 /]</TD>

<TD>[LL_REPTAG_COLNAME++ /]</TD>

<TD>Click to Run SubReport</TD>

</TR>

4) Add a column in the row section to display the link to click through to the second WebReport and change the rest of the column data displayed as desired e.g.

<TD> [LL_REPTAG_1 /]</TD>

<TD> [LL_REPTAG_2 /]</TD>

<TD> [LL_REPTAG_3 /]</TD>

<TD> [LL_REPTAG_4 /]</TD>

<TD> [LL_REPTAG_5 /]</TD>

<TD> <A HREF="[LL_REPTAG_$SWR LLURL:REPORT /]&parm1=[LL_REPTAG_&parm1 /]&parm2=[LL_REPTAG_&parm2 /]&parm3=[LL_REPTAG_&parm3 /]&parm4=[LL_REPTAG_&parm4 /]&parm5=[LL_REPTAG_&parm5 /]&nexturl=[LL_REPTAG_NEXTURL ESCAPEURL /]">Click to Run SubReport</A></TD>

When you run the main report it should contain a link which calls the second WebReport passing in the relevant 5 parameters. If you see above, the value of a parameter called parm1 can be accessed in the WebReport using [LL_REPTAG_&parm1 /]. This value is passed in with the URL as &parm1= which will be passed from the SubWebReport on the second LiveReport automatically.

If you need any more information on this then it's probably best to continue the discussion in the WebReports forum here: https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=3684835&objAction=view

Also, I'll log a new feature request to make the parameters passed into Sub LiveReports dynamic too because this is quite a sensible feature to add.

Regards

Ian