Reporter Merge query function, load doesn't work? (Reporter Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 26 SEP 2000 10:30:05PM Scott,LMS wrote:

Reporter Specific

Hi All

Gee I hope somebody still looks in here.

Our client wants to use Reporter for adhoc reports. We are trying to teach them how to use it, based on the manual and online help.

There is a function in the query info called "merge" which looks quite useful but doesn't seem to work.

What are we doing wrong.

We create a report based on the CAR table

We put a selection criteria to select all TOYOTA type cars

criteria looks like MANUFACTURER=TOYOTA"

we save that report TOYOTA.rpt

we close the report then

create a query to select all 4WD type cars

save query as 4WD.RPT

criteria looks like DRIVE=4WD"

save and close query 4WD.rtq

Then we go back and reopen TOYOTA.rpt

then we try to merge in 4WD.rtq

tools|query

when we click on MERGE

and select 4WD.rtq

and click on LOAD

the query dialog comes up and CAR is the available table

But the criteria hasn't changed from MANUFACTURER=TOYOTA'

and the report preview reflects this too.

How do we get the combination of TOYOTA and 4WD when the merge/load function doesn't appear to do anything?

Scott, LMS

At 27 SEP 2000 07:40AM WinWin/Revelation Technical Support wrote:

Scott-

We still look in here, so do many others.

We've also experienced trouble with the Query function in the reporter.

What we do instead is that in the program that calls the reporter, we run an Rlist statement and save it to the lists file. eg

RUN RLIST('SELECT CAR WITH TYPE=4WD", 4, 'CAR_LIST':@STATION, , )

We than call the reporter, either via the repository call or using Utility(RUNWIN).

In the report itself, from Tools-Query-Selection Criteria we change the language to Basic+, and the formula is GETLIST CAR_LIST@STATION

Hope it helps-

Mike Ruane

At 27 SEP 2000 09:37PM Janet Scott wrote:

Hi Mike

I can see how that would help when calling the report from code/sysproc thing but I'm not sure how that solves the problem when our end users are in the reporter designer building their own adhoc reports.

They cannot run an RLIST.

We did find one work around - ie create your query and save it to file then when you create a new report, select your previously saved query as the data source instead of an open insight table.

That works but wasn't exactly what we had in mind.

Scott, LMS

View this thread on the forum...