Search results for query: *

There's a table in a database that is used to gather data for export to a flat file. This table is always emptied and repopulated each time the process is run. There will never be a need to restore these transactions from the transaction log, and the process causes the transaction log file to...

I have seen some strange results of arithmetic functions. The simplest example is: select 182.0/100 returns 1.820000 Another result I've seen is where 1.5 comes out as 1.4999999 What I really want to do is return all numbers with 3 significant digits. Any suggestions? Phil

I have several numeric fields on a report that I want to display with 3 significant digits. A number such as 12.34567 should appear as 12.3, whereas 0.98765 should appear as 0.988. Furthermore, integers should be displayed as is - i.e. 12 should display as 12. I have found no way to define a...

I want to print database fields (that appear in each row of data) in the page header and sort them horizontally. That is, I'm trying to circumvent the limitations of CR's crosstab report. I've got a (SQL Server) stored procedure that populates a temp table, whose structure looks like this...

I have a simple report that queries a SQL Server database. The report runs correctly from the Crystal Report Designer (of course!) and it also works from the Crystal Management Console, a browser-based application. But when I try to view it from an ASP page I get a generic error: Error...