'==================================================================
' WORKING WITH THE REPORT PARAMETER COLLECTION
'==================================================================
'Each report object which contains parameters has a collection called ParameterFields.
'That collection contains...
create a running total and in the evaluate section use a formula that only adds positive numbers..
example using crystal syntax:
{testtable.fieldtoadd} > 0
Since you didn't post your database connection and assuming you're using ODBC to SQL server just after your if/end if code checking for errors add something like this:
'Create a reference to the tables collection of the main report
Set mainReportTableCollection = Session("oRpt").Database.Tables...
I actually ran your web page successfully. i created a report that uses odbc to sql server but i need to add login parameters to your code. I believe your problem is needing the runtime files on your server. To make things easier just install crystal reports on the web server to get the RDC. You...
I wrote several reports in version 8.5 using OLE DB to SQL Server 2000 that ran very fast. If I convert the same report to ODBC in version 8.5 it runs like a dog. I just converted the report to version 10 using OLE DB and in runs about the same as version 8.5 using ODBC. Probably 10 times...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.