Recent content by vbjohn

thanks it works

Can someone tell me why is this not working? WhilePrintingRecords; numberVar numNB; numberVar numRPC; numberVar numMC; numberVar numMRPC; numberVar numDPP; numberVar numNB2; numberVar numRPC2; numberVar numMC2; numberVar numMRPC2; numberVar numDPP2; if {tran_date} in Aged31To60Days then...

I have this parameter and in its options I have the "Allow multiple values" check and then "Discrete values(s)" checked as well. When I go into the "Select Expert" and put the parameter into the expert I get this message.... "This array must be subscripted. For example: Array [i]". Any Ideas...

bborissov... Your suggestion worked. Thanks alot everyone for your help.

YEs... Char(44) is a , and Char(39) is what I need.

Either way I tried them both... Char(39) or Char(44). Both gave me the same error.

It is an ASCII character. Char(44) = '

This one does not work.... SET @NewPODB_NAME = 'IF EXISTS (SELECT * FROM PO0007 WHERE CODPROD = char(44) AC700MC0 char(44)) BEGIN SET @Check = 1 END' It tells me: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'AC700MC0' When I take out the Where clause it works...

Can anyone help me figure this out? Why can I not use this variable. I get this error for the second one I try: Server: Msg 170, Level 15, State 1, Line 31 Line 31: Incorrect syntax near '@NewICDB_NAME'. DECLARE @curName VARCHAR(200) DECLARE @NewICDB_NAME VARCHAR(200) SET @curName =...

Can anyone help me figure this out? Why can I not use this variable. I get this error for the second one I try: Server: Msg 170, Level 15, State 1, Line 31 Line 31: Incorrect syntax near '@NewICDB_NAME'. DECLARE @curName VARCHAR(200) DECLARE @NewICDB_NAME VARCHAR(200) SET @curName = "Master"...

Great! Why didn't I think of that.

I am putting a formula in Crystal that will give me the Month and Year only in this format... 06/05. How could I do this? ToText(Month ({Emp.DateStarted})) +"/"+ ToText(Year({Emp.DateStarted})) and I get this... 6.00/2,005.00 What should the formula be?

Awesome! Thanks.

When I run the Syntax check it gives me a message saying "a Text is required here" and it highlights the whole Year function... MonthName(Month ({SlsInquiry.DateSales}), True) + ". " + Year({SlsInquiry.DateSales})

Ooops... Crystal Reports 10 VB.6