Search results for query: *

next thing to look at is if both custid and customerId are int columns or one is a varchar? can you send me the create sql for these two tables?

put a BEGIN TRANSACTION before your insert statement and an END TRANSACTION after the insert statement.

First what column is this data 'AARO007' coming from? Second, have you tried including the insert statement in Begin and End transactions, so its commited? If you do that then the data is committed to the databsae and then you can try update it. lemme know.

Hi, I have a tricky(?) problem here...... I have a product, that writes out reports to tables. SO, the table is create dynamically. Columns are decided by me, the datatypes are decided by the product. I have no control on the data types. If the database has a double, the report writer create the...

Hello, Have been struggling with the following query for a couple of days and hope someone could shed some light on this: The query: Select id, tran_no from table_x where client=@client and price=(case when @variable1=0 then @variable2 else @variable1 end) and date=(case when @datevariable1=''...

No. We kind of put it on hold for now as our company is planning to migrate to Crystal Enterprise. I am sorry for not being able to help. I will let you know if we do anything with NT authentication. Thanks Pavan

Hello, Thanks for the reply. I will try that and see. But just as a headsup....we did this: We changed the 'service' log on parameters on the IIS box for RAS. We changed from "Log on as Local account" to "Log on as" and provided a sql logon, in which RAS could run. But then...

Hello all, I have a 'process' related question. First a little background on our evironment: We are using Crystal Report Application Server 9 with SQL Server 2000 and asp coding. We have developed an application in asp where users can select a report, provide values to the stored procedure...

Hello all, I have a 'process' related question. First a little bacground on our evironment: We are using Crystal Report Application Server 9 with SQL Server 2000 and asp coding. We have developed an application in asp where users can select a report, provide values to the stored procedure...

Hello K, Thanks again for a promt reply. I am sorry for not mentioning the version. We are using Crystal Reports 9, standard. About the issues, I have read the article you mentioned. Crystal report suggests the usage of a stored proc, active data etc in this article but really doenst provide...

hello k, Thanks for replying. I have checked out the document specified in the article you mentioned and also another doc (for older reports) thats called "cr_rdc_dbconnectivity.pdf", but neither of the reports mentioned anything about logging into the query or even using query. Do...

Hi, We are using asp, RDC to view, export reports via web. I have the following issues *only* when the reports are using crystal query instead of a stored procedure or table links. Issue: The report login fails when I use the following code. The same code works fine when the report uses stored...

actually, i am seeing the first one. but in general, this is what i want to do. If user clicks the "back" button, then goto a particular page, clean up session variables, and move to the index page. Alternatively, i could, check if the location the browser is trying to move to is the...

Hi, Thanks for a fast reply. Really appreciate it. But could you tell me in what event shld i call all these javascript snippets? I am confused because, i dont know what "button event" i shld write this code in. Please help. Thanks Pavan

Hi, we had a requirement recently, and i have been researching for a solution, in vain. Hope osmeone could throw some light. We ahve created a browser based application that renders crystal reports to users. The last page in a sequence of parameter prompting, criteria validating is the...

Hi, Did anyone work with the filter objects in RAS? I am having an issue working with this object. I am able to retrive the filter defined in the report, but not able to append a new filter to the existing one. Could someone throw some light please? Thank, Pavan

hi ok. I found the answer, and may be it will help someone . When you want to pass a null from VB or ASP, pass vb keyword "Empty" and not a null to any parameter on the report. -Pavan

Hi, After two days of beating my head against the wall, i am coming for help, very desperately. Any help is much appreciated. I am trying to ste some values to the stored procedure parameters in a report. I dont know whats happening, but the report is not taking these parameters nor it it...

Hello everyone suffering with RASomania (like me!!), RAS has become something like...'Cant Bare you, Cant live without you!!' for all Crystal Users. The document is so adequate and any help is Oasis. Hope someone helps me with this issue. I am feeling lost!! We have created some ASP pages, that...

hi, Hope someone helps me with a workaround to this intriguing issue. We have a set of reports that we made available to our intranet clients via the RDC. There are a set of asp files that read the parameters of each report (that are stored in a table (Hardcoding??!!)) and user selects/enters...