Formulas 1

[DirtyB]

I'm pretty new to Crystal Reports. I am having problems finding documentation and resources for formula syntax. Does anyone know where I can find good online resources for formula syntax. All I am trying to do is make a formula that can group together several fields from a database.

any advice would be appreciated

Thanks

 

[lmbean]

What are you trying to group? Fields that already exist in the database? if yes then just go to insert on your menu and choose group then it will give you a dialog box to choose which field you would like to group on. You can insert as many as you like.
example :
G1 Region
G2 State
G3 City
Detail section customer name address phone

As far as formula syntax - go to online help and search for functions - you will have a listing of all functions that crystal uses and it will explain what each functions does and most give examples of the code.

Hope this helps

 

[DirtyB]

Let me try to clarify a little. I am doing a survey. My database is set up so that each record represents a survey, and each field represents a question. So the data in each field is the answer to the question for that survey. So let's pretend that I have a series of questions where the possible answers are the same i.e.(agree, disagre, no opinion). I have three questions in a row, where those are the only possible answers. So, the field names are "Question1, Question2, Question3", and the data in those fields could be a string either("agree""disagree""no opinion&quot. Now I need to make a cross-tab in which the row headings, are the name of the questions, and the column headings are the possible answers(agree, disagree, no opinion). The cells should be the count of surveys who answere accordingly to each question...


agree disagree no opinion
question1 45 33 21
question2 10 85 03
question3 14 27 35



that is a visual example of what I need to do. I was under the impression that I had to create a group which encompassed all three fields(questions). I would just do it manually, but there are TONS of questions so I need to make a cross-tab I think.

 

[kenhamady]

You will need one cross-tab per field.
Make one cross-tab with each question as both the column field and the summarized field (No row field).

Do a separate one for each question field. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)