Page 1 of 1

StiReport Web Design

Posted: Thu Sep 13, 2012 2:55 pm
by beso
Hi,
I have StiReports 2010 ult.

it is my code in VS.Net 2010 (VB)
Wich is correctly work in Win App
--------------
Dim connectionString As String

connectionString = "connect"

Dim CNN As SqlConnection = New SqlConnection(connectionString)
Dim MyDS As String, MyRep As String
MyDS = TextBox1.Text
MyRep = TextBox2.Text

Dim cmd As SqlCommand = New SqlCommand(MyDS, CNN)

cmd.CommandType = CommandType.StoredProcedure

cmd.Parameters.Add(New SqlParameter("@fin", 12))


Dim DS As New DataSet
Dim DA As New SqlDataAdapter(cmd)

DS.Clear()
CNN.Open()
DA.Fill(DS)
CNN.Close()

Dim Report As StiReport = New StiReport()
If MyRep <> "" Then
Try
Report.Load(MyRep)

Catch ex As Exception
Report.LoadEncryptedReport(MyRep, "key")
Finally

End Try
End If

Report.RegData("DRC", DS)
Report.Design()
----------

When I do same in Web APP, It do not works correctly .. Why?
------
Dim connectionString As String

connectionString = "connect"

Dim CNN As SqlConnection = New SqlConnection(connectionString)
Dim MyDS As String, MyRep As String
MyDS = TextBox1.Text
MyRep = TextBox2.Text

Dim cmd As SqlCommand = New SqlCommand(MyDS, CNN)

cmd.CommandType = CommandType.StoredProcedure

cmd.Parameters.Add(New SqlParameter("@fin", 12))


Dim DS As New DataSet
Dim DA As New SqlDataAdapter(cmd)

DS.Clear()
CNN.Open()
DA.Fill(DS)
CNN.Close()

Dim Report As StiReport = New StiReport()
If MyRep <> "" Then
Try
Report.Load(MyRep)

Catch ex As Exception
Report.LoadEncryptedReport(MyRep, "kay")
Finally

End Try
End If

Report.RegData("DRC", DS)
StiWebDesigner1.Design(Report)
----

if more details: In designer "DRC" is marked with ( black -X) , the table is shown and columns also , but report dont get data and
in table edit window the columns ar not retrieve
Can anyone help me

Re: StiReport Web Design

Posted: Fri Sep 14, 2012 12:29 pm
by Alex K.
Hello,

Please send us a sample project with test data which reproduces the issue for analysis.
Also please check the following topic:
http://stimulsoft.helpserve.com/index.p ... icleid=181

Thank you.