CrystalReportViewer filtering problem

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,902
Latest member
Elena68X5

Latest Threads

Top