Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PavanKumarU

    Emergency,Need for help with this insert then update, problem

    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?
  2. PavanKumarU

    Emergency,Need for help with this insert then update, problem

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

    Emergency,Need for help with this insert then update, problem

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

    Comparing Data

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

    Index Help

    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=''...
  6. PavanKumarU

    NT Authentication

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

    NT Authentication

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

    NT Authentication

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

    NT Authentication

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

    Crystal Query Issues

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

    Crystal Query Issues

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

    Crystal Query Issues

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

    Programmin the "back" button in IE

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

    Programmin the "back" button in IE

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

    Programmin the "back" button in IE

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

    Filter (RecordSelection) Object - RAS

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

    Pass a NULL to datatime param in RDC Code

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

    RDC Parameter Issue....Please HELP... Cant debug more!!!

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

    RAS Parameter Issues

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

    RAS Help....passing parameters

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

Part and Inventory Search

Back
Top