- 2 Posts
- 5 Views
nVision tabular layouts using query and specific time period from report run request
We are creating an nVision report workbook that has one matrix layout sheet and two tabular layouts. Our tabular layouts are based on queries. At the time of running the report, the matrix reporting period is based on what is specified in the report request and the tabular layouts are defined by what criteria is saved on the query. Is there a way for us to allow the report request to override the query time period criteria at run time? Our workaround is using prompts and running the report via the web based PSnVision. I wanted to reach out to this forum to see if any folks have come across this dilemma/issue.
Any additional information would be greatly appreciated!
@Rona Galarza We have added the report request date to the query criteria by joining the NVS_REPORT table. You may have to get creative with an expression to pull the specific time period you need. The only limitation of this is that the user has to save the report request prior to running so the query picks up the correct date.