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!

  • Congratulations strongm 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. jim789

    Subreport formula group only showing discrete values

    Thanks LB, You've answered the main question I had about this report. It's apparently not a fundamental type of error in which CR9 does not handle this type of formula function as a group field. There must be something else somewhere in the report which is causing the glitch. I'll continue to...
  2. jim789

    Subreport formula group only showing discrete values

    Hi again LB, I tried the link both ways, checked and unchecked, and with the correct subreport formula as you mentioned. No difference in the output. The report would work if the formula only specified: if Left({wjsmas.ELCNUM},2 ) = "S-" then "Collections" else if Left({wjsmas.ELCNUM},2 ) =...
  3. jim789

    Subreport formula group only showing discrete values

    Hi LB, Yes I did link the formula field to the the same field in the subreport. The formula field is "@Opsgroup". The only option I got on the subreport parameter field list drop down was listed under Parameter Fields as "?Pm-@Opsgroup". This is apparently created by Crystal since I only put...
  4. jim789

    Subreport formula group only showing discrete values

    Hi LB, Thanks again. I was trying to attach a .pdf file of the report but couldn't get it to go. Can I e-mail it? I'm not sure what you mean but I've done quite a lot of experimenting with the links. The linking utility only has options for linking various fields as far as I can tell. These...
  5. jim789

    Subreport formula group only showing discrete values

    Thanks for looking at this, LB. I tried your suggestion of removing the link on the third field. The result was that it output each of the first group sections on the second group, so instead of one subreport print based on Group 1 there were several. It printed out all these for "Collections"...
  6. jim789

    Subreport formula group only showing discrete values

    Now can I say "Help!!!"? I'm working in CR 9. I've taken the Seagate Advanced Report Design course and have some limited knowledge of code from long ago programming courses. I am grouping a report and very similar subreport on three fields. They have the same selection formulas on an ODBC...

Part and Inventory Search

Back
Top