Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ProcessHttpRequest vs. GetHtmlContent

Status
Not open for further replies.

SmokeEater

Technical User
Feb 14, 2002
90
CA
I am using one of the sample RAS solutions from the Crystal web site. The last line in the CrystalInteractiveViewer.asp uses a ProcessHttpRequest method. The crystal documentation says to "see also" GetHtmlContent. I have tried to use the GetHTMLContent but have got nothing but a blank screen. The reason for the attempt to use this method is that the Crystal documentation says that the HTML line from this can be used multiple times and I am currently having trouble getting the drill down to work properly.

This is a carry forward of the thread:"Drill down does not work in CR9 with RAS"
 
I wrote the formula to a cookie and then used a page that looks like this to be the final driver of the report.

Hope it helps.


<%



Dim ObjectFactory, HTMLViewer
Set ObjectFactory = CreateObject(&quot;CrystalReports.ObjectFactory.2&quot;)
Set HTMLViewer =ObjectFactory.CreateObject(&quot;CrystalReports.CrystalReportViewer&quot;)



Dim clientDoc
Set clientDoc = ObjectFactory.CreateObject(&quot;CrystalReports.ReportClientDocument&quot;)
clientDoc.ReportAppServer = &quot;SERVERNAME&quot;

clientDoc.Open &quot;REPORT.rpt&quot;


'==================================================================
' WORKING WITH FREE EDITING RECORD FILTERS
' - Retrieve the filter object through the DataDefController
' - Set the text of the Record Filter through the FreeEditingText property
' - Modify the record filter through the Record Filter Controller
'==================================================================

Dim filter
Dim formula

formula=request.cookies(&quot;studentinfo&quot;)(&quot;formula&quot;)

' Retrieve the filter object through the DataDefController
Set filter = clientDoc.DataDefController.DataDefinition.RecordFilter
' Set the text of the Record Filter through the FreeEditingText property
filter.FreeEditingText = formula
' Modify the record filter through the Record Filter Controller
clientDoc.DataDefController.RecordFilterController.modify filter


With HTMLViewer
.IsOwnPage = true
.IsOwnForm = true
.IsDisplayGroupTree =true
.IsBestFitPage = true
.ReportSource = clientdoc.reportsource
End With
call HTMLViewer.ProcessHttpRequest(Request, Response,session)
%>

 
Hi,
i'm having a similar issue here. I define a record selection formula in the report at design time. In the run time if i try to change it, it's not recognising it.
lets say i have a Record selection formula as {sample.result} <> &quot;na&quot;.

During run time i change it to
selform={sample.sample_id}=&quot;100&quot;
filter.FreeEditingText = selFor

when i set the filter using this
OpenReport.DataDefController.RecordFilterController.modify filter

it does not get the sample whcich is equal to 100. it still tries to use the selection formula set during the design time, as it DOES NOT get result = &quot;na&quot;.

Does any one has any ideas regarding this?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top