M
mcs04
I'm writing this post because I need some help. Any insight will be
greatly appreciated. Thank you in advance!
I have a Crystal Report 9 that gets its info from a SQL database. I
installed the RAS in a Win2K server. The report lists from the
database all the invoices. What I'm trying to do and I'm unable it's
to filter the results and only show the one that I want.
I have de following code:
------------------ begining of code ------------
<% Dim ObjectFactory, HTMLViewer
Set ObjectFactory = CreateObject("CrystalReports.ObjectFactory.2")
Set HTMLViewer = ObjectFactory.CreateObject("CrystalReports.CrystalReportViewer")
With HTMLViewer
..IsOwnPage = true
..IsOwnForm = true
..HasGotoPageButton = false
..HasSearchButton = false
..IsDisplayGroupTree = false
..ReportSource = "invoice.rpt"
End With
call HTMLViewer.ProcessHttpRequest(Request,Response)
HTMLViewer.DatabaseLogOnInfos(0).UserName = "user"
HTMLViewer.DatabaseLogOnInfos(0).Password = "password"
%>
------------------ end of code ------------------------
My problem is that I do not know what object or property to use to
filter the informatión. I've use the following object with the
following filter withing the HTMLViewer properties but I get and error
message:
..RecordSelectionFormula = "{SALES.INVOICE} = '230571'"
DOES ANYBODY KNOW HOW TO ADD A FILTER TO MY REPORT USING THE
HTMLVIEWER that comes with the RAS?
Thank you very much!
greatly appreciated. Thank you in advance!
I have a Crystal Report 9 that gets its info from a SQL database. I
installed the RAS in a Win2K server. The report lists from the
database all the invoices. What I'm trying to do and I'm unable it's
to filter the results and only show the one that I want.
I have de following code:
------------------ begining of code ------------
<% Dim ObjectFactory, HTMLViewer
Set ObjectFactory = CreateObject("CrystalReports.ObjectFactory.2")
Set HTMLViewer = ObjectFactory.CreateObject("CrystalReports.CrystalReportViewer")
With HTMLViewer
..IsOwnPage = true
..IsOwnForm = true
..HasGotoPageButton = false
..HasSearchButton = false
..IsDisplayGroupTree = false
..ReportSource = "invoice.rpt"
End With
call HTMLViewer.ProcessHttpRequest(Request,Response)
HTMLViewer.DatabaseLogOnInfos(0).UserName = "user"
HTMLViewer.DatabaseLogOnInfos(0).Password = "password"
%>
------------------ end of code ------------------------
My problem is that I do not know what object or property to use to
filter the informatión. I've use the following object with the
following filter withing the HTMLViewer properties but I get and error
message:
..RecordSelectionFormula = "{SALES.INVOICE} = '230571'"
DOES ANYBODY KNOW HOW TO ADD A FILTER TO MY REPORT USING THE
HTMLVIEWER that comes with the RAS?
Thank you very much!