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

    charting with multiple subreport shared variables in the main report

    Do you need a chart per group or one for all groups? If the chart is per group will it just contain 4 values - so 4 bars or pie slices for example? Another simple solution would be to create another subreport with an sql command. In the sql you could write 4 union all queries and just return the...
  2. APB-Reports

    charting with multiple subreport shared variables in the main report

    Hi J, I have had a similar issue before. Share the sub-report values with the main report like: //Sub report 1: WHILEPRINTINGRECORDS; Shared NumberVar sub1 := (IF ISNULL({yourdata}) THEN 0 ELSE {yourdata}); //Main report: Shared NumberVar sub1; Then pass these values back into a new...
  3. APB-Reports

    How to Center the report object horizontally (wrt page width) in Crystal Report 2016

    I like to create a wide text box in a suppresssed header section. Resize the text box so it is the width of your page. Then you can hold down ctrl and click each of your text boxes and finally ctrl click on the wide text box in the header. NB: You need to do this last. Then right click the...
  4. APB-Reports

    Data Display issue and the "\" Character

    Do you have rtf text interpretation enabled for that field? I think \def may be an rtf tag. At least \deff is. This issue would be very unlikely though. I tested entering your text in a formula and had no problems with all possible settings. Try setting the field to grow - perhaps there are...
  5. APB-Reports

    Crystal XI - hide group header if no detail rows

    Try and create a formula: sitecode_check Add this to the formula: if isnull(maximum({Call.CallDate},{Call.SiteCode})) then 'SUPPRESS' ELSE 'OK' Then place this in the sitecode header. If the formula produces: SUPPRESS then you can easily suppress that header with this formula in the suppress...
  6. APB-Reports

    Crystal Reports 2013 -sql expression

    Hi Patsy, I see two issues. RE: (SELECT SUM(LABOR_HOURS) FROM WO_TASK WHERE WO_TASK.WOO_AUTO_KEY=WO_OPERATION.WOO_AUTO_KEY and not(WO_TASK.SYSUR_AUTO_KEY in [125,126,127,129,130,132,131,249])) You should assign your sum a column name otherwise it will be automatically generated and probably...

Part and Inventory Search

Back
Top