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 Chris Miller 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. purpleanne

    Headings for hidden detail

    Thank you. I thought I looked through all the options but I apparently missed that one. It's CR 9. I knew I was forgetting to include something. Monday morning isn't my best time :) My apologies.
  2. purpleanne

    Headings for hidden detail

    When I have hidden detail lines, when they are drilled down to in Enterprise, the detail shows by itself with no column headers. The headers in "Page header" aren't visible at the same time, so there is no point in confusing the main report with headers for the detail. Is there a way, other...
  3. purpleanne

    Upper/Lower Bound

    The database has a DateTime and the parameter is a date. Should that make a difference? Oddly enough, it works in the other direction. "No lower bound" generates the <= code in the SQL that I would expect. If the service pack doesn't work (and I'm not sure I can install it - I'm a...
  4. purpleanne

    Can I display but not print?

    Thank you. That worked. I would have preferred something that didn't require interaction from the user, but then, we don't always get what we want, do we?
  5. purpleanne

    Upper/Lower Bound

    By the way, the database this runs against is Microsoft SQL Server.
  6. purpleanne

    Upper/Lower Bound

    When I run my report in Crystal Reports Professional 9.2.2.634 and enter my parameters, if I check "No Upper Bound" and enter a date for the lower bound, it returns no records because it generates this SQL clause: AND "CSHJRNL"."DATE">={ts '1999-01-01 00:00:00'} AND "CSHJRNL"."DATE"<{ts...
  7. purpleanne

    Can I display but not print?

    I have a report in Crystal 9 that will be viewed in Enterprise (9 I think). On that report is an on-demand subreport with details. Can I keep that marker for the subreport from printing? It just says "Click for details" on every line, and that looks odd when the report is printed.
  8. purpleanne

    Passing date parameters in Crystal 9

    Does that mean that if I want the report to represent a range of dates, I need to either make the start date and end date separate or have the selection be a formula referring to minimum and maximum of the range? I tried on a report I'm working on to do what you suggested with a range. The...

Part and Inventory Search

Back
Top