Grouping on information from Sub Report

[techie2]

Hi,

Using CR 10.0

Main report is pointing against SQL Server DB.
Sub Reports is pointing against Oracle database.
Both reports are linked by cost center.

Sub reports pulls names of VP's based on Cost Center.

I want to group on this VP name on the main report.

Is it possible?

Thanks in advance.

techie2

 

[Turkbear]

Hi,
any reason the VP report cannot be the main one?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[techie2]

Main report only have cost centers and does not save VP's names on the database

For getting VP names, sub report is going against Oracle DB and displaying the VP name.

Next part of the requirement is group by VP name and display the subtotals.

VP report can not be main report becuase main report takes around 1 minute to run. If I change Main to Sub and Sub to Main report, it takes forever to run.

Any advice or is it possible atall or any work around??

Thanks

techie2

 

[lbass]

You cannot group on a subreport value. Is it the case that each cost center only falls under one VP? Are the VP and their corresponding cost centers fairly stable or do these change frequently?

-LB

 

[techie2]

Thanks LB

They do change quite frequently.

Do you have any other suggestions to get this implemented or this is just not possible.

I know I can do that by having a lookup table but then updating that lookup tables is almost impossible.

techie2

 

[Madawc]

Is it feasible to reverse the report-subreport relationship? Have the subreport as the main report and calling the other?

Or even have both functions as subreports within a 'frame' report?

Failing this, if you put your hard-coded group within a single formula field, this would minimise the work in changing it.

Another possible solution is to create a Stored Procedure, which would use SQL to assemble the data in the form you want it. That assumes you have SQL on your machine, or can get it installed. And that it can read the Oracle database, which is something I have no idea about.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10