Crystal reports: passing DATA to main report

hey everyone:

I have a report with a number of subreports which basically contain ranking data with ranks stores in certain catagories. What I would like to be able to do is at the end of the report, take all of the store_ids that show up on the subreports, and total up their rankings for one aggregate score.

This involves sending data back from the subreports to the main reports, and I would need to pass both the store_id and ranking number.

Is there a way to accomplish this with the current report setup? The one idea I had is to use a shared array for each subreport, and at the end of the report I can handle each array, but that would involve looking for matching store id's, and since i am NOT a programmer, that would take me a long time to accomplish.

so if anyone has any simpler solutions, i would really appreciate it.

edit: Crystal reports 8.5, fwiwWhat is the difficulty you are facing with comparison?
Give more details

Crystal Reports Images

I am currently using CrystalReports 9.0 and I was wondering if there is a way to make a picture appear if certain parameters are met. For example, if an employee ID = John Smith, a picture appears. I know how to put a picture on a report as well as how to use a blob field, but I can't seem to find a syntax that when a certain parameter is met, the image appears. The image is a system file. Any help would be appreciated! Thank you!Right click on the image field
Goto Format object and in the suppress click x-2 button and write this code

Parametefield="yourvalue"

Crystal Alerts but in Reporting services

In Crystal Reports you can setup Alerts to alert you to a certain criteria when ever you refresh the report..

Is this possible within Reporting services?

If so how do you set them up?

Thanks

I'm not sure how well it would work for you because I am not sure of your criteria, but you could add a reference to System.Windows.Forms and then add code to the code window that displays a message box if certain criteria is met. If you can give me an example of your criteria I can try to give you an example.

Simone

|||

Hi Simone

Its a really simple criteria

In crystal I have setup

Sum ({@.Euro to Sterling GP}, {ACCOUNT_NAME}) < 25.00

Thanks for your help

|||

This is somewhat of a hack, but it should work:

Add a reference to System.Windows.Forms
In the code window, add a function similar to the following:

function ShowMessage(value as decimal) as decimal

If value < 25 then System.Windows.Forms.MessageBox.Show("Your Message")
ShowMessage = value
End function

In the field where you have the summary:

Add the following expression:
=Code.ShowMessage(Sum(FieldToSum,ScopeName))

I hope this helps. I've never used alerts in Crystal, but this will show a message box. You could also change the color of the field by using an expression if this is a better option for you. You may want to set a variable to only show the message once if multiple values are < 25.

Simone

|||This is not possible with Reporting Services. If you use the ReportViewer control you can trap events but not down to the data changes. With web reporting and rendering the report in a frame, you may try to get try to get a reference to the field but to track the change you need to track the old value so it will hairy.|||Thanks guys for all your help|||

I see that this only works in the development studio. I wondered how it would behave when displayed through IIS.

Thanks for the explanation.