how to connect a subreport with a main report correctly?

[Kretzer]

Alright,

my main report consists of a cross table.
The structure of the cross table looks looks this...


area 1 area 2 area 3
region1|region2 region3|region4 and so on
|----------------------------------------------------
id nr |value value value value
id nr |value value value value
id nr |value value value value
id nr |value value value value


I hope you get an idea...
As it is not very nice to have the id's on the very left I did groups on the id's. And as I can give each group a name the name of the group is shown instead of the id itself.

All the data for this report are coming from one source.

My problem is now, that I shall now add a value which is not part of my data source.
This new data exists in a different report. Well, I could include it via a subreport but. How Do I do a reference to the value from the subreport into my main report. My aim is to show this value in th cross table as if it were part of my data source...

I hope you get an idea of my problem and that you can give me a hint.

Thank you
Martin

 

[kenhamady]

Unfortunately, there is no way to get a subreport value into the cross tab calculations. Can you briefly describe how you want to use this value in the cross-tab? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Kretzer]

I want to show it as an additional row.

so one more row (in the cross table)

area 1 area 2 area 3
region1|region2 region3|region4 and so on
|----------------------------------------------------
id nr |value value value value
id nr |value value value value
id nr |value value value value
id nr |value value value value
| newvalue newvalue newvalue

SO I guess there has top be a new ID so I can have a reference to the values...

Thank you
Martin

 

[kenhamady]

You could do this with a manual cross-tab, although the number of columns would be hard coded. They are described in my faq on common formulas. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com