Not Sure Where to Begin

[plyon70]

What I have to do is take data from a SQL View, then use a ddf file, then create the report. Pretty straight forward at first. Here is where my problem lies. Since I cannot use unions in a view and that is what the software looks for that is out. I was able to get the desired result using subreports in Crystal but then my problem lies in the 3rd party application and reading the date/time field for the report. It will not read it in the sub reports.

My solution was to use groups then formulas to calculate or say what data in each report group I wanted. Say you had sales. You want all sales from one revenue center to be on one line as a total and all the rest on the next line to total together. How do I do this?

I have tried to use the selection expert but where I run into problems is that you cannot select a value for one database field in one group and have it be another in a second group.

I know there has to be a way to do this. I know this post may sound a little scattered and I apologize ... Just going on three days now w/ no solution.

 

[Trainingjason]

Not a hundred percent sure but

Create a report / sub report, create formulas as linking fields between the 2 reports, slow but works. Not sure about the date, could be need to convert to date. If you are trying to pass data between report and subreports need to use a shared variable. The main report has to be above the sub report in order to pass.

regards


Jason

 

[plyon70]

As I said previously subreports will not work in the third party application. Looking for another way other than using subreports. I already have one created using subreports but does not work in the application.

 

[ShortyA]

Depending on your version of Crystal Reports (CR8.0 allows this) you can amend the SQL query to relate tables there and add the selection criteria for the tables. Create and test the SQL query in something like SQL Query Analyzer or equivalent and then insert it via Database menu/Show SQL Query. In the query you should be able to create a field that has a value from either table1 or table2. Essentially you are then using Crystal Reports for the presentation layer only and the SQL query to bring back the data in the format you require.

Hope this helps.
ShortyA