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

    Supress Subreport When Datatable Returns Same Result For All Records

    Hello, I am using CR 8.5 with a SQL DB. I am printing invoices with a subreport for returning product. I want to supress the subreport if all line items are FINAL SALE and print the subreport if not all items are FINAL SALE. The datatable that returns as FINAL SALE or blank is ORDDET_STR The...
  2. brizaybrizoke

    Subreport Details Not Relaying to Report Preview

    I am using CR 8.5 with an ODBC SQL datasource. I have two identical subreports in the Details section of my report that when run separately display all details/line items. When viewing the preview and when printing not all of the details/line items show up. I have each subreport formulated to...
  3. brizaybrizoke

    Calculate Average of DateDiff

    Crystal 8.5 I need to calculate the average of a datediff and am not finding any previous posts with formulas that work with my report. I currently have three formulas to achieve my datetime and one datediff formula converted to seconds. The datediff is calculating the seconds between two...
  4. brizaybrizoke

    Modify Selection Formula if using 'startswith'

    Is it possible to run the .exe version of my report and prompt for a change to the 'startswith' selection formula upon printing? Currently the report runs as if the 'startswith' formula is saved data. Modify Selection Formula is selected. Save Data With Report is unselected. Crystal 8.5...
  5. brizaybrizoke

    Sort by font color?

    Is it possible to sort data by it's font color in Crystal Reports 8.5? For example, if group header font color is red then bring to top. Thanks
  6. brizaybrizoke

    Sum of SharedVar

    Crystal 8.5 MainReport RH = Cross-Tab PHa = Cross-Tab Subreport 1 PHb = Subreport 2 D = Suppressed RF = Suppressed PF = RH Cross-Tab SharedVar formula AND Sum of All SharedVar I have a sum of three sharedvar in the page footer of my main report that was working as expected until one of the...
  7. brizaybrizoke

    Suppress Duplicates in Details of GroupH 3

    Searched for a previous thread but could not find one/deciper formulas. I'm using Crystal Reports 8.5 I have three groups. The only details are in group #3. Group #3 = AA, BB, CC How do I suppress duplicates in the proceeding GroupH 3 details? GroupH 1 - 100 GroupH 2 - Red GroupH 3 - AA 1 2...
  8. brizaybrizoke

    Subtract Hour or Convert Time Zone

    The field I need to modify is a time formula, {@Time_Formatted} The formula I currently have in place is for this field is, {Ordhead.ORDHEAD_ORD_TIME}[1 to 2] + ":" + {Ordhead.ORDHEAD_ORD_TIME}[3 to 4] + ":" + {Ordhead.ORDHEAD_ORD_TIME}[5 to 6] The time zone that this field pulls is EST and I...
  9. brizaybrizoke

    Use Function as String

    Is it possible to use a function (i.e. printdate) in place of a string? My formula attempt, if {@Rel Date} <> printdate then crRed Formula Editor wants a string because I'm using the <> operation but I want said string to equal the printdate without having to enter a specific date/number...
  10. brizaybrizoke

    Variable Formula for Line Specific Data

    My starting objective was to create a formula to retrieve results for a specific line of data that had no constants. First, I added a record number down the first column to provide each line a constant. Then added a formula down the last column where I want my results. At first I tried the...

Part and Inventory Search

Back
Top