Print Page | Close Window

Incomplete data shown in crystal report

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4485
Printed Date: 01 May 2024 at 5:25pm


Topic: Incomplete data shown in crystal report
Posted By: yasinirshad
Subject: Incomplete data shown in crystal report
Date Posted: 08 Oct 2008 at 4:23am

Hi,
I have an application on which i have 5 crystal reports (asp.net 2003) to be shown on seperate web pages.
3 reports work fine ,  but other 2 reports shows incomplete information...

For example :
If there are 5 rows in report, only 3 rows are shown. Other 2 rows are not shown , else shown with wrong values.
i.e.,
row   Total
1      10
2      10
3      10
4      10
5      10

On my web application it shows as,
row   Total
1 10
2 10
3 10

I dont know why this is happening (with only 2 reports)...
Can anyone pls help me on this..
my code:


Dim crReportDocument As New ReportDocument
            Dim ConnInfo As New ConnectionInfo
            With ConnInfo
                .ServerName = StrReportServer
                .DatabaseName = strReportDBName
                .UserID = strUsrName
                .Password = strUsrPwd
            End With

            crReportDocument.Load(strDocPathFolder + "\" + "ABCCC.rpt")
            Me.CrystalReportViewer1.ParameterFieldInfo.Clear()
            Dim ParamFields As ParameterFields = Me.CrystalReportViewer1.ParameterFieldInfo

            'Set Month Paramter
            Dim GetMonthValues As Int16
            GetMonthValues = Session("Month")
            Dim Per As New ParameterField
            Per.ParameterFieldName = "SELECTMONTH"
            Dim Month_Value As New ParameterDiscreteValue
            Month_Value.Value = GetMonthValues
            Per.CurrentValues.Add(Month_Value)
            ParamFields.Add(Per)

            Me.CrystalReportViewer1.ParameterFieldInfo = ParamFields
            Me.CrystalReportViewer1.ReportSource = crReportDocument

            crReportDocument.SetDatabaseLogon(strUsrName, strUsrPwd, StrReportServer, strReportDBName)

            Me.CrystalReportViewer1.RefreshReport()
            CrystalReportViewer1.Visible = True


Thanks to help.



-------------
Thanks,
Yasin.



Print Page | Close Window