Question Re: CR SP26 VS2019 Parameter Panel Missing Parameters in Technology Q&A

CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Fri, 13 Dec 2019 16:42:42 GMT

I have run the the update to SP26 for some reason my parameters are no longer showing up in the parameter panel on the web crystalreportviewer after the report has initially loaded. The parameter(s) is prompted initially to run the report.

As a work around I have set HasToggleParameterPanelButton= false, HasRefreshButton=true, and ReuseParameterValuesOnRefresh=false.

<CR:CrystalReportViewer ID="Report" Runat="server" AutoDataBind="true" Height="1250px" HasCrystalLogo="False" HasRefreshButton="True" HasToggleParameterPanelButton="false" BestFitPage="True" ReuseParameterValuesOnRefresh="false" ToolPanelView="None" DisplayStatusbar="True" HasToggleGroupTreeButton="false" EnableDatabaseLogonPrompt="False" PrintMode="ActiveX" />

This does show the parameter(s) as expected. My report parameters are set to editable and when you loop through the parameterfield using the code below the Usage2 values is already set to all the available values (side note, this snip came from another post, but if you try it you will get a Not Supported exception)

foreach (CrystalDecisions.Shared.ParameterField parameterField in reportDocument.ParameterFields)
{
  parameterField.ParameterFieldUsage2 = ParameterFieldUsage2.ShowOnPanel;
}

As you can see from pic here the parameter for this report is missing from the Parameter Panel. Not sure how to fix this issue. Any suggestions would be appreciated. Thinking it might be a bug. I included my code below for reference. Prior to SP25 I was clearing the parameterfieldinfo property using Report.ParameterFieldInfo.Clear() in the report init method. This might have something to do with the missing parameters, but I have no way of testing, because if I add that back I cannot get the report to load as when you click the OK on the parameter dialog the report's ajax postback just returns the parameter dialog back instead of the rendered report.

 Private crReportDoc As ReportDocument
 Private rpt As String

    Private Sub Report_Init(sender As Object, e As System.EventArgs) Handles Report.Init
        Dim exportFormatFlags As Integer = CInt(CrystalDecisions.[Shared].ViewerExportFormats.PdfFormat Or CrystalDecisions.[Shared].ViewerExportFormats.ExcelFormat)
        Report.AllowedExportFormats = exportFormatFlags
        'Report.ParameterFieldInfo.Clear() 'started causing prompt to not go away if set 'removed 12/13/19 CR SP25 & SP26
        LoadCRV()
    End Sub
    Sub LoadCRV()
        Try
            rpt = Request.QueryString("rpt")
            If rpt Is Nothing Then Response.Redirect("~/reports/crm.aspx")
            Dim rptPath As String = Nothing
            If rpt IsNot Nothing Then rptPath = Server.MapPath("~/reports/cr/" + rpt)
            If rptPath IsNot Nothing Then
                Try
                    crReportDoc = New ReportDocument
                    crReportDoc.Load(rptPath)
                    For Each rd As ReportDocument In crReportDoc.Subreports
                        crDBLogin(rd)
                    Next
                    crDBLogin(crReportDoc)
                    Report.ReportSource = crReportDoc

                    Report.RefreshReport()
                Catch ex As CrystalReportsException
                Catch ex As Exception
                End Try
            End If
        Catch ex As Exception
        End Try
    End Sub
    Private Sub cr_Unload(sender As Object, e As System.EventArgs) Handles Me.Unload
        If rpt IsNot Nothing Then
            If crReportDoc IsNot Nothing Then
                If crReportDoc.Subreports IsNot Nothing Then
                    For Each srDoc As ReportDocument In crReportDoc.Subreports
                        If srDoc IsNot Nothing Then
                            srDoc.Close()
                            'srDoc.Clone() 'idea from web post
                            srDoc.Dispose()
                            GC.Collect()
                            'GC.WaitForPendingFinalizers() 'idea from web post
                        End If
                    Next
                End If
                crReportDoc.Close()
                'crReportDoc.Clone() 'idea from web post
                crReportDoc.Dispose()
                GC.Collect()
                'GC.WaitForPendingFinalizers() 'idea from web post
            End If
            If Report IsNot Nothing Then
                Report.Dispose()
            End If
        End If
    End Sub

Notes about my upgrade:

I ran the exe as the admin as instructed. I let it install the 64bit msi. The 32bit msi was already installed, but did not get updated. I updated it manually. The VS toolbox still has the .3500 controls referenced so I removed them and added the new items (not sure if that was suppose to happen automatically). I did remove all my references in the image below and added them back which updated the project file to the .4000 dll's.

Project Specs
x86, 4.7.2 framework

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

former_member11696 — Mon, 16 Dec 2019 14:21:29 GMT

Don't install the 32 bit MSI on your DEV PC, not required. Just install the EXE.

Make sure the Viewer was updated as well to 13.0.4000.0

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Mon, 16 Dec 2019 21:01:57 GMT

Don, thanks for the response. I went ahead and uninstalled the 32 bit MSI. All references are using 13.0.4000.0. Removed all project references and added them back as instructed in the wiki. Here is my complete viewer code. I went ahead and switched HasToggleParam and ReuseParam values back to true and false, but the values still do not appear on the parameter panel.

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="cr.aspx.vb" Inherits="MJHCRM.cr" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.4000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<!doctype html>
<html lang="en">
<head>
    <title>CR Viewer</title>
</head>
<body>
    <form id="crForm" runat="server">
       <CR:CrystalReportViewer ID="Report" Runat="server" AutoDataBind="true" Height="1250px" HasCrystalLogo="False" HasRefreshButton="True" HasToggleParameterPanelButton="true" BestFitPage="True" ReuseParameterValuesOnRefresh="true" ToolPanelView="None" DisplayStatusbar="True" HasToggleGroupTreeButton="false" EnableDatabaseLogonPrompt="False" PrintMode="ActiveX"  />
    </form>
</body>
</html>

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

former_member11696 — Tue, 17 Dec 2019 22:58:59 GMT

Are you using Sessions and Postback to keep the report in scope?

See this KBA:

https://launchpad.support.sap.com/#/notes/1985571

Don

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Wed, 18 Dec 2019 14:48:35 GMT

Strange since I have never had an issue prior to SP25. Is this a new thing? Also, I tried setting my ReportDocument to the sesssion, but get this exception.

Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode.

Caused By: System.NotSupportedException Not supported within subreports

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

former_member11696 — Thu, 19 Dec 2019 20:29:51 GMT

Theres's been updates to resources. Try ProcessMonitor and see what it's looking for.

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Mon, 30 Dec 2019 18:42:38 GMT

Do you have a good link on how to use that tool?

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

former_member11696 — Mon, 06 Jan 2020 19:16:02 GMT

just add your EXE to the filter...

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Tue, 07 Jan 2020 02:05:31 GMT

This is a web app, what process do I need to monitor, IIS Express or something else?

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Wed, 08 Jan 2020 18:24:55 GMT

So I have made some progress. I have updated my viewer to the following:

<CR:CrystalReportViewer 
           ID="crReportViewer" Runat="server" AutoDataBind="True" Height="1250px" HasCrystalLogo="False" BestFitPage="True" DisplayStatusbar="True" ToolPanelView="None" PrintMode="ActiveX"
           EnableDatabaseLogonPrompt="False" 
           ReuseParameterValuesOnRefresh="True" 
           HasRefreshButton="True" 
           HasToggleParameterPanelButton="True"
           HasToggleGroupTreeButton="True" 
           />

Now the parameters are showing in the parameter panel and the report is loading correctly after the original parameter prompt closes. However, now whenever there is a postback on reports that includes optional prompts in the report, the parameter prompt is shown again with just those optional parameters. He is an example of the flow.

1. Load report in web viewer that include 4 parameters, 2 of which are optional
2. Built-in viewer parameter dialog shows and only the required parameters are picked and click OK
3. Report loads in viewer correctly.
4. Any postback is fired from viewer (this example let's say you click Next Page button)
5. Built-in viewer parameter prompt appears with only the 2 optional parameters
6. You just click OK and the prompt closes, but you are still on page 1.
7. You click Next Page again, but this time when the 2 optional parameters appear you select values for both and click OK. 8. Report not loads with values set for all 4 parameters.
9. You not click Next Page again, but this time you are shown page 2 as expected.

So it appears to me something is up with the optional parameters after the initial loading of the report. Here is my code that handles my report loading. I cannot figure out what I am doing wrong. Like I said before this all worked prior to SP25. Something has changed and I am not sure what I need to do now for the optional parameters not to appear after the report is loaded unless I pick the parameter from parameter panel.

  Private crReportDoc As ReportDocument
    Private rpt As String

    Sub LoadCRV()
        Try
            rpt = Request.QueryString("rpt")
            If rpt Is Nothing Then Response.Redirect("~/reports/crm.aspx", False)
            Dim rptPath As String = Nothing
            If rpt IsNot Nothing Then rptPath = Server.MapPath("~/reports/cr/" + rpt)
            If rptPath IsNot Nothing Then
                Try
                    crReportDoc = New ReportDocument
                    crReportDoc.Load(rptPath)

                    For Each rd As ReportDocument In crReportDoc.Subreports
                        crDBLogin(rd)
                    Next
                    crDBLogin(crReportDoc)

                    crReportViewer.ReportSource = crReportDoc

                    'crReportViewer.RefreshReport()
                Catch ex As CrystalReportsException

                Catch ex As Exception

                End Try
            End If
        Catch ex As Exception

        End Try
    End Sub

    Private Sub crReportViewer_Init(sender As Object, e As EventArgs) Handles crReportViewer.Init
        Dim exportFormatFlags As Integer = CInt(CrystalDecisions.[Shared].ViewerExportFormats.PdfFormat Or CrystalDecisions.[Shared].ViewerExportFormats.ExcelFormat)
        crReportViewer.AllowedExportFormats = exportFormatFlags
        'crReportViewer.EnableParameterPrompt = False
        'Report.ParameterFieldInfo.Clear() 'started causing prompt to not go away if set 'removed 12/13/19 CR SP25 & SP26
        LoadCRV()
    End Sub

    Sub crDBLogin(ByVal rptDoc As CrystalDecisions.CrystalReports.Engine.ReportDocument)
        Try
            Dim crCI As New CrystalDecisions.Shared.ConnectionInfo
            With crCI
                .ServerName = System.Configuration.ConfigurationManager.AppSettings("sqlserver")
                .DatabaseName = System.Configuration.ConfigurationManager.AppSettings("database")
                .UserID = System.Configuration.ConfigurationManager.AppSettings("user")
                .Password = System.Configuration.ConfigurationManager.AppSettings("pwd")
                .Type = CrystalDecisions.Shared.ConnectionInfoType.SQL
                .IntegratedSecurity = False
            End With
            For Each crTable As CrystalDecisions.CrystalReports.Engine.Table In rptDoc.Database.Tables
                Dim li As CrystalDecisions.Shared.TableLogOnInfo = crTable.LogOnInfo
                li.ConnectionInfo = crCI
                crTable.ApplyLogOnInfo(li)
                'crTable.Location = crCI.DatabaseName & ".dbo." & crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
            Next
            'rptDoc.SetDatabaseLogon(ConfigurationManager.AppSettings("user"), ConfigurationManager.AppSettings("pwd"), ConfigurationManager.AppSettings("sqlserver"), ConfigurationManager.AppSettings("database"))
            rptDoc.VerifyDatabase()
        Catch ex As CrystalDecisions.Shared.CrystalReportsException


        End Try
    End Sub

    Private Sub cr_Unload(sender As Object, e As System.EventArgs) Handles Me.Unload
        If rpt IsNot Nothing Then
            If crReportDoc IsNot Nothing Then
                If crReportDoc.Subreports IsNot Nothing Then
                    For Each srDoc As ReportDocument In crReportDoc.Subreports
                        If srDoc IsNot Nothing Then
                            srDoc.Close()
                            'srDoc.Clone() 'idea from web post
                            srDoc.Dispose()
                            GC.Collect()
                            'GC.WaitForPendingFinalizers() 'idea from web post
                        End If
                    Next
                End If
                crReportDoc.Close()
                'crReportDoc.Clone() 'idea from web post
                crReportDoc.Dispose()
                GC.Collect()
                'GC.WaitForPendingFinalizers() 'idea from web post
            End If

            If crReportViewer IsNot Nothing Then
                crReportViewer.Dispose()
            End If
        End If
    End Sub

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Wed, 08 Jan 2020 18:33:08 GMT

And just to be clear. I can load this very same report is optional parameters in CR 2013 SP12 and after the initial parameter selection I go directly to page two without getting prompted for the optional parameter. So this would make me believe nothing is wrong with the actual report itself.

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

former_member11696 — Wed, 08 Jan 2020 21:41:56 GMT

Yes, monitor the web server

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Thu, 09 Jan 2020 15:58:11 GMT

Ok don.williams I have run the processmonitor, but I have no clue what I am looking for. I ran it just on iisexpress and only when I clicked the next page button in the crystal report viewer and when it prompted for the optional parameters I clicked stop on the process montior. Captured 42000 events. Should I filter those events with just SAP in the path? I am going to start reviewing now just to see if I can find anything that makes sense.

Also, I added two additional notes to the main question. I am starting to believe this might a bug related to handling optional prompts (parameters). Thanks for the help so far!

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Thu, 09 Jan 2020 17:23:54 GMT

don.williams so now I am really thinking this might be a bug with SP26. Will you please see if you can reproduce the optional prompt issue?

I have attached a sample project. (sample project here) This project was created using the crystal reports website template. I have one test.rpt file. Run the project and select the Name property only. Once report loads, then click next page. You should get a prompt for Color which is the optional parameter. If you just hit ok, then window closes but still on page 1. If you select a color it updates the report, but still on page 1. Only then can you click next page and page 2 will load.

My project is a web app and this a newer website project, so I am convinced it has to be a bug. Hopefully you will get the same results.

Don't forget to add the asp_net virtual directory to the vs/applicationhost.config file so the viewer loads. I also updated the physicalPath, but you might have to update that too if VS doesn't do it for you.

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

former_member11696 — Thu, 09 Jan 2020 19:27:30 GMT

Hi Kevin,

Thanks for the test app andf the viewer warning.

So I copied the CR viewer folder into the AppData folder:

C:\inetpub\wwwroot\CrystalReportsWebSite12\CrystalReportsWebSite1\App_Data\crystalreportviewers13

It works for me:

Use Fiddler and see where it's trying to load the various CR resources from.

The JS file it's not finding is in here:

C:\inetpub\wwwroot\CrystalReportsWebSite12\CrystalReportsWebSite1\App_Data\crystalreportviewers13\prompting\js

Thanks again

Don

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Thu, 09 Jan 2020 21:06:52 GMT

don.williams I have made a quick video to make sure we are both on the same page. Still feel like we are looking at a bug here.

Video link

Thanks, Kevin

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Mon, 13 Jan 2020 19:20:24 GMT

don.williams did you have a chance to watch my video in above post? I am assuming you did and were able to replicate the issue at hand. If so, any timeline on a possible fix or work-around?

Thanks,
Kevin

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Fri, 17 Jan 2020 02:46:12 GMT

don.williams hate to keep bugging you, no pun intended, haha. I assume at this point something is in in the works about the bug I have identified in my video and sample solution. Could you please provide some kind of update so I can respond to my team accordingly?

Thanks,
Kevin

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

former_member11696 — Fri, 17 Jan 2020 18:22:48 GMT

Video link no longer works.

Your test app works for me so it's environmental on your system likely causing the problem.

Parameter prompts are handled by js files in the Viewer folder:

C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13\js

Note there is a new Parameter reference in the project you need to use. So remove the old Flash component from your references, then it should work again for you.

Re: CR SP26 VS2019 Parameter Panel Missing Parameters

kevin_hicks — Fri, 17 Jan 2020 20:40:29 GMT

Try video again please. Changed privacy setting.

https://vimeo.com/383845145

Not using flash. What is parameter reference you are talking about?

Video shows the issue I’m experiencing. Hopefully you can view it and repeat the issue on your end.

Thanks,

Kevin