How many shared variables are available?

[SarahMS]

I have multiple subreports, and I need to pass the number of records in each subreport back up to my main report. I will have 50+ subreports on this report - can I use this many shared variables?

 

[BlurredVision]

I don't see why not... I've never seen anything saying that you can't. This one report I would love to see. Brian

http://www.crystalinfo.net

 

[SarahMS]

Thanks for the response - I just didn't want to get halfway through it and find out that there was a 20-variable limit to Crystal

BTW, you really *don't* want to see it - this is only part of one page of a six page report

 

[BlurredVision]

Boy.. That's sounds like some report. If you do find any limits.. Please let us know Brian

http://www.crystalinfo.net

 

[Nimrauko]

Have you try to use 1 shared array?

 

[Ngolem]

Just curious....why so many subreports?

 

[kenhamady]

Sarah,

I think you will run into a limit on the size of the container, before you run into limits on shared variables. I don't know exactly what it is but I have heard of people running into this limit when they try to add more than 20 subreports, expecially if running this from an application. I would do a 'proof of concept' to make sure that your quantity of subreports will work first.

Is there no way to combine any of these subreports? If any of them share the same source tables, then you might be able make them one subreport using groups to separate them. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[SarahMS]

Ngolem,

Ho boy - that question has a rather long answer

Abbrievated, my main report is just a bunch of counts - how many cases filed this month of this kind, how many filed this month of that kind, how many disposed this month of that kind, how many of them disposed this month were this old, how many were that old, etc. Originally, I just had two views pulling everything, and had it all on a flat report, but then we decided to try to have a drill-down with each of these numbers so the customer can look at exactly what the records are that are being counted. The only way I know to do this would be to use all these subreports. If anyone has any suggestions, I'm a newbie at this and would welcome them

 

[SarahMS]

Ken,

Thanks for the information. That would not be a fun feeling to run into that limit in the middle of a report

I think with a little working around, I could probably combine some of the reports. Thanks for your help.

Sarah

 

[kenhamady]

Is this a summary of rows and columns with each cell a subreport? What are the rows? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[SarahMS]

I'm not really sure that I understand exactly what you're saying, but I'll give it a shot.

I think the correct answer to your question is yes.

The rows are something like all cases pending first of month, new cases with filetypeA, new cases with filetypeB, number of dispositions, number pending end of month.

The original plan was to have a seperate subreport for each cell. A simplified version of the report might look like...

casetypA casetypeB
filetypeA 2 1
filetypeB 1 3

 

[kenhamady]

My point was that if you can group the main report by FileType, then you can run the same subreports for each group by putting them in the GF and linking them to the main report by FileType. You might need one SR for each column, but not one for every cell. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[SarahMS]

I think I made the example a little too simple - I don't really think that I could make each row a group, because I need to make some of the rows sum off of other rows, and because each of the rows that is not summing from other rows will be linked to a seperate sql view, and I have practically no way to link the views together.

I think though, that it would probably work to create a subreport for each row, and put an alais to the view for each casetype with the selection criteria for the casetype.

Thanks for your time trying to work through this.