I have one Crystal report with 6 sub reports inside. I need 3 reports to print out in landscape and the other 3 reports in portrait. Can this be done in Crystal report?
I have a report with one input parameter. I need the default parameter value to be todayDate - 7 if the field is blank. Is there a way to set this field to have the date in the report when it is first open?
Can I set a todays date - 7 inside thi...
I have a report that is has a a lot group footer. I need to sum up the data in Group Footer 5a and place the total in group footer 3. I need to sum up column:
Current Actual Cost (TOT_SALES_SCHED)
Estimate Cost (TOT_ACTUAL)
When I use running ...
Hello everyone,
I have a Crystal Report that has a formula field to get the data from three fields. The order is if {AJ_D31.ALPHAVALUE} is blank then {PPJOBD.DATE_PROMISED} else currentDate.
{AJ_D31.ALPHAVALUE} is formatted in the sql server as ...
I have a report that expects a number and dotted line to match a field called qty_required.
I created a formula field but the qty_required number can be up to 100 and I didn't want to write 100 if statements.
This is what I currently have:
if...
I see the problem with the calculations, the GF5a section has suppress logic and the total is for all the records. Is there a way to calculate only the data visible and not the suppress records?Here is the suppress logic:if {?Summary Only} = 'Yes' th...
This worked for the field highlighted above. I tried to use this running total for the field Estimate Cost and it didn't work. Can you help calculate that total?
When I tried this I get an error that the last line error 'the remaining text does not appear to be part of the formula. I have the result in the parathesis and get a True result.