Ok I will try and explain further.
In the field explorer the field shows as a "number". I then insert it into my report in details, and when I point the mouse on the field it says "string". When I try and format the field to 2 decimals, I do not have the "Numbers" tab in the Format Editor.
If...
I am using CRxi with a xsd schema file and xml file in Visual Studio DOT.NET.
In the Field Explorer window the fields show as numbers, but when I insert them in my report they show and act like strings.
I cannot just use the ToNumber formula because that will ruin some of my other formulas, so...
Thank you all for your suggestions.
Rrgkanth, the three fields have been grouped and for clarification I will try and give you a better idea of the report setup below.
BobSuruncle, I tried your solution with a unique combo, but ended up in the same place, without being able to sort the data in...
Using CRvXI,
I have a report with three data fields, which are all grouped.
Then I have a forth "row", which counts the number of shots made with each combination. Each group is sorted in its original order.
Player Club Ball Shots
John Titleist Srixon 4
Peter...
Hello again,
jleboef, thank you for your suggestion, but I ended up using the suggestion from lbass, which suited my report better.
Lbass, you are my star. A pure genius!
Thank you!
Using CRvXI
I have a report that contains a field "Club" and a field Average Carry (average of a database field named Carry). For every Club it lists the average carry for each Club. So far so good.
Now I would like a way to list the difference or gap between two Clubs. Is there any way I can...
Lbass,
I got it!! Thank you.
I do not know why making a simple summary on Ball gives me the right number but never mind. To put the summary for ball in the Details section I just made a ToNumber (Count ({Stroke.IdentifierData.BallType}, {Stroke.IdentifierData.BallType}));
which worked fine...
Lbass thank you for your reply.
I will try and explain in detail.
I have three data fields.
1) Player
2) Club
3) Ball
I have grouped each field Group 1 (Player), Group 2 (Club), and Group 3 (Ball), and put them in the Details section. Each group I have Suppressed if Duplicated. This gives me...
Thank you lbass,
The last solution your suggested worked fine for counting two groups using
Count({Stroke.IdentifierData.PlayerName},{Stroke.IdentifierData.ClubName});.
Is there any way I can include the third group ({Stroke.IdentifierData.BallType})??
As for your first suggestion, I do not...
Using CrvXI
I have a report with 3 groups. I have made a running total (Total shots), which evaluates every record and resets after change of Group 3. It gives me something like this:
Player Club Ball Total Shots
Jack Titleist Titleist 1...
Hello Turkbear,
Thank you for your reply. Unfortunately it did not do the job. Somehow it seems as if CR still interprets the number data type from the schema file as a string. Allthough I can add as many decimals to the number as I like, but not format it in any other way.
Can I use another...
Using CRvXI
I am using a xsd scema file as my data source, where some of the datatypes are strings and some are numbers.
In CR I can see in the Database field that the datatypes are Numbers but I cannot format them as numbers, i.e. no matter what I do to the number it is only displayed as in...
I am using CR XI.
I have a main report containing a subreport. The subreport has a box stretching from Group Header 1 to the Report footer. I have done this to make the box go to the end of the page instead of just surrounding the dataset. When viewing the report, I am using as subreport, as a...
Using Crystal Reports ver XI.
I have a report with three different groups: "Player", "Ball" and "Club". The report changes page for every combination of the three groups. So far so good.
Now, I want to do a Running Total which resets if either of the three groups changes. I have tried it with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.