|
Get help or share ideas and techniques for creating applications and reports with WebReports and WebReports Extenstions for Workflow.
To receive notifications when new posts are created, please choose the "Alert Me" option from the Actions menu below. (Actions > Alert Me)
Started: 1/26/2010 10:17 AM | | |
|  | SubWebReport - Parameter Issue I have a web report, linked into a workflow, which uses a sub report to display the data from a multi line text field. I use the sub report to save typing in the layout 10 times! I use this line to call the subreport and the subreport works if they are printed in the Param line. If I donot display this line the
[LL_REPTAG_&InputLabel1 & LL_REPTAG_&InputLabel2 assignments do not work? any ideas.
Line to call the sub report
[LL_WEBREPORT_SUBWEBREPORT NODEID:[LL_REPTAG_$CommentsReport /] PARM:InputLabel1:[LL_REPTAG_&workid /] PARM:InputLabel2:1 /]
This is my sub report:
[// CommentsSubReport to list out workflow comments
[// InputLabel1 workid
[// InputLabel2 Index for multi line fields
[// Debug <p>Param:[LL_REPTAG_&InputLabel1 /]:[LL_REPTAG_&InputLabel2 /]:</p> <table border="1" width ="90%" align ="Center"> <tr> <td width ="20%"> [LL_REPTAG_&InputLabel1 WFATTR:UserCommentsTitle:[LL_REPTAG_&InputLabel2 /]:DISPLAY ESCAPESTR REPLACE:\r\n:'<br>' /] </td> <td width="60%"> [LL_REPTAG_&InputLabel1 WFATTR:UserComments:[LL_REPTAG_&InputLabel2 /]:DISPLAY ESCAPESTR REPLACE:\r\n:'<br>' /] <td> <td width="20%"> [LL_REPTAG_&InputLabel1 WFATTR:UserWhoAddedComments:[LL_REPTAG_&InputLabel2 /]:DISPLAY USERINFO:FULLNAME /] <br> [LL_REPTAG_&InputLabel1 WFATTR:UserCommentDate:[LL_REPTAG_&InputLabel2 /]:DISPLAY DATE:"%d-%b-%y" /] <td> </tr> </table> | |
Posted: 1/26/2010 3:54 PM | |
| | I think this is just a processing order issue within the subWebReport. In the SubWebReport, try setting the first parameter as a WebReports variable, and use that variable as the main data tag instead of &inputLabel1, eg:
[// Set inputLabel1 as a variable:
[LL_REPTAG_&InputLabel1 SETVAR:myVar1 /]
[// call the WFATTR tags using the new variable
[LL_REPTAG_%myVar WFATTR:UserWhoAddedComments:'[LL_REPTAG_&InputLabel2 /]':DISPLAY USERINFO:FULLNAME /]
I believe it's the nested parameters that are causing the problems. Also, please note the single quotes around the &InputLabel2 tag - this is just incase the data in the "UserWhoAddedComments" field contains any spaces.
Let me know if you need more info or have any other questions.
Thanks,
Jordan | |
Posted: 1/27/2010 3:33 AM | |
| | Thanks for the fix it works OK now.
| |
|
|
|
|