Search results for query: *

I have a table with three columns; column a is an identity column, column b is just an id number, and column c is a date. I have several blanks in the date column and want to replace them with nulls. I tried the following query which fails on a "subquery returned more than 1 row" error and I...

I have a column that I need to get into mm/dd/yyyy format I can get it that way as a varchar but converting to a date gives me a problem. I thought it was my data but look at this example, select Convert(varchar,getdate(), 101) as date1, CONVERT(datetime, CONVERT(varchar(8), GETDATE(), 101))...

This ought to be simple but I'm missing something. I have a multiple, distinct parameter called "Type" that I am passing a comma separated list, for example; interactive,selfpaced,home I'd like to use something like this in a record selection formula: {maintable.type} in {?Type} If I...

I have a typical table that looks something like CustNo State PartNo 1 NJ 60 1 NY 50 2 TN 30 2 KY 45 The CustNo column is not unique but is the key. I need to create a single row on a spreadsheet or flat file that looks like this CustNo...

Hi, I'm running Crystal Enterprise at the momemnt but hate it. How does Reporting Services compare in terms of report design and deployment?

I have a table that has the date separated into 3 columns, month, day and year. All three columns are varchar in the database. I need to recombine those parts into a full date and convert the result into a datetime. I have tried casting and coverting combinations to no avail. One of the...

I'm running CR 8.5, Win2K, active x viewer. I am trying to pass multi values to a parameter I've created. If I configure the parameter for a single value, it works fine. If I change the same parameter to multi value, the user prompt box opens every time and expects manual entry. I am simply...

Hi, I currently have Crystal Ent 8.5 that I use to distribute reports from our ASP application. The users only have the com object viewer to display the report in their browser. I use the 5 concurrent licenses that came with CR Ent. and have no trouble. I'm thinking about upgrading to CR 10...

Hi, I have to convert a number column that has leading zero(s) to a varchar2. If I run the TO_Char(column, '099999') or other similar formats I get an extra leading blank. For example, if the value in the number column is 012345 when I run the to_char I get ' 012345'. I have tried TRIM and...

Hi, I have an .rtf file I'm trying to retrieve via cfhttp. If I type the url in the browser it gets the file without a problem. If I try the same url via cfhttp I get an HTML error 406 - "No acceptable objects were found Content-type text/html. Connection failure" The obvious...

Hi, We're running Enterprise V 8.5 in a web environment. It's okay but can be really clunky some times. Is Version 9 any better and is there enough added features to warrant an upgrade (like $1600 worth)? I'd appreciate some opinions if anyone has done this. Thanks, Jim

Hi, I've never used temporary tables before and I'm having a problem. I can create a local or global temporary table with no problem. When I try to do an insert or update to the table I just created, I get an error that the object doesn't exist. I can run a select * on the temporary table...

I have an old server running win2K. I just bought a new server that is bigger/better and I want to migrate the old server to the new one without having to re-install everything. Can Norton Ghost or some other tool allow you to do this complex migration? The new machine will replace the old...

I have COM object that I'm calling with CFObject. The only examples I have of using it are in VB. I can get the object created but it is crashing on a function that looks like this in the VB example obj.StartPF outputfile:="C:\test" When I convert this to it's CF equivilet, it...

I have been unsucessful in trying to restore a database. First I was getting errors about 'users' logged on. I found out how to put the database in single user mode but that is as far as I can get. If I try to connect with the enterprise manager, I can't with essentially the same reason. I...

I've got to be doing something stupid. I have a simple text file with about ten comma separted columns. I'm trying to copy that data into a table with about 50 columns but the ten in question have the same name in both the text file as well as the table. I used the DTS wizard to do the...

I'm trying to build and audit table and record only those column values that have changed during a form update. To do this, I check the column with a trigger using the IF UPDATE clause. For example: If update (PRACNAME) select @PRACNAME = PRACNAME from deleted From there I write the value of...

I'm trying to use the if statement below to change the output if the value is null. When I run the report, it crashes and says the formula is invalid. In fooling around with it, it appears that the if statement is working so I though it might be a problem creating variables inside the if...

I built a query using SQL Designer, ran it and then saved it with no problems. I then went to Crystal reports to build a new report and clicked on Crystal SQL Query in the data section of the Report Expert. I can see my query in the list, I can highlight it and the add button looks active but...

I have a crosstab report and I created a formula to group and name the columns, example 0-30, 31-60, ect. Works great but when I export the report to Excel, it drops those column headings and substitues the variable name from the formula. So, it looks like Result1, Result2, ect. How do I keep...