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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

get html from crystal using vb6

Status
Not open for further replies.

michaelcoleman

Programmer
Jun 26, 2003
21
US
Hello,

I'm trying to convert my report from .rpt format to html so i can post it on the web:

I'm using ASP...
<%@ Language=VBScript %>
<%
dim oInstance
dim sClass, sProject
dim sClassString

sClass = Request.Item(&quot;cls&quot;)
sProject = Request.Item(&quot;prj&quot;)
sClassString = sProject & &quot;.&quot; & sClass
set oInstance = server.CreateObject(sClassString)
oInstance.ProcessRequest
set oInstance = nothing
%>
so after this, no more asp code is needed and evertything is done in vb. So I'm looking for a string that contains the html to send.

I have a designer class called Yield.dsr

Set yldReport = New Yield
Set db = New TPDatabase
Set rs = db.getYieldInfo(startdate, enddate, True)

Set crParameters = yldReport.ParameterFields

Set crParameter = crParameters.Item(1)
crParameter.SetCurrentValue CStr(startdate), 12
Set crParameter = crParameters.Item(2)
crParameter.SetCurrentValue CStr(enddate), 12
Set crParameter = crParameters.Item(3)
crParameter.SetCurrentValue CStr(&quot;First Pass Yield Report&quot;), 12
Call yldReport.Database.SetDataSource(rs)

*********************************
From here i can view the report on a crViewer located on a form. I need to blow this into html....

Can anyone help?

-confused
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top