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

    Conditional HTML Pages

    I want to run an ASP file in the <SCRIPT> block if the browser has scripting enabled. If scripting is disabled, I want to show an HTML page indicating that. I've tried a number of different things and it just won't work. Basically, what I need is to conditionally show page 1 or page 2...
  2. Crider

    BCP

    I have a text file consisting of 7 fields that are all defined as character. The field, FIELD7, defined in the text file layout as char(6) is defined as INT in the SQL Server 2000 table. I have two rows in the text file. My first problem is when I run the Bulk Copy command, the value of...
  3. Crider

    Failed to open a rowset

    That's what I have been doing and that works. I was just wondering if there was a way within Crystal to override the error. I will continue with the dummy row solution which has been working for me.
  4. Crider

    Failed to open a rowset

    I am working on forms which have a lot of sub reports. Because of the amount of data, there will be times when some of my stored procedures don't return a rowset simply because no data exists for that person on that part of the form. Is there a way within Crystal to easily tell Crystal to...
  5. Crider

    Getting a Report on a Crystal Report

    Thanks for the reply. That pretty much gives me most of what I want.
  6. Crider

    Getting a Report on a Crystal Report

    I've been working on forms in Crystal where I'm using a lot of sub-reports and formulas. As a result, I was wondering if there was anything within Crystal, or some other utility where I can generate a report of everything used in a crystal report. Things such, all formulas and their code, all...
  7. Crider

    Database Connection

    I think I found my problem. Apparently if sufficient time elapses, Crystal drops the connection to the database. If however, the connection is still present, then clicking Database/Log On Log Off Server and logging off the server will do the trick.
  8. Crider

    Database Connection

    I have tried that and that doesn't solve my problem.
  9. Crider

    Database Connection

    I have been working on forms that have lots of sections. I am developing a given form in sections building the stored procedures as I go along. I am also using sub reports in these sections because of the nature of the forms. I just find it easier and feel I have more control. My problem is...
  10. Crider

    Null Values

    I have formula structured as follows assuming the following values: FieldA = 'Hello' FieldB = 'there ' FieldC = 'dude' IF NOT ISNULL(FieldA) THEN FieldA + CHR(13) + CHR(10) + IF NOT ISNULL(FieldB) THEN FieldB + CHR(13) + CHR(10) + IF NOT ISNULL(FieldC) THEN FieldC + CHR(13) +...
  11. Crider

    Renaming a Stored Procedure

    I solved my problem and am passing it along for anyone who faces the same situation in the future. 1. Rename the stored proc (I'm using SQL Server/2000) 2. Retrieve the report in Crystal (I am using CR 9) 3. From the Database menu, Set Datasource Location 4. Hilight the stored proc currently...
  12. Crider

    Renaming a Stored Procedure

    I am using Crystal 9 and did all that. But the problem is when I look at the Show SQL Query from the database menu item, it shows the original stored procedure name being called. I want to change the name there but Crystal won't let me. Any suggestions?
  13. Crider

    Renaming a Stored Procedure

    I want to rename the stored procedure that is currently driving a given crystal report. When I change the report to use the renamed SP, it blows all my report fields away coming from the SP. The SP is identical to what the report uses now. It's just that the DBA would like me to rename the...

Part and Inventory Search

Back
Top