Page 1 of 1
Data does not show in Web
Posted: Wed Jun 20, 2007 1:07 pm
by Chan Kuan Leang
Hi,
I have a small problem.
In my preview, I can see my data.
But from my web, I cannot see anything when I run it from my visual studio except my header?
Does anyone have the same problem?
Thanks. Please teach me how to solve this problem.
Data does not show in Web
Posted: Wed Jun 20, 2007 3:44 pm
by Vital
Please show code you are use for showing report.
Data does not show in Web
Posted: Wed Jun 20, 2007 5:40 pm
by Chan Kuan Leang
Vital wrote:Please show code you are use for showing report.
Thanks.
The codes is as follow
Code: Select all
Imports Stimulsoft.Report
Imports Stimulsoft.Report.Web
Imports System.Data.SqlClient
Imports System.Web.Configuration
Partial Class APTrialBalanceSummary
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim Report As Stimulsoft.Report.StiReport = rwAPTrialBalance.GetReport()
StiWebViewer1.Report = Report
'StiWebViewer1.PrintToPdf()
End Sub
End Class
Thanks for you help.
Data does not show in Web
Posted: Wed Jun 20, 2007 7:51 pm
by Vital
Your code is correct. Please show your aspx page.
Data does not show in Web
Posted: Wed Jun 20, 2007 8:40 pm
by Chan Kuan Leang
Vital wrote:Your code is correct. Please show your aspx page.
Code: Select all
Logout
" SelectCommand="SELECT APTBAcctID, GroupName, AccountName, Debit, Credit, GroupID FROM qryAPTrailBalance">
Here is the code for my aspx page.
Thanks
Data does not show in Web
Posted: Thu Jun 21, 2007 6:15 pm
by Vital
Please check following code:
Code: Select all
Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter("SELECT APTBAcctID, GroupName, AccountName, Debit, Credit, GroupID FROM qryAPTrailBalance", ConnectionStr)
Dim DataSet As DataSet = New DataSet
DataAdapter.Fill(DataSet)
DataAdapter.Dispose()
DataSet.Tables.Item(0).TableName = "sdsAPTrailBalance"
Dim Report As Stimulsoft.Report.StiReport = rwAPTrialBalance.GetReport()
Report.RegData("sdsAPTrailBalance", DataSet.Tables.Item(0))
StiWebViewer1.Report = Report
Data does not show in Web
Posted: Thu Jun 21, 2007 11:55 pm
by Chan Kuan Leang
Vital wrote:Please check following code:
Code: Select all
Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter("SELECT APTBAcctID, GroupName, AccountName, Debit, Credit, GroupID FROM qryAPTrailBalance", ConnectionStr)
Dim DataSet As DataSet = New DataSet
DataAdapter.Fill(DataSet)
DataAdapter.Dispose()
DataSet.Tables.Item(0).TableName = "sdsAPTrailBalance"
Dim Report As Stimulsoft.Report.StiReport = rwAPTrialBalance.GetReport()
Report.RegData("sdsAPTrailBalance", DataSet.Tables.Item(0))
StiWebViewer1.Report = Report
I have put it in Page_Load, but, it still do not show data.
Please advice.
Thanks
Data does not show in Web
Posted: Thu Jun 21, 2007 11:57 pm
by Chan Kuan Leang
Vital wrote:Please check following code:
Code: Select all
Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter("SELECT APTBAcctID, GroupName, AccountName, Debit, Credit, GroupID FROM qryAPTrailBalance", ConnectionStr)
Dim DataSet As DataSet = New DataSet
DataAdapter.Fill(DataSet)
DataAdapter.Dispose()
DataSet.Tables.Item(0).TableName = "sdsAPTrailBalance"
Dim Report As Stimulsoft.Report.StiReport = rwAPTrialBalance.GetReport()
Report.RegData("sdsAPTrailBalance", DataSet.Tables.Item(0))
StiWebViewer1.Report = Report
I have put it in Page_Load, but, it still do not show data.
Please advice.
Thanks
Data does not show in Web
Posted: Fri Jun 22, 2007 9:43 am
by Edward
Please place after GroupHeader a DataBand, then specify for it a DataSource and place the Text components with links to the fileds which must be shown inside each group.
Please note that for correct displaying the group you need a GroupHeader and a DataBand as well.
Thank you.