Microsoft Report viewer 2012

Hello, We have built a VB.net app and this app is using the Microsoft Report viewer 2012 runtime to view report on a local report server.  One of the user that accesses the report many time a day is finding that at time the data in the report is not showing on the report. This "missing data" is random and sometime is the bottom of a report, the top of the report, or all of the report. once the user closes and reopens the app, the data returns. Any advice would be appreciated.

Thanks.
bnrtechAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Randy DownsOWNERCommented:
Maybe this will help

Missing Data in CSV/XML Exports

Is some of your data not getting exported to the data export formats of CSV or XML? Reporting Services, by default, has all data controls set to auto-output on export. This means that the rendering extension whether CSV or XML determines what gets exported. When exporting to the data specific rendering extensions, the extension determines what to export, which in most cases means that tabular data gets exported but not data determined to be informational. There is a way around this feature.

When you click on a control that contains data that you want to export, you should set the property DataElementOutput to "Output", as shown in Figure 30.



Alternatively, you can also set this option by right-clicking the control and selecting properties. Once the properties dialog is displayed go to the "Data Output" tab and select the "Yes" option under the "Output" section, as show in Figure 31.


By setting this property to "output", it ensures that your information will get exported. These Data Output options are used only by the CSV and XML rendering extensions. All other built-in formats are exported based on layout and don't use the Data Output settings.
bnrtechAuthor Commented:
Sorry, tried out your suggestion, however the data is still not showing. It is not missing however when the report is exported, just not showing in the viewer. It is also random, sometime the header does not show, sometimes the footer does not show, sometime nothing shows.  Thanks.
Randy DownsOWNERCommented:
Maybe this will help troubleshoot.

web page hosting the ReportViewer control was automatically mapping certain parameters to specific values, but in the case of the two failed reports, the reports shared a mapped parameter

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bnrtechAuthor Commented:
I added the Clear command to fire when form closed and that corrected the issue.  Thanks.    

Private Sub frmrptClientInvoice_FormClosing(sender As Object, e As FormClosingEventArgs) Handles Me.FormClosing
        rptvwInvoiceReport.Clear()
    End Sub
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.