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 Mike Lewis 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. LadyJAG

    Using Two Parameters with an "OR"

    Is there a way to set up the report so that only one parameter or another can be selected? I have two parameters one called Segment and one called Lateral both with drop down lists. Is there a way to only allow the users to select one or the other? Thanks
  2. LadyJAG

    Total in Group Header and Report Header?

    For the Report Header I created a formula field sum({WellsTiedIn}) and for the Area Header I used sum({WellsTiedIn},{Area}) Works like a charm.
  3. LadyJAG

    Total in Group Header and Report Header?

    Never mind, I figured it out.
  4. LadyJAG

    Total in Group Header and Report Header?

    I'm using Crystal xi and a native connection to an Oracle Database. I have a report with two groups (this is an on demand sub-report) RH GH1 - Area GH2 - GroupType I have a field in the Details called WellsTiedIn, the value of this field is 1 or 0. They want me to put the sum of this field in...
  5. LadyJAG

    SubReport Different Page Size than Main Report?

    Thanks LB... so it would work the other way around if the main report was legal and the sub-report was letter sized?
  6. LadyJAG

    SubReport Different Page Size than Main Report?

    In Crystal XI can a subreport be legal landscape when the main report is letter landsape?
  7. LadyJAG

    Group Formula

    Thanks so much rosemaryl, that worked perfectly!
  8. LadyJAG

    Group Formula

    I am using Crystal 8.5 with an ODBC connection to an Oracle database. I'm having a problem with some formulas that determine if a specific type of service has been found in a group and changing the number of decimal places in the subtotal in the group footer if they have been found. In the...
  9. LadyJAG

    Apostrophe in parameter

    Tried that, it doesn't work, says failed to open a rowset.
  10. LadyJAG

    Apostrophe in parameter

    Hi Folks, I'm using CR 8.5 and a Sybase 12 database. I am using a stored proc to return data to the report. One of the parameters for the report is a string which is a company name. I am trying to run a report for a company called: Marketing D'Energie HQ Inc. The apostrophe is screwing up...
  11. LadyJAG

    Varchar2 Field Read as Memo

    I'm using CR8.5 and an Oracle10 database through an ODBC system DSN connection. I'm using an oracle stored proc to bring back a record set to the report. One of the fields I'm brining back is a varchar2(60) field. Crystal seems to think that this is a memo field so I can't group on it. Any...
  12. LadyJAG

    Format Text to Time

    Change HR := totext(truncate(NHR)); to HR := totext(truncate(NHR),0); The 0 indicates 0 decimal places.

Part and Inventory Search

Back
Top