Recent content by rnd

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.