Search results for query: *

you're not going to believe this! the select statement returned something. that makes no sense at all but this isn't the first time i've seen this.

i did verify the db. there's nothing wrong there. I know this is frustrating. I do appreciate your time. you did way more than you should have. i'll try to attack this tomorrow. i'm fried right now. i don't see why the switch function won't work either.

Already did that. I updated the links also. All files are within the same datasource and the parms are single only. This has got me also. i do not understand why the switch function is not working in the 3 formula fields. i don't want to use a stored proc if i can keep this fairly simple.

Yes i did

Would i be better off doing a store procedure for this? i want to stay as simple as possible for futher changes

i know i'm not being too clear. i have all 3 formulas in the detail section and none of them have data in them. to verify that i'm getting data i created a formular called name shich is the first and last names of a salesperson. i am seeing data in that formula. Toanswer your question about...

Now you're feeling my pain. I've been on this for about 6 weeks so i am quit lost. Some are telling me i don't need a record select but i can't see that. How else would i limit the reocords to what i want. The formulas are my problem. also i am writing a line in the group footer. i added the...

I am doing left joins. that was one of my concerns. When i place a field from one of the tables in the detail section i am getting data. Now if i select 'Broker', 'Lease' and 'TGEN' for example i see all the different types of sales people. Like you said there are other areas that they want to...

Here's another thing that confuses me. if i select 'Broker' under what i have now how will only people with 'Broker' in the title field appear without a record select? also why am i not getting any values in the formulas when i can see them in the parms which i list on the report

i just renamed the parms and i still get the same non result

I named them PM-Primary? could that be a problem? The others here want to have a naming convention so that's why i name them that way. I created the parms for the user to select from a list which corresponds to the formula

Sure. I have 3 formulas called Primary, secondary and tertiary. Primary = Switch ( {?PM-Primary}="Lease",{Roles.Role}, {?PM-Primary}="Broker",{Roles.Role}, {?PM-Primary}="TGEN",{Roles.Role}, {?PM-Primary}="Closer",{PersonnelTrans.Title}, {?PM-Primary}="Closer - Split",{PersonnelTrans.Title}...

i have the parms up front so the users can select which category to sort by in the groups. i created the formulas as shown and am grouping on those formulas. i took the record select out since that made no sense and i still get nothing. i think the problem is the formulas since i have the...

no i'm not using a subreport. How would i be able to? the report is way too flexible or can i? Here's what the report needs to look like, bear with me as i go from group3 to 1: Tertiary group tours sold Percentage Secondary Group Primary Group this is a simplistic...

I forgot to add that the formula for the parm selections which i showed a sample of above is not displaying any values which must mean the formula isn't working. i placed the 3 parms in the detail line to see what values they have and they do not have any values

I am on version 10 of crystal. I have a sales report that i have to convert to crystal and i am having trouble. Here's an example of what i need to do: We will allow variable categories selected from the parms drop down and they will be printed as a Primary, Secondary and Tertiary group with...

I just realized this after posting this thread. i was in a running total when i should have been in a formula. thanks for the reply

I need to get a net amount of 2 running totals i have previously defined. is there any way to do this since i do not see them in the report list when i go into the formula editor? i assume i can keep a count of each of these in a formula field and place it in a hidden line but that seems to be...

Perfect! thank you

ok one more question and i will stop. in my list of values i have one coded as 999 to denote All values. How can i place the word ALL in the selection list. i tried an if statement but that is causing the and error on the keyword For. it's telling me a string is required. Here's what i placed...