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.
I don't know how you can do it in the mailing label template, but you can group or sort (depending on your data) by client and just fill the page with your desired text. Use the main part of your current report (the white part) to determine approximately where to end each column of data.
Is this an NT domain or 2k? Do you have domain controllers in other locations? How do you connect your locations (ie Frame relay, DSL, ISDN, etc)? Do you have anything in place that would prevent traffic at certain times of the day (such as ports 135-139)?
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.