Crystal 10 Shared Variables

[elf1]

I am having an issue created shared variables in Crystal Reports 10.

I am used to using the following in Crystal 8.5:
Shared NumberVar VARIABLENAME

I know this has changed in Crystal 10 but am unsure of what the proper way to do this in Crystal 10 is.

Thanks!
Rick

 

[lbass]

The same syntax applies in 10 as in 8.5.

-LB

 

[elf1]

hmm...... I created a formula in Crystal 10 and made it:
Shared NumberVar myTotal

When I try to save it gives me the following error "the remaining text does not appear to be part of the formula" and highlight myTotal

 

[lbass]

I just tested this in CR10 and it worked fine, so I wonder if the problem is that you are entering this in the wrong formula area? Where are you creating this?

-LB

 

[elf1]

Thanks for your help LB.

I am clicking on formulas and then creating a new formula called 'sharedtest'.

This bring up the formula as
"formula = "

I've tried placing the shared numbervar after this and clearing this out and putting the shared numbervar in. both times I am getting the same error.

Should I be creating the formula a different way?

 

[lbass]

Okay, the problem is that you are mixing syntaxes. formula = is Basic syntax. Change the setting to CR syntax in the formula editor and then enter the variable as before.

-LB

 

[bether]

Hello,

I’m developing a Crystal report using Visual Studio 2005. My datasource is tied directly to the database table.
The database table has the following columns: Group, Subgroup, and CompanyName. Sample data is as follows:

Group Subgroup CompanyName
ABC Example Example Co
ABC ABC ABC Co
ABC Another Another abc Co
XYZ XYZ XYZ Co
EXA EXA EXA Co

With the example data above, its saying that Group “ABC”, has 2 subgroups, “Example” and “Another”

In the report, I would like to display it in the following manner:

Group Company Name
ABC ABC Co
Example Example Co
Another Another abc Co
XYZ XYZ Co
EXA EXA Co

I was able to create it in this manner by creating groups (one for Group column, another for Subgroup) using the Group Expert. It is grouping it correctly. However, the company name showing for ABC is not ABC Co, but Example Co. It seems to be taking the first occurence of CompanyName from the database that has a Group ABC. In this case, it is "Example Co" (see following).

Group Company Name
ABC Example Co
Example Example Co
Another Another abc Co
XYZ XYZ Co
EXA EXA Co


How can I have the report display the correct name for Group "ABC", which is "ABC Co"?

Thank you so much for your time.

 

[bether]

please ignore previous reply. i meant to create a new thread.sorry.