Problem with putting a parameter in the reportviewer

Question

0.00/5 (No votes)

See more:

Hello,

I have problem to put variables to reportviewer.
First I put variables to parametrs and then to reportviewer.
Code looks like that:

C#

jodb baza_win = new jodb(.....data.....to.....connection......SQL);
List<DaneRaportu> lista = baza_win.pobierz_rap_view(......query......SQL)
reportViewer1.ProcessingMode = ProcessingMode.Local;
LocalReport localReport = reportViewer1.LocalReport;

reportViewer1.LocalReport.DataSources.Clear(); //clear report
reportViewer1.LocalReport.ReportEmbeddedResource = "Raporting.Report_Promo.rdlc"; // bind reportviewer with .rdlc

Microsoft.Reporting.WinForms.ReportDataSource dataset = new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", lista); // set the datasource
reportViewer1.LocalReport.DataSources.Add(dataset);
dataset.Value = lista;

            string data_rap = "Dataprobna";   //variables that I won't put in reportviewer
            ReportParameter nowydataod = new ReportParameter("dataodview", data_rap);  //dataodview this is name of parameter in design report
            this.reportViewer1.LocalReport.SetParameters(nowydataod);

Next in report I put parameter to textbox. Expression looks like that: Parameters!dataodview.Value

When I start program I get this communication:
An error occurred during local report processing
In details:
Microsoft.Reporting.WinForms.LocalProcessingException: An error occurred during local report processing. ---> Microsoft.Reporting.DefinitionInvalidException: The definition of the report '' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.UnauthorizedAccessException: Access to the path 'C:\Users\User\AppData\Local\Temp\expression_host_1f2d7bdeb7b24b8a9d99ff74d15a1b60.dll' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

The strange thing is that when I start program in Start Debugging everything is ok but when I start program in Start Without Debugging I have bug.

Maybe someone knows what happened?

Posted 8-Oct-14 9:34am

Kris_C#

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**AmitGajjar** · Answer 1 · 2014-10-08T11:04:00

Solution 1

Hi,

It looks like your compiler trying to access some Temp folder file and it is being used by other process. You can try to remove all temp files, clean project, change some code file so project will be rebuild. Although i am not sure about the solution. but nothing wrong in trying out with the options.

Thanks

Posted 8-Oct-14 11:04am

AmitGajjar

Comments

Kris_C# 9-Oct-14 4:38am

Unfortunately, the file appears when I create a report so remove temp does nothing helps!

AmitGajjar 9-Oct-14 10:52am

sounds like some problem with your report. Are you able to add variable in other report ?