How to format measure descriptions

When using a matrix in Reporting Services to design a
report based on a cube, you are presented with a detail
column for your measure and a column to the left of that
for the description of the measure. My report has several
rows of measures that present (for example) both units
and dollars. I want to be able to leave a blank line
between the units section and the dollars section. I also
want to be able to place a heading for each section. The
preference is that the heading be off to the left rather
than above -- but i am not able to add a second
description column. So I placed text in the description
column to simulate the desired formatting.
For example:
Units Prod1
Prod2
Prod3
Total
Sales Prod1
Prod2
Prod3
Total
This approach looks fine in the designer. But when i
publish the report and view it in IE, all extra spaces
are gone (both horizontally and vertically) so the
descriptions look as below:
Units Prod1
Prod2
Prod3
Total
Sales Prod1
Prod2
Prod3
Total
Any suggestions on how to get a better presentation of
the descriptions?Try Using Padding ?
"Daniel Edwards" <DanielEdwards@.discussions.microsoft.com> wrote in message
news:A5663DB5-D5DD-4132-AEA5-A9D19EDFE713@.microsoft.com...
> When using a matrix in Reporting Services to design a
> report based on a cube, you are presented with a detail
> column for your measure and a column to the left of that
> for the description of the measure. My report has several
> rows of measures that present (for example) both units
> and dollars. I want to be able to leave a blank line
> between the units section and the dollars section. I also
> want to be able to place a heading for each section. The
> preference is that the heading be off to the left rather
> than above -- but i am not able to add a second
> description column. So I placed text in the description
> column to simulate the desired formatting.
> For example:
> Units Prod1
> Prod2
> Prod3
> Total
> Sales Prod1
> Prod2
> Prod3
> Total
> This approach looks fine in the designer. But when i
> publish the report and view it in IE, all extra spaces
> are gone (both horizontally and vertically) so the
> descriptions look as below:
> Units Prod1
> Prod2
> Prod3
> Total
> Sales Prod1
> Prod2
> Prod3
> Total
> Any suggestions on how to get a better presentation of
> the descriptions?
>

How to fire off a report and save it as pdf...

Using vb.net, does anyone know or has anyone fired off a sql report, save it as PDF to a defined path?

I am knew to sql reporting services and the help files are not very helpfile.

Any sample code would be helpful.

Thanks

Hello,

Have a look at the sample code on this page:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx

Specify the export format you want (in your case "PDF") as a parameter to the Render method.

-Chris

|||

I looked at the sample code, how ever, not sure where the references are to things like

"ReportExecutionService" and some of the other objects.

WHich .net items do I need to import?

Daryl

|||In your project you need add a web reference to the reportexecution service. this will create a proxy class that you an instantiate in code to call the web service|||does it matter that I am NOT building a web application? Building a Desktop vb.net exe.|||no it doesn't matter|||

I cannot find this reference. I looked in windows and system...

|||Right-click your project and select "Add Web Reference"|||

Hi Adam,

The post and the replies are really useful. Thanks a lot for the help...

Adam, the URL "http://localhost/reportserver/reportexecution2005.asmx" needs to be a working one or are we giving a dummy value?

Thanks in advance for the help....

Sudhiiiii...

|||Replace "localhost" with the name of your reports server.|||

Hi,

First of all thanks for the reply.

I tried the above stated method and the URL for my system was "http://localhost/reportserver$sqlserver/reportexecution2005.asmx".

As i'm developing a Windows application solution, i hasn't deployed any of my reports in the specified URL or any other.

I tried to add the URL as a Web reference its saying the URL doesnot contain any web service.

I tried to browse the URL manually, its saying that there is an authentication problem, and user "systemname\ASPNet" is unable to connect to the Database.I went to Sql server and given all the rights to 'aspnet" user , which was a normal user previously.In IIS i tried giving anonyous rights as well as windows integrated user for the virtual directory .My DB is having full rights, and working on integrated user while using the forms.

still the problem persists.

1) is the problem in SQL server or IIS or windows...?

2)Does this has any relation to 'ASP.Net state service' service in windows

3) will me publishing the reorts in iis server will solve the issue. I should have tried this but i'm a too newbie in this and i need to search for how to do that...

Please do help...... Thanks in advance......

Sudhiiii....

|||

Sudeesh,

If you are developing a windows application then you should use the ReportViewer control. This can be used in one of 2 modes:

local mode: the report files are saved as RDLC and stored in the application directory (no report server required)

server mode: where the control connects to a report server and displays shared reports. For this reports need to deployed tot he server.

|||

Hi Adam,

Thanks a lot for the reply...

I should have told my problem in detail...

Let me do that now..

I'm creating a windows application With Vb2005 and Sql 2005 express editions.
The basic point is to create 5 reports from the data in sql tables, each one having several subreports. These reports have to be exported to Excel as there was a VBA application on Excel previously.Currently I'm able to manually save each report as an individual file and later open five excel files move/copy them into one file and then save the excel.I want to automate the task using code such that for the end user it should be like, one button pressed and five reports are saved to excel file... The issue is that i'm able to save at least a report to an excel file manually only, not using code.

Once i'm able to save one report by code we can bundle all of them into one workbook.

To view the report I'm using Reportviewer control but i'm not able to save it.

I hope i made it clear....

Sudhiiiii...

sql

How to fire off a report and save it as pdf...

Using vb.net, does anyone know or has anyone fired off a sql report, save it as PDF to a defined path?

I am knew to sql reporting services and the help files are not very helpfile.

Any sample code would be helpful.

Thanks

Hello,

Have a look at the sample code on this page:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx

Specify the export format you want (in your case "PDF") as a parameter to the Render method.

-Chris

|||

I looked at the sample code, how ever, not sure where the references are to things like

"ReportExecutionService" and some of the other objects.

WHich .net items do I need to import?

Daryl

|||In your project you need add a web reference to the reportexecution service. this will create a proxy class that you an instantiate in code to call the web service|||does it matter that I am NOT building a web application? Building a Desktop vb.net exe.|||no it doesn't matter|||

I cannot find this reference. I looked in windows and system...

|||

Right-click your project and select "Add Web Reference"

How to fire off a report and save it as pdf...

Using vb.net, does anyone know or has anyone fired off a sql report, save it as PDF to a defined path?

I am knew to sql reporting services and the help files are not very helpfile.

Any sample code would be helpful.

Thanks

Hello,

Have a look at the sample code on this page:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx

Specify the export format you want (in your case "PDF") as a parameter to the Render method.

-Chris

|||

I looked at the sample code, how ever, not sure where the references are to things like

"ReportExecutionService" and some of the other objects.

WHich .net items do I need to import?

Daryl

|||In your project you need add a web reference to the reportexecution service. this will create a proxy class that you an instantiate in code to call the web service|||does it matter that I am NOT building a web application? Building a Desktop vb.net exe.|||no it doesn't matter|||

I cannot find this reference. I looked in windows and system...

|||Right-click your project and select "Add Web Reference"|||

Hi Adam,

The post and the replies are really useful. Thanks a lot for the help...

Adam, the URL "http://localhost/reportserver/reportexecution2005.asmx" needs to be a working one or are we giving a dummy value?

Thanks in advance for the help....

Sudhiiiii...

|||Replace "localhost" with the name of your reports server.|||

Hi,

First of all thanks for the reply.

I tried the above stated method and the URL for my system was "http://localhost/reportserver$sqlserver/reportexecution2005.asmx".

As i'm developing a Windows application solution, i hasn't deployed any of my reports in the specified URL or any other.

I tried to add the URL as a Web reference its saying the URL doesnot contain any web service.

I tried to browse the URL manually, its saying that there is an authentication problem, and user "systemname\ASPNet" is unable to connect to the Database.I went to Sql server and given all the rights to 'aspnet" user , which was a normal user previously.In IIS i tried giving anonyous rights as well as windows integrated user for the virtual directory .My DB is having full rights, and working on integrated user while using the forms.

still the problem persists.

1) is the problem in SQL server or IIS or windows...?

2)Does this has any relation to 'ASP.Net state service' service in windows

3) will me publishing the reorts in iis server will solve the issue. I should have tried this but i'm a too newbie in this and i need to search for how to do that...

Please do help...... Thanks in advance......

Sudhiiii....

|||

Sudeesh,

If you are developing a windows application then you should use the ReportViewer control. This can be used in one of 2 modes:

local mode: the report files are saved as RDLC and stored in the application directory (no report server required)

server mode: where the control connects to a report server and displays shared reports. For this reports need to deployed tot he server.

|||

Hi Adam,

Thanks a lot for the reply...

I should have told my problem in detail...

Let me do that now..

I'm creating a windows application With Vb2005 and Sql 2005 express editions.
The basic point is to create 5 reports from the data in sql tables, each one having several subreports. These reports have to be exported to Excel as there was a VBA application on Excel previously.Currently I'm able to manually save each report as an individual file and later open five excel files move/copy them into one file and then save the excel.I want to automate the task using code such that for the end user it should be like, one button pressed and five reports are saved to excel file... The issue is that i'm able to save at least a report to an excel file manually only, not using code.

Once i'm able to save one report by code we can bundle all of them into one workbook.

To view the report I'm using Reportviewer control but i'm not able to save it.

I hope i made it clear....

Sudhiiiii...

How to fire off a report and save it as pdf...

Using vb.net, does anyone know or has anyone fired off a sql report, save it as PDF to a defined path?

I am knew to sql reporting services and the help files are not very helpfile.

Any sample code would be helpful.

Thanks

Hello,

Have a look at the sample code on this page:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx

Specify the export format you want (in your case "PDF") as a parameter to the Render method.

-Chris

|||

I looked at the sample code, how ever, not sure where the references are to things like

"ReportExecutionService" and some of the other objects.

WHich .net items do I need to import?

Daryl

|||In your project you need add a web reference to the reportexecution service. this will create a proxy class that you an instantiate in code to call the web service|||does it matter that I am NOT building a web application? Building a Desktop vb.net exe.|||no it doesn't matter|||

I cannot find this reference. I looked in windows and system...

|||Right-click your project and select "Add Web Reference"|||

Hi Adam,

The post and the replies are really useful. Thanks a lot for the help...

Adam, the URL "http://localhost/reportserver/reportexecution2005.asmx" needs to be a working one or are we giving a dummy value?

Thanks in advance for the help....

Sudhiiiii...

|||Replace "localhost" with the name of your reports server.|||

Hi,

First of all thanks for the reply.

I tried the above stated method and the URL for my system was "http://localhost/reportserver$sqlserver/reportexecution2005.asmx".

As i'm developing a Windows application solution, i hasn't deployed any of my reports in the specified URL or any other.

I tried to add the URL as a Web reference its saying the URL doesnot contain any web service.

I tried to browse the URL manually, its saying that there is an authentication problem, and user "systemname\ASPNet" is unable to connect to the Database.I went to Sql server and given all the rights to 'aspnet" user , which was a normal user previously.In IIS i tried giving anonyous rights as well as windows integrated user for the virtual directory .My DB is having full rights, and working on integrated user while using the forms.

still the problem persists.

1) is the problem in SQL server or IIS or windows...?

2)Does this has any relation to 'ASP.Net state service' service in windows

3) will me publishing the reorts in iis server will solve the issue. I should have tried this but i'm a too newbie in this and i need to search for how to do that...

Please do help...... Thanks in advance......

Sudhiiii....

|||

Sudeesh,

If you are developing a windows application then you should use the ReportViewer control. This can be used in one of 2 modes:

local mode: the report files are saved as RDLC and stored in the application directory (no report server required)

server mode: where the control connects to a report server and displays shared reports. For this reports need to deployed tot he server.

|||

Hi Adam,

Thanks a lot for the reply...

I should have told my problem in detail...

Let me do that now..

I'm creating a windows application With Vb2005 and Sql 2005 express editions.
The basic point is to create 5 reports from the data in sql tables, each one having several subreports. These reports have to be exported to Excel as there was a VBA application on Excel previously.Currently I'm able to manually save each report as an individual file and later open five excel files move/copy them into one file and then save the excel.I want to automate the task using code such that for the end user it should be like, one button pressed and five reports are saved to excel file... The issue is that i'm able to save at least a report to an excel file manually only, not using code.

Once i'm able to save one report by code we can bundle all of them into one workbook.

To view the report I'm using Reportviewer control but i'm not able to save it.

I hope i made it clear....

Sudhiiiii...

how to find out reporting services version?

i'm using sql 2000 with reporting services standard edition. is there a
way to find out or query the version for the reporting services?
thank you.From a previous thread,
For the server, go to the URL of the report server
(http://server/reportserver/). At the bottom of the page, you will see the
version information, 8.00.743 is RTM, 8.00.878 is SP1, 8.00.1038 is SP2.
For the client, see HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\Reporting Services\Version\
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1139259844.678884.194700@.o13g2000cwo.googlegroups.com...
> i'm using sql 2000 with reporting services standard edition. is there a
> way to find out or query the version for the reporting services?
> thank you.
>

How to find out Reporting Services is installed ?

Is there any easy way to find out whether Reporting Services has been
installed on a SQL 2000 Server ?
Thanks
Peterhttp://servername/ReportServer
If it's installed this will show you version information.
Reporting Services creates x2 new databases, ReportServer and
ReportServerTempDB if these exist thats a good indication also.
--
HTH. Ryan
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:ODmuIvsEHHA.996@.TK2MSFTNGP02.phx.gbl...
> Is there any easy way to find out whether Reporting Services has been
> installed on a SQL 2000 Server ?
> Thanks
> Peter
>

How to find out PublicKeyBlob

I have created a custom authentication for Reporting Services, and it works great if I edit the RsSvrPolicy.congif like the following:

<CodeGroup class="UnionCodeGroup" version="1" Name="SecurityExtensionCodeGroup" Description="Code group for the security extension" PermissionSetName="FullTrust">
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\myfile.dll" />

But the guideline says a strong named assemly is better, so I created a strong named assembly and registered it in the GAC, but how do I find out the PublicKeyBlob to enter in the config file?

Regards AndreasUse 'sn -Tp assemblyfilename' from a VisualStudio command prompt.|||After you run the command, I think if you RightClick -> SelectAll, then hit the Enter key, it should copy the entire command prompt contents to the clipboard for pasting.|||

Ahh, thank you!

// Andreas

How to filter reports user logon info

I am new to reporting services
Is there an example of how to obtain user logon information to use as input
for queries before report renders. We will deploy reports to a portal and
want to use the user logon info as a filter for initial queries ( for example
to restrict information viewed by client ). Thanks.You can use the User!UserID global, which is the logged on username. Pass
it into a query parameter. Of course, you will need to have data in your
source database tables that includes the UserID values, to join and filter
your data.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:927CF045-4639-48E0-BF84-46D8A52BD532@.microsoft.com...
>I am new to reporting services
> Is there an example of how to obtain user logon information to use as
> input
> for queries before report renders. We will deploy reports to a portal and
> want to use the user logon info as a filter for initial queries ( for
> example
> to restrict information viewed by client ). Thanks.|||Where is it picking up the global value from? When I was working with
Cleverpath portal before (CA's portal product) the reports were published to
the portal and the logon id was obtained from the portal signon. In the case
of RS, the reports are deployed to the report server - are there tables
associated with the report server? Is it getting the value from the browser
session?
"Jeff A. Stucker" wrote:
> You can use the User!UserID global, which is the logged on username. Pass
> it into a query parameter. Of course, you will need to have data in your
> source database tables that includes the UserID values, to join and filter
> your data.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:927CF045-4639-48E0-BF84-46D8A52BD532@.microsoft.com...
> >I am new to reporting services
> > Is there an example of how to obtain user logon information to use as
> > input
> > for queries before report renders. We will deploy reports to a portal and
> > want to use the user logon info as a filter for initial queries ( for
> > example
> > to restrict information viewed by client ). Thanks.
>
>|||Yes, it's getting the user name from the session. If you have Windows
Authentication, it's getting it from the OS. If you have custom security
and forms auth, then it's getting it from the forms auth cookie.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:A5CD5045-9C76-4F0E-B092-F1AB2B372A1E@.microsoft.com...
> Where is it picking up the global value from? When I was working with
> Cleverpath portal before (CA's portal product) the reports were published
> to
> the portal and the logon id was obtained from the portal signon. In the
> case
> of RS, the reports are deployed to the report server - are there tables
> associated with the report server? Is it getting the value from the
> browser
> session?
> "Jeff A. Stucker" wrote:
>> You can use the User!UserID global, which is the logged on username.
>> Pass
>> it into a query parameter. Of course, you will need to have data in your
>> source database tables that includes the UserID values, to join and
>> filter
>> your data.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
>> news:927CF045-4639-48E0-BF84-46D8A52BD532@.microsoft.com...
>> >I am new to reporting services
>> > Is there an example of how to obtain user logon information to use as
>> > input
>> > for queries before report renders. We will deploy reports to a portal
>> > and
>> > want to use the user logon info as a filter for initial queries ( for
>> > example
>> > to restrict information viewed by client ). Thanks.
>>

How to filter a report using an asp.net page

Hi,
I need to filter a single .rdl page in accordance with an option chosen from an asp.net page.
I know how to filter a report within the reporting page. But how can I do the filtering from an asp.net page? For example I have a Report1.rdl that prints out all the locations. I need the same report1.rdl page to print out only for a certain location based on the option I chose from the asp.net page. My asp.net page has 3 buttons. One to for all locations, another for location1, and the other one for location2. Please help. Thanks

1. Add a parameter to the report for location.

2. Modify your SQL code to account for that parameter, ie. WHERE Location = @.Location.

3. In Visual Studio, pass the location parameter value based upon the option chosen.

|||

GregSQL wrote:

1. Add a parameter to the report for location.

2. Modify your SQL code to account for that parameter, ie. WHERE Location = @.Location.

3. In Visual Studio, pass the location parameter value based upon the option chosen.

Thanks Greg. I got 1 and 2 working. Now how do I make the 3rd part? How do I call the parameters from an asp.net page to show the report in a browser? Thanks again for your help.
|||

Code Snippet

Dim param AsNew Microsoft.Reporting.WebForms.ReportParameter

Dim paramarr(0) As Microsoft.Reporting.WebForms.ReportParameter

param = New Microsoft.Reporting.WebForms.ReportParameter("myParameter", DropDownList1.SelectedValue.ToString())

paramarr(0) = param

ReportViewer1.ServerReport.SetParameters(paramarr)

This would set the report parameter myParameter to the selected value of DropDownList1. Remember that the parameterarray's starting index is zero...that typically leads me to off by one errors.

Oh and I was somewhat assuming that you already knew how to use a report viewer component in .NET to display a report in an internet browser. If not, let me know.