Problem applying record selection formula 
Author Message
 Problem applying record selection formula

I am using CR .NET with ASP.NET. I'm using the CR ReportDocument
object to load the report, set the selection formula, and export the
report to PDF. The problem is that no matter what the selection
formula, the exported report displays all the records.. My code is
listed below...

--------
--------

    Dim crReport As New ReportDocument(), thisdate As Date, enddate As
Date
    Dim fname As String, rsf As String
    Dim crDest As New DiskFileDestinationOptions()
    Dim crExp

        thisdate = calSelect.SelectedDate
        enddate = DateAdd("d", 6, thisdate)

        rsf = "{qry_ShowReserved.DateStart} IN #" & thisdate & "# TO
#" & enddate & "#"

        crReport.RecordSelectionFormula = rsf

        fname = "d:\inetpub\rpttemp\" & Session.SessionID.ToString &
".pdf"

        crDest.DiskFileName = fname
        crExp = crReport.ExportOptions

        crExp.DestinationOptions = crDest
        crExp.ExportDestinationType = ExportDestinationType.DiskFile
        crExp.ExportFormatType = ExportFormatType.PortableDocFormat

        crReport.Export()
        Response.ClearContent()
        Response.ClearHeaders()
        Response.ContentType = "application/pdf"
        Response.WriteFile(fname)
        Response.Flush()
        Response.Close()



Fri, 24 Jun 2005 21:41:34 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. CR.Net Record Selection Formula not being applied

2. Problem w/ Record Selection formula

3. Problem applying a User Defined Style to a Selection

4. Selection Formula for Multiple records won't work

5. CR .Net Record Selection Formula not working

6. Record Selection using multiple formula

7. passing date to record selection formula

8. using VB variables in record selection formula?

9. Record Selection Formula. Crystal guru needed

10. Using a record selection formula in a subreport

11. Selection formulas: group or record ?

12. Record Selection Formula from VB

 

 
Powered by phpBB® Forum Software