Search results for query: *

Another post led me to APOS last week. In the "Freeware" section they offer a CR8.5 Runtime file installer. I haven't used it myself, so I can't vouch for it.

I recommend always setting a Primary Key in table variables, as in: Declare @tblStaff Table ( staffID int NOT NULL, periodBudget money default 0, stdBudRate money default 0, nextPeriodBudget money default 0, daysWorked int PRIMARY KEY CLUSTERED (staffID)) If the...

I vote for your first example: custID custFName custLName I like the clarity of having a single column name for a particular piece of data in every table where it occurs.

If you only have responsibility for developing reports of the same general format as you've done before, the CR Designer application itself doesn't change drastically from CR to CE or even across versions after CR 8.5 (and not all the changes there are undisputed improvements). The big changes...

The export choices are hardcoded in the web-delivered versions of CRViewer that I'm familiar with (CR 8, 8.5, 9?). In the Designer, you see what's currently available.

1) Make sure there's no Record selection or Group Selection formula. 2) Put check by "Database server is case-insensitive" db advanced option or use ALL CAPS. Set most other DB performance type options OFF. 3) Don't use double quotes (or straight brackets) unless you absolutely have to for...

A company I just started on contract with has a problem with a CR8 report that worked against a SQL Server 7 stored procedure, but fails with a 'Server not open' error against the same SP on SQL Server 2000. Any ideas? It would sure help me seal the deal on my employment here for the...