Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ronbconfused

    How can i group by Variable parms selected.

    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.
  2. ronbconfused

    How can i group by Variable parms selected.

    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.
  3. ronbconfused

    How can i group by Variable parms selected.

    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.
  4. ronbconfused

    How can i group by Variable parms selected.

    Yes i did
  5. ronbconfused

    How can i group by Variable parms selected.

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

    How can i group by Variable parms selected.

    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...
  7. ronbconfused

    How can i group by Variable parms selected.

    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...
  8. ronbconfused

    How can i group by Variable parms selected.

    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...
  9. ronbconfused

    How can i group by Variable parms selected.

    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
  10. ronbconfused

    How can i group by Variable parms selected.

    i just renamed the parms and i still get the same non result
  11. ronbconfused

    How can i group by Variable parms selected.

    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
  12. ronbconfused

    How can i group by Variable parms selected.

    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}...
  13. ronbconfused

    How can i group by Variable parms selected.

    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...
  14. ronbconfused

    How can i group by Variable parms selected.

    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...
  15. ronbconfused

    How can i group by Variable parms selected.

    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
  16. ronbconfused

    How can i group by Variable parms selected.

    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...
  17. ronbconfused

    Using 2 running totals in a formula

    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
  18. ronbconfused

    Using 2 running totals in a formula

    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...
  19. ronbconfused

    How do i print numeric array elements

    Perfect! thank you
  20. ronbconfused

    How do i print numeric array elements

    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...

Part and Inventory Search

Back
Top