By using this website, you agree to our Terms of Use (click here)
Greetings,
I'm in the process of replicating a report as a generic inquiry. Loading the report onto the Report Designer, I came across a few variables required to complete the report.
I replicated the first of 6 variables in a generic inquiry. As I was building, I realized a few of the subsequent variables in the report reference previous variables.
I attempted to nest these into the GI's IIF statement but couldn't find success. Is it possible to replicate a report as a GI or do variables create some form of limitation?
You cannot say with 100% certainty that all reports can be replicated as GI. The underlying query surely can, but reports have a presentation layer with features not available in GI.
Variables are tricky because it's not just a row by row calculation like you could replicate with a calculated column in a Generic Inquiry.
Variables can behave differently in different sections of the report or even get reset across sections. Those sections are a presentation layer concept that Generic Inquiries can't reproduce as Royce points out.