Category: reporting-services

Sep 09 2009

Can you reference the textboxes on an ssrs report from embedded code

Hello,

Is it possible to reference a textbox from the embedded code of a ssrs report. I would like to show or hide the textbox based on a condition.

Thanks.

Seth

Sep 09 2009

Can you reference the textboxes on an ssrs report from embedded code

Is it possible to reference a textbox from the embedded code of a ssrs report. I would like to show or hide the textbox based on a condition.

Sep 09 2009

How do you reference a field in the Embedded Code of an SSRS report.

Hello,

Is there a proper way to reference the fields of a ssrs report from the embedded code of an ssrs report?

When I try to use Fields!Program.Value I get the following error --

There is an error on line 3 of custom code: [BC30469] 
Reference to a non-shared member requires an object reference.

Upon googling I found you could reference the Parameters of a report by prepending Report. at the beginning. So I tried this Report.Fields.Program.Value. That results in the following error...

There is an error on line 3 of custom code: [BC30456] 'Fields' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IReportObjectModelProxyForCustomCode'.

So...in summary, is there a way to reference the fields from the embedded code. I figured out I could pass the field vals to the function itself but I would prefer to reference the fields directly.

Seth

Sep 09 2009

How do you reference a field in the Embedded Code of an SSRS report

Is there a proper way to reference the fields of a ssrs report from the embedded code of an ssrs report? When I try to use Fields!Program.Value I get the following error --
There is an error on line 3 of custom code: [BC30469]
Reference to a non-shared member requires an object reference.
Upon googling I found you could reference the Parameters of a report by prepending Report. at the beginning. So I tried this Report.Fields.Program.Value. That results in the following error...
There is an error on line 3 of custom code: [BC30456] 'Fields' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IReportObjectModelProxyForCustomCode'.
So... in summary, is there a way to reference the fields from the embedded code. I figured out I could pass the field vals to the function itself but I would prefer to reference the fields directly. Seth
Aug 25 2009

Is there a way to supply query parameters to a SQL Server Reporting Services Report at deployment time rather than at design time

Hello,

SUMMARY: I have created a SSRS Report. I want to be able to supply parameters for the report at DEPLOYMENT time rather than just design time or runtime.

DETAILS: I want to create ONE report and deploy it multiple times with the only difference being that I want to change one of the query parameters. I do not want to prompt the user for the value.

Can this be done?

Seth

Jul 22 2009

SSRS Report Page Orientation

I am new to creating SQL SSRS (SSRS) reports in visual studio. I am impressed so far but I cannot find out how to set the Page Orientation in my new report from Portrait to Landscape.

I would think this would be in the Report/Report Properties settings but it is not there?

How do I change the Page Orientation from Portrait to Landscape for my new SSRS report?

Jul 22 2009

SSRS Report Page Orientation

I am new to creating SQL SSRS (SSRS) reports in visual studio. I am impressed so far but I cannot find out how to set the Page Orientation in my new report from Portrait to Landscape.

I would think this would be in the Report/Report Properties settings but it is not there?

How do I change the Page Orientation from Portrait to Landscape for my new SSRS report?