Search results for query: *

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

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

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?

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})

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

Here is a strange problem. On this one report i have a various error checking formulas in the Crystal Reports 8.5. 1.) On my computer I run the report and no errors. 2.) I also ran the report on a co-workers computer, no errors. 3.) I ran the report on my bosses computer and I get an error...

In my formula I have a text message with an error message. I have this on my report. So I went into the features of the formula and I went into the SUPRESS button. I am curious about this one issue.... This is my code for in order to supress: ({@DefComp} < {@75DEFCOMP}) = TRUE OR...

When I run a report and it comes up on the screen, everything looks fine. But when I print it off on the printer, my font gets bigger. Has this ever happend to anyone? Before it worked fine and now it does not. I have the font to ARIAL size 9. Here are some other questions that other people...

When I run a report and it comes up on the screen, everything looks fine. But when I print it off on the printer, my font gets bigger. Has this ever happend to anyone? Before it worked fine and now it does not. I have the font to ARIAL size 9. Here are some other questions that other people...

I was wondering if there is a way that we could call 2 different databases in a SQL Stored Procedure? We have 2 main databases with the same tables. So I am creating a Stored Procedure and would like to call them both and gain access to their tables. SELECT * FROM CMSN.dbo.PM30600 UNION ALL...

I have a stored procedure in Sql and I have the Stored Procedure in a conditional format. What my problem is that when I run this and I put a @Benefit = 'MATCH' I get data. But when I select @Benefit = NULL (which I am supposed to get everything, nothing comes up. What am I doing wrong? Here is...

I was wondering if there is a way that I could add in an IF STATEMENT in a Stored Procedure? If so how would I do it? This is what I have and I know that it is wrong... any suggestions would be great. CREATE PROCEDURE dbo.BenefitEditRep @SEmpNum char(6) = Null, @EEmpNum char(6) = Null...

Is there a way that we can set menus to personal settings for the end user? Also, on menus is there a possibility that we can keep the menu open without closing after we select an item on the menu until we choose a cancel option on the menu to close the menu? John-

Is there a way that you can add 2 recordsets together into one? I have to get records from 2 different databases and put them together into 1 report. John-

Since last Thursday, I had no problem running any linked table in Access and Crystal Reports from my computer. Now I am getting this ERROR: Connection Failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user '(null)'. Reason: Not...

I was wondering on why I loose some data when I do a union query? When I run the first query I get 15 Records and then when I run the second query I got 1 Record (which is good). The when I run them in a Union Query I get a total of 10 Records instead of 16. ===UNION QUERY...

I have a question. I was wondering if there is a way that I could do something like a CASE Statement in the Data Environment. I know you can do a CASE Statement in SQL but CASE is not supported in VB Data Environment. This really bugs me. Cause I got something that I need but I could not...