Active Reports (QRP)

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

TheNeos 1,347 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No
archelle16 1,743 on at

Like (0)

Report

Hi eric, nice to see you around in the community.. keep supporting! hehe :D

Was this reply helpful? Yes No