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

Thanks for your response, but my question remains. I want the results of 182/100 to appear as simply 1.82 If I select exactly that - "182/100" - then it assumes integer division and returns 1. Any other ideas? Phil

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 have fixed all my problems... so far. Thanks for your responses!! Phil

The primary limitation is that the total number of columns produced by crosstab'ing the data varies according to the criteria specified at run time. It can be anywhere from just a few up to 60 or more. But I want to print 6 columns (not including method and compound) on each page. Since I build...

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