Impromptu Report Question

[fuhbar]

I want to create a crosstab in report. In this case I want to use the result of a query as a new field (e.g. Volume) in the crosstab. It would be the best if the query could be an Impromptu report.

How do I get there?

Thanks
F.

 

[Prasad678]

can u explain a bit more

Prasad
RPrasad1@Chn.Cognizant.com

 

[GoldFoxtrot]

Try this: 1)create an impromptu report, save as A.IMR. Save it again as a hotfile A.IMS. 2)In your new report change the data source from Hotfile instead of the standard default of 'catalog'. Pick A.IMR (not A.IMS). Hope it works for you.

 

[fuhbar]

I will try.

To explain it better:

In MS Access you have a query, but to avoid wrond values you have to pre calculate some values in another query. So you have 2 queries, one main query and one supporting query.

I do not know how to build this in an IMR report.

@GoldFoxtrot:

Will the ims File be updated everytime I run the main report ?

Thanks
F.

 

[DoubleD]

Depending on what you want to calculate, you may not need a second query at all. You can associate summary fields to a specified level in Impromptu (unlike Access).
If you show us a sampling of the fields your using, and the values you expect, we should be able to help you.

Pain is stress leaving the body.

DoubleD

 

[GoldFoxtrot]

An IMS file is called a "Hot file" in Impromptu. It is a result set, a created file you saved in a Windows/Explore folder. You can then use it as the data source instead of an "Impromptu Catalog" to create your main query (report). The IMR that creates the Hot File is like your 'supporting query'. I believe you can use either IMR or IMS as your data source in creating a new (main) report. To make the IMR automatically save as IMS, you need a simple 'Macro'. When you run the macro, it execute the IMR and does a save to IMS. I would use IMS first unless the query result changes frequently. Or you can include all the above mentioned tasks in one macro: the support IMR that creates and saves as IMS, the main IMR reports from the IMS. That's what I used to do all the time. In my current new work site, I do not have Impromptu installed, OTW I would verify if I can report from an IMR for you: run main IMR which triggers the supporting IMR without a macro.

 

[fuhbar]

thanks,

I will try it this week.

F.

 

[fuhbar]

Today I tried to make a "support-Impromptu report". From this report I needed an id-field and a summarized volume field for my main report.

So I linked the support report (imR file) with the main report through the hotfile option.

Apparently the main report works the way I wanted it to do. Furthermore everytime I run the main report, the data from the support report is up to date. I hope this will last.

Thanks for your help
F.