I thought of that solution, but was attempting to avoid it. I guess it might come down to that. It won't be overly difficult, I have full access to the database and all. It just seems that I have seen something like I'm trying to do somewhere.
Thanks again.
Darrin
I've been trying to figure this out. Any ideas?
How about I ask it a little differently. I swear I've seen this before, but I'm having a major mind blank.
What I am trying to do is to re-create a timesheet that looks an awful lot like an Excel spread sheet.
Something like:
|Day | Date...
Thanks for all of the help. The problem was an oversight on my part. The dates in the database spanned much greater periods than I thought. The code works just fine. It took various instances of test codes, but I finally tracked down the problem.
Now, I'd like to do it a little differently...
This is the formula that produces them all on one line:
whileprintingrecords;
datevar startday := Date({CCalendar.periodBegin});
datevar endday := Date({CCalendar.periodEnd});
datevar currday := startday;
stringvar dayname := '';
While currday < date(DateAdd("d", -7, endday)) Do
(
dayname...
Hi Steve,
Thank you for your reply.
I have tried that, but, even if I loop it only once, I get the error that a string can be, at most, 254 characters.
Thanks,
Darrin
I'm having a little trouble wrapping my head around this one for some reason. It seems real simple.
Crystal 8.5
I am attempting to take two parameters, a start date and an end date, and display all of the days between them. The problem I'm having is that I want them in a vertical list, not...
Hi Sheila and Mark,
First off, my report was for Crystal 8.5, but they seemed to have broken it with one of their fixes too. Thanks for the heads up though Mark.
And Sheila, again, in 8.5, the CR does not count as a character at least in my reports. I had one that had a needed line length of...
Thanks for the thought lbass, but that function results in the same problem, where if I leave off the carriage return, it leaves the spaces out.
Thanks again.
Darrin
Hello,
I'm using Crystal Reports 8.5. I have successfully set up text exports many times in the past and have always and still feel that there is a large degree of "dumb luck" at times in getting these things to work.
Thanks to a great thread on here before about getting a text file to have...
Hello crzycrystlgrl,
The following thread may help you.
http://www.tek-tips.com/viewthread.cfm?qid=803742
I have used the same printer setup for all of my text exports. I added a printer called, cleverly enough, Crystal Reports printer.
Good luck!
Darrin
I *finally* got around to using your suggestion and it worked!! Thanks for the heads-up and the valuable info to add to my Crystal Mental ToolBox.
Thanks again,
Darrin
Thanks Mark!
I haven't had a chance to try to implement this, but I look forward to finding out if it works. It sounds like it will.
Thanks again,
Darrin
Thank you, MrBill for responding,
I have used those types of formulas for all of my other fields and this one is going to be the padding at the end. Does this mean that there is no way to export additional spaces at the end of a line without going to Rich Text?
Just curious, since that will be...
Hello all,
I am experiencing a similar problem. Did you figure out a solution? Does anybody have any ideas on how to force some spaces to the end of a line?
Currently, my last formula field in a text box is:
stringvar spacestring := replicatestring(" ",30)+ chr(13);
spacestring;
This is just...
Hi,
I am designing a fixed-width export report in Crystal 8.5.
I have used the formula:
numbervar requiredlength:= 35;
stringvar Address1:=trim({EInfo.address1});
numbervar currentlength:=length(Address1);
If currentlength < requiredlength then
Address1 + replicatestring(' '...
Just curious as to what might be causing this and if anyone else has noticed this behavior. Given the following code for a fixed length field:
NumberVar reqlength:=9;
NumberVar currlength:=0;
if currlength < reqlength then
replicatestring(" ",reqlength - currlength)
else...
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.