Error with Filter/Include & Replace
-
Karl_Vadelund_(Guest)
- Posts: 1
- Joined: Tue Oct 10, 2017 12:44 pm
Error with Filter/Include & Replace
We^re working with the Rattler product and have come across an error trying to use the Filter/Include or the Replace properties.____Whenever any value is placed in the Include property you get the error:__"Invalid report file type" when you try to run it. If I comment out the rr.Include = 2 line everything runs OK.____Here^s the URL we are calling:__<a href="http://dtpwapps/rrReport.asp?rptname=c:inetpubwwwrootTest.rsw&priority=E" target="_blank">____Here^s the code from the .ASP file__---------------------------------------------------------------------------__<%__if Request("generatereport") = "true" then___Response.Buffer = TRUE ^ For IIS 4 compatibility__ set rr = Server.CreateObject("RRATL.RSWControl")__ rr.dataSource = application("pwdatasource")__ rr.username = application("pwusername")__ rr.Password = application("pwpassword")__ if Request("priority") <> "ALL" then__ _rr.Include = 2__ _rr.Filter = "PRIORITY=" & "^" & Request("priority") & "^"__ end if___ rr.reportName = Request("rptname")__ rr.runReport__else__%>__<HTML>___<HEAD>____<TITLE>Test</TITLE>___</HEAD>____<BODY>_____<object WIDTH="50%" HEIGHT="50%" ______CLASSID="CLSID:66960E23-DE25-11CF-876F-444553540000" ______ codebase="rrprview.cab#Version=2,0,0,4" id=RepView1>______<param NAME="LanguageID" VALUE="0409">______<param NAME="ReportURL" VALUE="<%= Request.ServerVariables("SCRIPT_NAME") %>?generatereport=true&priority=<%=Request("priority")%>&rptname=<%=Request("rptname")%>">______<embed WIDTH="95%" HEIGHT="95%" ______CLASSID="CLSID:66960E23-DE25-11CF-876F-444553540000" ______CODEBASE="rrprview.cab#Version=2,0,0,4" ______TYPE="application/oleobject" ______PARAM_ReportURL="">_____</object>____</BODY>__</HTML>__<%__end if__%>__---------------------------------------------------------------------------____Can you tell me what the problem is.____Thanks,__Karl__
=> Error with Filter/Include & Replace
he problem is that unlike the runtime executable, RattleRR does not support the Include property.__The only available properties via RattleRR that allow you to control record selection are the FilterUsage and Filter.__So to override the saved filter you would use:____rr.FilterUsage = 2__rr.Filter = "PRIORITY=" & "^" & Request("priority") & "^"____The report will then select only those records that meet the filter condition.______Kathleen__R&R Support