We have a quick report with no parameters, but we want the Parameters window to pop up to show Comments in which we’ve documented each column on the report. Can this be done? How do you document your quick reports for users since there’s not other place to put user info?
In my quick report I'd like to select a date range going back to the first of last year, so for today, 2/26/2020 it would select 1/1/2019 - today. date_entered between sub_months(trunc(sysdate, 'YEAR'), 12) and trunc(sysdate, 'YEAR')-1/24/60/60 I tried a sub_month but that didn’t work. I’m already using this format for going forward one year: OP_START_DATE between trunc(sysdate, 'YEAR') and add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60
We’re creating a QuickReport where we want transaction data by month going across the row. We created an accumulating IAL grouped by YYYYMM which works great. Then creating a 2nd IAL over the first to total each YYYYMM’s Qty into it’s own month column (January, February, March, etc) and when we run that in SQL Query Tool it fails with this error: We’ve ensured all rows have valid dates.
Does anyone know how to make a parameter mandatory? By default they are all optional. Also, is there a way to set a default value for a parameter? Lastly, is there IFS documentation or a manual on details like this? I’ve seen IFS pages that have general info, but nothing on technical details like the above or what else is doable/possible. As we start to develop our company’s custom reports I’m getting ideas and would like to know the capabilities and what’s possible with QuickReports.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.