Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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.

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

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.

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