cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

Query Builder - is it possible to have different attributes in input and output table of the report generated

ptc-4974377
1-Newbie

Query Builder - is it possible to have different attributes in input and output table of the report generated

While creating a new report template - my requirement is to have different set of attributes at input page and report generation page.

Is it possible to achieve? Or can we hide the attributes added at select tab so tha user can not see it in input page but it will be displayed at report table.

Or is there any alternative solution for this?

1 REPLY 1

This is one of the major changes to reporting from 9.x and all before to 10.x. Have to really do a lot of planning to make reports practical and confusion-free for users. Some options / tools:

a) Can apply the following string to the Report, Properties, Input Page.

"wtcore\jsp\report\reportGenForm.jsp"

This results in the report running as it did pre-10.x. The user does not see criteria that are not parameters.

We initially applied this to all our reports when upgrading to 10.1 and have only gradually started removing it one report at a time as we rebuild them appropriately for 10.x. The rebuilding primarily is a matter of re-addressing how all criteria are applied. Early releases of 10.x don't handle criteria applied on the criteria tab as well as later releases.

b) Can apply various sets of criteria to any given report and save these, making available to users. They display to users in Home/Reports, Saved Reports. Have to put some effort into naming conventions. Note: Users have to aware to go to the Saved Reports and not select the "parent" report in the root Reports table.

Discovering this sort of pushes you to make families of reports and ends up being useful, but requires some planning and discipline. We have noted many buggy features on the saved reports function.

Top Tags