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 strongm 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: *

  1. BigDarrin

    Display a list of days

    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
  2. BigDarrin

    Display a list of days

    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...
  3. BigDarrin

    Display a list of days

    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...
  4. BigDarrin

    Display a list of days

    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...
  5. BigDarrin

    Display a list of days

    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
  6. BigDarrin

    Display a list of days

    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...
  7. BigDarrin

    Exporting Report to Text

    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...
  8. BigDarrin

    Further Text Export Questions

    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
  9. BigDarrin

    Further Text Export Questions

    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...
  10. BigDarrin

    Exporting to text file

    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
  11. BigDarrin

    Exporting Report to Text

    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
  12. BigDarrin

    Exporting Report to Text

    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
  13. BigDarrin

    Exporting Report to Text

    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...
  14. BigDarrin

    Exporting Report to Text

    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...
  15. BigDarrin

    Fixed Width - Spacing

    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(' '...
  16. BigDarrin

    Replicatestring Adding an extra space

    Sorry, I forgot to mention that it is Crystal 8.5.
  17. BigDarrin

    Replicatestring Adding an extra space

    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(&quot; &quot;,reqlength - currlength) else...

Part and Inventory Search

Back
Top