Search results for query: *

Hmm. These are both good ideas. After I try them out (probably next week), I'll post the results here. Thanks Clay!

Here's one to show the tables & colums: SELECT dbo.sysobjects.name AS TableName, dbo.syscolumns.name AS ColName, dbo.syscolumns.colid AS ColOrder, dbo.systypes.name, dbo.syscolumns.length, dbo.syscolumns.prec, dbo.syscolumns.isnullable FROM dbo.sysobjects INNER JOIN...

Here's one to show the tables & colums: SELECT dbo.sysobjects.name AS TableName, dbo.syscolumns.name AS ColName, dbo.syscolumns.colid AS ColOrder, dbo.systypes.name, dbo.syscolumns.length, dbo.syscolumns.prec, dbo.syscolumns.isnullable FROM dbo.sysobjects INNER JOIN...

Will the cnt field always be integers increasing like that with no numbers skipping? Will Type always be 5 or 6? If not, what other values might they have?

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

Here's a piece of code in VB that retrieves a subreport: With oRpt 'get the subreport reference For Each oSec In .Sections For Each oRptObj In oSec.ReportObjects If oRptObj.Kind = crSubreportObject Then Set oSubRptObj = oRptObj...

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

Well, this one seems to have stumped everyone, but I figured it out on my own. This bug will only occur if the stored procedure name does not match the alias name. For my report, the SP name was P_Util. If I go to Database\Set Alias on the designer menu and click Set Alias, I see a dialog...

Oh yeah, more info. If I run this in the report designer, filling in the parameter values in the dialog that pops up, the values do show up. Strange. So if I fill in 1/1/2000 for the @start_dt parameter, then when I run the report in report designer, I get a 1/1/2000 displayed for the...

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

Great! Thanks for the input.

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?

Make a formula that is equal to 0 if Previous(datefld) = datefld and is equal to the daily average otherwise. You want the sum of this new formula field.

Hmm, I'd try to take care of this in the database. In SQL Server I'd use a table-valued function to link to instead of creating an actual table like you mentioned. A list of Fridays until the end of the year is small, so it should never take long to generate.

I think using File\Print\Export then choosing Report Definition will help.

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

Can you add views to your database?

Assuming that the managers are in your Employee table too, you should go to the Visual Linking Expert and then in the Tables\Add Tables dialog, add the Employee table again. It will give you a warning, and yes you do want to add another alias to the table. It will be aliased as Employee_1...