I've created a product tracking system using ASP.NET that generates reports using the .NET CrystalReportViewer to display reports. When a multi-page report is generated, I click the "next page button", and I'm taken to the second page.

The problem is that's as far as it will go. No matter how many pages are in the report, the viewer won't go past page two. If I click the "last page" button, it takes me to the last page, but if I click the "previous page" button, the viewer takes me back to page two.

I can enter a page number in the "Go to" box, and that will take me to the correct page, but the paging buttons won't go past page two.

I have a custom routine written to export the report to a PDF format which allows proper paging, but that annoys the end-users.

Has anyone encountered this issue before? Any input would be appreciated.

Hi AVeldkamp!

I have also used CRViewer to create reports in .NET but I'm NOT getting any kind of paging error. I can surf thru the pages of my report without any problem....just check the properties of CRViewer to see if u r missing out something...I never encountered such an error

Cheers
Debsoft

cheers,
debsoft

Hi AVeldkamp,

I am having the same problem.
Don't know if you have solved your problem or not, but here is my situation, any help would be appreciated.
The reports are created by Crystal Reports 8.5.
Going against a sql server 2000 database.

Then loaded using the following code:

        Dim reportDocument As New ReportDocument()
        Dim parameterfields As New ParameterFields()
        reportDocument.Load(report.FilePath + report.FileName)

        Dim crLogonInfo As CrystalDecisions.Shared.TableLogOnInfo
        crLogonInfo = reportDocument.Database.Tables(0).LogOnInfo
        With crLogonInfo
            .ConnectionInfo.ServerName = ConfigurationSettings.AppSettings("CrystalReportSe rverName")
            .ConnectionInfo.UserID = ConfigurationSettings.AppSettings("CrystalReportUs erID")
            .ConnectionInfo.Password = ConfigurationSettings.AppSettings("CrystalReportPa ssword")
            .ConnectionInfo.DatabaseName = ConfigurationSettings.AppSettings("CrystalReportDa tabaseName")
        End With
        reportDocument.Database.Tables(0).ApplyLogOnInfo(c rLogonInfo)

        crystalReportParameterPanel.GetValues(reportDocume nt, parameterfields)

        crystalReportViewer.ParameterFieldInfo = parameterfields
        crystalReportViewer.ReportSource = reportDocument
        crystalReportViewer.DataBind()
        crystalReportViewer.Visible = True

Thanks
jsullivan

I'm really confused by all this. I've written numerous reports in Crystal 8.5 and have never seen anything like all the code below. I use Crystal to connect to the database (it doesn't matter what one, just use the correct ODBC driver). The finished report is uploaded to a Crystal Enterprise 8.5 server where the users log in and run whatever report is needed. What are you doing that you need all the manual connection and login information?



Check out http://www.ASPGuru.US

I forgot to mention that this is using the Crystal Report Viewer in a ASP.Net application.
The reports are just sitting in a directory under the website and not added into the project.
The idea being we could just put new reports out in the web folder and not have to recompile the application.
Also use the sql server driver thus the connection information.
We do have Crystal Enterprise 8.5, but are not using it.

the problem is caused by the parameterField.

for some reasons, when you set the parameter, it will reset the currenct page no. to 1, so it will load page 2 again and again everytime you click on "Next" button.

To solve this problem, set the parameter when the page is not posted back.

            If Not (IsPostBack)
                discreteVal.Value = myvalue
            paramField.ParameterFieldName = "MyParam"
            paramField.CurrentValues.Add(discreteVal)
            paramFields.Add(paramField)
            CrystalReportViewer1.ParameterFieldInfo = paramFields
        End If

Hope this is helpful

Thank you kevin77! You da man!

I was having the same problem. I was also able to solve it by moving the code where I set parameters into a "if not ispostback" chunk, but now I have a new problem.

When I try to print, I get the error "missing parameter values".

My guess is that printing is for some reason NOT a postback but goes through as a "first time post".

So, does anyone have any ideas how to fix this circuitous problem? If I put the parameters so they set on every postback the printing works, but I can't get to page three. If I set the parameters to only set if it's a postback then the paging works properly but the printing breaks.

Thanks in advance -- Mike

Are you using Crystal Report or Crystal Report Application Server (RAS)?

I had this error when I was using RAS, I has a sub-report in main report. I think I was getting this error when printing/exporting the report.

Akhtar

AVeldkamp,

I have solved it :) I was getting the same problem.

Move all crystal reporting code from page_load to page_init. It should go through the records then.

Bubmachine