You’re offline. This is a read only version of the page.
Dear Active Reports Guru's
I can do all of this via sql but my staff would like to be able to do it themselves via active reports.
1. Can you pass parameters to the SelCriteria = "" in the ReportSummary section? If yes, Sample code please?
2. What does the following statement do in the Filters Section do?
FilterNegated = False
FilterConnector = reportfilterbooleanconAND
3. Can I have more than one Filter Section in an active report?
4. Would like to be able to pass a date to a column, so I can do the equivalent of item.lastsold < '01/01/2010'. Is this possible with Active reports? Now doing "Not between 01/01/2010 & 12/31/2014" as seen in image.
*This post is locked for comments
Hi eric, nice to see you around in the community.. keep supporting! hehe :D
I don't know of any other software for reading QRP reports but you can customize and create one (source: in my previous job we developed something similar). You just need to study how the report file works and you'll be able to implement a QRP reader.
Nice answer! Thx!
Now, ho do you know how I can run .QRP report without RMS? SomeLibrary for .net or .exe only for run those reports?
1. No, you cannot pass SQL parameters in SelCriteria.
2. FilterNegated indicates whether to negate the current filter. For example, 'ColumnA' = 0 will be treated as ColumnA <> 0. FilterConnector indicates the connector (AND & OR) for the filters. e.g. ColumnA = 0 OR ColumnB = 1
3. There should only be 1 section per group, i.e. 1 ReportSummary, 1 title, 1 filter, and 1 column sections each.
4. Filtering a date column requires a range. Meaning, you must provide the 'from' and 'to' values. Filtering date only uses the operator 'BETWEEN', thus you cannot use a < (less than), or > (greater than) operator. However, you can use an = (equal) operator by entering the same date in the range. e.g. From: 1-1-2010 To: 1-1-2010
There is not a report building tool.
You can edit the file directly with Notepad. Open up various QRP files and study the structure. Its pretty basic. Query goes first, then the filtering. Then finally each column definition.
Hello TheNeos,
I have a question, exists a report builder to create reports in active reports of this way we can use all the skills and resource that its tools has?
Greetings.
David Cordova
Honduras
Hello Danny,
Points to take notice.
1 - Accessed from RMS Manager, therefore your staff must have access rights to Manager and reports.
2 - Yes many filters can be applied to each report. Here you have to be careful with mixing multiple AND and OR.
3 - If NOT is not required deselect "negate".
4 - Once report generated study the menus on it. You will find that you can group, expose header, hide columns or expose columns that are hidden, export and the most useful memorize this report so that can be used again with minimal of typing.
Which Country are you in?
TheNeos, Australia
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (