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 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: *
- Users: APB-Reports
- Order by date
-
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...- APB-Reports
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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...- APB-Reports
- Post #2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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...- APB-Reports
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Data Display issue and the "\" Character
Excellent!- APB-Reports
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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...- APB-Reports
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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...- APB-Reports
- Post #6
- Forum: Business Objects: Crystal Reports 4 Other topics
-
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...- APB-Reports
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
