Search results for query: *

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

...@NewICDB_NAME VARCHAR(200) SET @curName = "Master" <-- I just hardcoded this for this example. This usually varies. SET @NewICDB_NAME = 'SELECT * FROM ' + @curName + '.dbo.IC0001' --> Error here I tried ->IF Not EXISTS (EXEC(@NewICDB_NAME)) I tried ->IF Not EXISTS (@NewICDB_NAME) BEGIN...

...@NewICDB_NAME VARCHAR(200) SET @curName = "Master" <-- I just hardcoded this for this example. This usually varies. SET @NewICDB_NAME = 'SELECT * FROM ' + @curName + '.dbo.IC0001' --> Error here I tried ->IF Not EXISTS (EXEC(@NewICDB_NAME)) I tried ->IF Not EXISTS (@NewICDB_NAME) BEGIN...

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

Is there a way that you can change the header on the drill down on the left hand side? For Ex: --USA --Canada --Germany --UK change to... --USA --Canada --Germany --England

Why does everyone think that I am having some sort of DLL problem. It could not be a DLL problem. I created a FORMULA called &quot;ERRMSG&quot; 'Error message' I put code in the surpress area to surpress the label unless the criteria does not match. On everyones computer it is surpressed...

How do you work this? John-

I do not understand? ======================================================= In the Edit Field object... 'Tax Sheltered Amount Error' In the format editor. This is in the Suppress area... IF ISNULL(Sum ({@SubjectToMCAR}, {W2Summary;1.EMPLOYID})) = TRUE THEN...

One other problem is that she would not let me touch her computer so I can do other further diagnostics on this problem. John-