Updating Parameters through a subreport 2

[BHolly]

I'm not sure if this is necessarily a 'formula' issue, but figured I would start here.

We have reports that rely on upwards of 80 parameter selections, so I am trying to break it down and make it more user friendly. It would also ease our scheduling efforts (which are currently impossible). I am trying to figure out a way that I can automatically update parameters through a subreport, which is then linked to an Excel file.

The parameters that I am trying to update originate in SAP BEx queries. If the values themselves were query output, it looks like I would be fine by changing the 'List of Values' in Parameter/Edit to 'Dynamic', but we haven't found a way to populate BEx with the required selections either. Loading an Excel file directly to BEx might be an option, but we will be hard pressed from a Co Policy standpoint loading directly to Prod...

Here is a refined example of the data that I am trying to select on:

PLStatement ProfitCenter SalesOrg Brand
CN001 44000,45000 KAPL,INV 01
CN002 54000,55000 FOSH,SHAN 01-20

Right now I have to select Profit Center, Sales Org, Brand, etc. to extract my CN001 statment. I would like to reverse that and select only CN001, and then have the associated values flow through and automatically populate.

Has anyone experienced a similar problem? Any recommendations or additional resources would be greatly appreciated.

Brett

 

[beltmanjr]

Having trouble understanding what your input is, where it comes from and what you want to do with it. Perhaps you could reword? And what are SAP BEx queries and how do they generate your parameters... and if they contain all the 80 something parameters, then what is crystal's role in this all?

 

[BHolly]

The input is an Excel spreadsheet that is linked to the Crystal report through a subreport and shared to the main report. Hoping to populate parameters through those shared variables.

BEx queries are extractions from SAP R3 data into an Excel form. It allows us to define our selections and extract very specific data from millions or records contained in SAP. The reason for the number or parameters is the granularity of the data, and those 80 parameters create several reports within a report.

Crystal's role is to format the query results for Financial reporting purposes, so P&Ls, Balance Sheets, etc. The query results are very rudementary and need to be "prettied" up for senior management.

It looks like I can populate parameters from the query results, but not from the spreadsheet. Guessing there is a relational issue that I need to work around if possible.

 

[lbass]

Ordinarily you would link the subreport to the main report on a parameter or a field in order to filter data. Is that something you have tried?

-LB

 

[BHolly]

No, I've never linked values from a subreport to a parameter, only other value files. Any recommendations on how I can do that?

That might give me the solution, as long as I can link to parameters that originate in a different source system...

 

[lbass]

Go to edit->subreport links and look at the fields in the main report to locate the main report fields or parameters, and then in the lower left you can use the dropdown to choose a corresponding parameter in the subreport (if you are trying to link parms to each other), or you can link to a parm (or field) from the main report to a subreport field. I'm not quite clear which you want to do.

-LB