I am using a streamwriter to create a comma-delimited file. When there is no data, rather than writing ",,," it writes ", , , ". I've tried trimming the field and checking for nulls, but to no avail. How do I fix this?
Thanks.
You may want to try creating a variable to use as a running total. Since you have no grouping, you will not need to zero out the variable. So you will need only two formulas. In the details section:
WhilePrintingRecords;
Global NumberVar RunningTotal;
If not IsNull({Table.Field}) then...
You can do either or both. What is it you want to do? If you want to pass a parameter from the main report to the subreport, use sub report linking. If you want the user to enter a parameter for the subreport (sp2), don't do anything. They will be prompted. You did not provide much...
Ok, so in your detail records, use a formula to check for max(NoteID). You will need to use a variable to make sure you don't overwrite it with invalid data.
In your invoice group header:
Formula: ClearGroup1
WhilePrintingRecords;
Global StringVar strInvNotes;
strInvNotes := '';
In your...
Not running Crystal on this machine but if memory serves...
If {?Status} = 0 then
({Command.LICENSE_STATUS} = 1 OR {Command.LICENSE_STATUS} = 2) else {Command.LICENSE_STATUS} = {?Status}
Also, use the "View SQL Query" feature and post that along with your selection criteria.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.