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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: rnd
  • Order by date
  1. rnd

    Multiple ODBC on demand - choice at runtime

    Naturally. It is prompting for all ODBC connections. The user won't have the other two login ID & PWD. I agree this is not a smart idea to handle this on the client side. We can't do it on the server side because each other sub-report is from different server/DB as well but common to all. But...
  2. rnd

    Multiple ODBC on demand - choice at runtime

    Sorry I forgot to mention that Business View or Command Object is not an option either.
  3. rnd

    Avery Label - European versions - L 7163

    I did that before I posted the thread. She couldn't tell me the individual sizes (measurements)for any cut sheet stock label.
  4. rnd

    Avery Label - European versions - L 7163

    CR 9 / SQL Server 2K / Mailing Label Wizard. Do any one know all the dimensions including W/L/margins - inner & outer etc. of the Avery Labels in Europe and more especially for L 7163. I couldn't find it any where on Avery or other sites. If you know any site please point me to it. This is not...
  5. rnd

    Multiple ODBC on demand - choice at runtime

    CR 9/10/11 SQL Server 2K/2K5 (I use them all) I have 4 subreports in a report. One of the sub reports has a different datasource (ODBC/server/database) depending on the Company. Therefore, I have to change this one subreport for each company. Rest of the main & other sub reports are all the...
  6. rnd

    Timestamp in CR 8.5 only shows date

    If it is CR 8.5 you might have the Convert Date-Time field in the File > Report Options (or Options) menu to "To Date" instead of "To Date-Time". You can change the settings in the appropriate menu depending on whether you want it just for this report or for all the reports. You can also...
  7. rnd

    String parsing

    Ooops. I forgot add that I modified LBass's formulas as below and it works well too: stringvar array x := split({Table.Filed},">>"); numbervar i; numbervar j := ubound(x); stringvar y := ""; for i := 1 to j step 3 do( y := replace(y,"<<","") + x[i] + chr(13)); y
  8. rnd

    String parsing

    Thanks for the super quick responses. You guys are awesome. Both formulas work. Lbass's formula still keeps the << dividers intact where as Synapsevampire's formula along with the change for the first record has rectified that through the Replace function and display exactly what I want. Lbass...
  9. rnd

    String parsing

    CR 9 SQL2K I have a memo field like this: <<value1>><<value2>><<value3>><<Value4>><<Value5>><<Valeu6>><<Value7>><<Value8>> and so on. I want to extract every third value looping through from the beginning to the end of the string (like Value1, 4, 7, 10 etc) and display each one on a line with a...
  10. rnd

    Date Value result

    Thanks for the quick response. I was using the following formula (12 of them)for display purposes. StringVar YY := ""; Stringvar MM := ""; Stringvar Value := ""; Stringvar Value := Totext({@CMY1},0,""); StringVar YY := Left(Value,4); Stringvar MM := Mid(Value,5,2); YY + "/" + MM; Your formula...
  11. rnd

    Date Value result

    CR 9 DB - SQL2K Hi all, I need some help. Formula @CMY1 = val(totext(dateserial(year(DateAdd ("M",0 , CurrentDate)), month(DateAdd ("M",0 , CurrentDate)),1),"yyyyMM")) (the value will be incremented through separate formulas for other months). The result of the following formula displays as...
  12. rnd

    Rounding on division

    CR 9. SQL Server 2K. I have a calculated fields with same values (with decimal) displayed in the same row on a matrix (like a manual cross tab). I need to round up one and round down the next (alternate) and so on. Example: ID = 101 Table.FieldLoan value = 10 Number of Installments = 4...
  13. rnd

    Charts in crystal reports 9

    Just select (highlight) the field name in the summary box. The 'don't summarize' button will be automatically enabled.
  14. rnd

    A way around the subreport?

    You can join the same table with an alias to the first table and link them with the alternative field that you are using to link the sub report ( I think that is what you are doing - I could be wrong in making that assumption). Make the main information as the Group and get the data from the...
  15. rnd

    Report Export Formats - Remove 'frame formatting'?

    You have to use CR 8.5 and export to Word for 95 to get the "natural" formatting. CR 9 & 10 - tough luck. In CR XI the editable text format exports are back.
  16. rnd

    Mailing Label Type

    CR version 8.5, 9 & 10 DB SQL2k Do any one know the settings for Avery 4019,4020, and 4065? These are "Pin fed labels". I checked in Avery & Crystal sites of no avail. Neither one of them is a big help in other forms of contact either. I need the page margins and Gap between the labels...
  17. rnd

    Can I change the Label Type in a existing Label Report

    Lucky you are using 8.5. Report Expert is not available in the menu in CR9 or 10. You can find the steps to add a new label type in Crystal KB - Article ID: c2005462 under the title "Adding a new label type to the Mail Label Report Expert". This was written in 2000 for CR7 but is still good.
  18. rnd

    Need to reset DateTimeVar to null

    Hi Ken, Pardon me. This is question related to the original issue. If you want to add the date to display (like a running total) using a formula the variable requires a number. How would you takle the problem. For example: We are going to use a formula @MaxDate @MaxDate = If Amount =...
  19. rnd

    HOW TO CREATE A SUMMARY OF A SUMMARY FIELD.

    The best way to handle this is through variables. You sum the Summary field to which ever group level you want. Each summary field you want to summarize would require three variables. You have to do it at the final pass - while printing records.
  20. rnd

    Report Definition File (RDF)

    That was my guess too since the RDF is one of the output formats. But "Building a report using a report definition file (.RDF)" is one of the topics in the ACE self assessment. I wanted to confirm that RDF is not a Datasource. Unless CD has misprinted RDF instead of TTF it is still a mystery...

Part and Inventory Search

Back
Top