Search results for query: *

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

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

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.

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

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

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

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.

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

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

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

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

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?

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