Crystal reports - equivalent to MS-Access sub-queries

I'm with you. I much prefer complex queries and simple reports. Epicor doesn't give you much to work with unless you want to do some back-end queries on the Progress core database in 4GL during off-hours since you need exclusive access to the db. I've done a couple like this but what a PITA.

Anyway, so what I do is still use Access for a query tool and have Crystal link to Access through ODBC. It might not work well on big complex reports because it adds another layer but I haven't had any trouble with performance for the reports I've tried. I still go through the Vantage interface so the end user doesn't know any difference. And if this is just for your own analysis, I wouldn't even bother with the Crystal report and just do it all in Access.

--- In vantage@yahoogroups.com, "Bruce Ordway" <cooner_55421@...> wrote:
>
> Hi,
>
> I'm looking for info/examples of using subqueries and/or temp tables in Crystal.
>
> Here is a little of the history...
>
> I have used MS Access/ODBC for a long time to create my own personal Vantage reports.
>
> Other users would like to have these same reports available.
> Most translate with little problem but...
>
>
> Some of these I have not been able to duplicate with BAQ's and/or Crystal.
>
> The most common problem I'm having is that I use subqueries in Access.
> I build a query and then use it as the datasource for another query. I haven't seen an example of this in Crystal.
>
> The one that I'm having the most trouble with is similar to the time phase report. In Access I had to create a temporary table and populate it with records from demand tables. I was then able to compare these records with supply tables. I don't know of any way to create a temp table with Crystal.
>
>
> Thanks,
>
> Bruce
>
Bruce,



I expect you can have more than one connection for Crystal - one to the
BAQ and one to ODBC for Access (I have done this long ago with Excel)
and then link them in Crystal as needed.



Karen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Ordway
Sent: Thursday, August 06, 2009 10:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports - equivalent to MS-Access sub-queries





Hi,

I'm looking for info/examples of using subqueries and/or temp tables in
Crystal.

Here is a little of the history...

I have used MS Access/ODBC for a long time to create my own personal
Vantage reports.

Other users would like to have these same reports available.
Most translate with little problem but...

Some of these I have not been able to duplicate with BAQ's and/or
Crystal.

The most common problem I'm having is that I use subqueries in Access.
I build a query and then use it as the datasource for another query. I
haven't seen an example of this in Crystal.

The one that I'm having the most trouble with is similar to the time
phase report. In Access I had to create a temporary table and populate
it with records from demand tables. I was then able to compare these
records with supply tables. I don't know of any way to create a temp
table with Crystal.

Thanks,

Bruce





[Non-text portions of this message have been removed]