Search results for query: *

I am installing a database on a server with case-sensitive collation. Our database was installed on that server with case-insensitive collation. To install the objects, I have a script that runs oSQL commands. Some of the scripts require case insensitivity. (For example, a UDF uses the...

OK, I have a RPT up in the designer that's using a SQL Server stored proc as a data source. The SP has 4 parameters. I choose Verify Database, enter the parameters, and this message comes up: "The database file availability_list_215;1 has changed. Proceeding to fix up the report!&quot...

I'm using the Crystal OCX to generate a report that's getting its data from a SQL Server stored proc with parameters. I'm connecting to the db via ODBC. I'm using the StoredProcParam property array to pass the SP parameters and that's working fine. I'd like to display these parameters on the...

I have a report that uses a Cross Tab with a date column. I have customized the Group Name by using a formula to display mm/dd. It looks fine in the preview, but when I export to Excel I get gibberish, stuff like this: Xh% fh% mh% {h% ‚h% h% I don't see this bug reported on Crystal. Anyone...

I have Crystal Reports 8.5.0.217 installed on my computer now. I'm starting a new project where they use CR8.0. Since CR8.5 has no "Save as Crystal Reports 8.0" option, am I correct in assuming that reports saved in 8.5 are fully compatible with CR8.0?

Does the Use Indexes Or Server for Speed option do anything when your data source is a MS SQL server stored procedure?

I came across a little glitch and found a solution. I thought I'd pass it along. I have a report that uses active data with embedded subreports that also use active data. The active data definition (TTX) files are kept in the same directory as the RPT files. Everything was fine when we...

I'm having a problem similar to the person with the Excel string/memo problem. I have a SQL Server query that contains a field that's assigned a return value of a UDF. The value of the UDF can be a string up to 254 characters long. I have two identical copies of this query and UDF in two...

I'm using the RDC in VB to open an existing .RPT, modify it, and then save it. I would like to add conditional formatting to a field, specifically I'd like to add a formula to a field's suppress. Can you do this? When opening a .RPT that already has conditional formatting, I can't seem to find...