Recent content by ronbconfused

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