Data does not show in Web

[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.

[Vital]

Please show code you are use for showing report.

[Chan Kuan Leang]

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.

[Vital]

Your code is correct. Please show your aspx page.

[Chan Kuan Leang]

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

[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

[Chan Kuan Leang]

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

[Chan Kuan Leang]

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

[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.