Changing the Sender in XP_Sendmail

Is is possible to change the sender when using XP_Sendmail? I am sending a
notification that reports are available in reporting services in a single
email and want to change the sender from SQLSERVICEADMIN to something users
will recgonize easily.
Thanks for the help!!
Anthonyanthonysjo wrote:

> Is is possible to change the sender when using XP_Sendmail? I am
> sending a notification that reports are available in reporting
> services in a single email and want to change the sender from
> SQLSERVICEADMIN to something users will recgonize easily.
You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)
HTH,
Stijn Verrept.|||Yes, I had found reference to that but my DBA's will push heavily on not
installing it. Is there another way?
"Stijn Verrept" wrote:

> anthonysjo wrote:
>
>
> You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)
> --
> HTH,
> Stijn Verrept.
>|||As I know there is no way using the "friendly" name within XP_sendmail.
Once I had a commandline program which was able to send also via SMTP.
But this could be easily reprogrammed in .NET or another programming
language covering the same functionality. If you are interested in,
just send me a mail.
HTH, Jens Suessmeyer.

Changing the FROM in the email on a subscription

I need to change the email address that appears as the FROM email on reports
that are being delivered via RS2000. I have change the REPLY email and that
is working correctly but I can't seem to find where the FROM email is stored.
Thanks...It is configurable in the rsreportserver.config file on the report
server machine; edit that file and look for the <FROM> tag under the
<RSEmailDPConfiguration> section
Matt A
Steve wrote:
> I need to change the email address that appears as the FROM email on reports
> that are being delivered via RS2000. I have change the REPLY email and that
> is working correctly but I can't seem to find where the FROM email is stored.
> Thanks...|||That did it! Thanks Matt!!!
"Matt" wrote:
> It is configurable in the rsreportserver.config file on the report
> server machine; edit that file and look for the <FROM> tag under the
> <RSEmailDPConfiguration> section
> Matt A
>
> Steve wrote:
> > I need to change the email address that appears as the FROM email on reports
> > that are being delivered via RS2000. I have change the REPLY email and that
> > is working correctly but I can't seem to find where the FROM email is stored.
> > Thanks...
>|||what if I want to have a diffrent from address for each send?
same as you bind the To and the CC? can it be done?
"Steve" wrote:
> That did it! Thanks Matt!!!
> "Matt" wrote:
> > It is configurable in the rsreportserver.config file on the report
> > server machine; edit that file and look for the <FROM> tag under the
> > <RSEmailDPConfiguration> section
> >
> > Matt A
> >
> >
> > Steve wrote:
> > > I need to change the email address that appears as the FROM email on reports
> > > that are being delivered via RS2000. I have change the REPLY email and that
> > > is working correctly but I can't seem to find where the FROM email is stored.
> > > Thanks...
> >
> >

Changing the Apperance of the Report Manager Homepage

Hi,

Does anyone know how to change the Appearance of the Report Manager Homepage

i.e http://Localhost/Reports

Basically I want to add some Images instead of the Blank SQL Server RS Homepage.

Thanks in Advance for your Help,

Regards,

Sundar

http://www.ubookcase.com/book/Addison.Wesley/Hitchhikers.Guide.to.SQL.Server.2000.Reporting.Services/0321268288/ch11.html|||

Hi Buddy,

Thanks a lot for the Link !!

This gave me the information I was looking for !

Thanks,

Sundar

changing subscription email address in RS2000

Is there a way I can change the email address associated to sending timed
reports notifications to users?
Currently it is under my email address and I would like it to change to a
different email address.
TIA,
JacksonNevermind figured it out.
You need to edit the RSReportServer.config file. I had to do a find of the
email address I wanted to replace.
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:umjwsLDCHHA.3924@.TK2MSFTNGP02.phx.gbl...
> Is there a way I can change the email address associated to sending timed
> reports notifications to users?
> Currently it is under my email address and I would like it to change to a
> different email address.
> TIA,
> Jackson
>
>

Changing SSRS reports datasource.

I have a web site that has reports stored in two places.The local site, and in SSRS.The local reports get there data from a class that has a dataset method on it.I would like to store all my reports in SSRS.Is this possible?Can I get just the RDL of a report from the SSRS web service, or change the dataset to what my class generates?

You can adopt one to two approaches:

1) store the RDLC you'll use in a report viewer control on the report server as a resouce.

2) store actual RDL in the report server and use the GetReportDefinition method to obtain the RDL.

What is interesting here is that the data source definitions between the RDLC the control expect and the RDL that the server expects is a little different.

Here's the reference for GetReportDefinition:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.getreportdefinition.aspx

-Lukasz

Changing report schedule according to job completion

I have about 30 reports currently being refreshed every morning at 7:30. The
problem is that the reports should only be refreshed once the data load is
complete.
I checked the ReportServer database and noticed that the schedule is stored
on the Schedule table. Could I just update the StartDate and NextRunTime
columns to make the schedule refresh the reports when I want it (after the
data load is finished)?
Thanks in advance for any help,
Carmen.I have never tried it, but what would it hurt to try?... GO ahead... backup
stuff first..who knows what might happen...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Carmen" wrote:
> I have about 30 reports currently being refreshed every morning at 7:30. The
> problem is that the reports should only be refreshed once the data load is
> complete.
> I checked the ReportServer database and noticed that the schedule is stored
> on the Schedule table. Could I just update the StartDate and NextRunTime
> columns to make the schedule refresh the reports when I want it (after the
> data load is finished)?
> Thanks in advance for any help,
> Carmen.

Changing PDF Output Orientation

I have created report subscriptions for my end users which are emailed
PDF format reports. However, the default report orientation is PORTRAIT
but this format causes the reports to be generated in a very unreadable
way.
Is there a solution to changing the orientation to LANDSCAPE?
Thanks.You can't change the orientation directly - you need to change the
height and width values for the report page (from 11 x 8 1/2 to 8 1/2 x
11).
You also need to ensure the size of the body and the margins are
consistent with these settings.
The Acrobat reader will automatically rotate the page if you have these
settings correct - check the Acrobat settings, too, as it is possible
to have the auto rotate feature turned off.

Changing Page Orientation for Sub Reports

We have a "Master" report that contains several sub-reports. Some of these
sub-reports we need to print in landscape orientation. We have been unable
to figure out how to set the page orientation for sub-reports. We also
looked to see if we could create "sections" (like MS Word) where we could
configure page breaks and page orientation.
Can anyone point us in the right direction?
Thanks,
ChrisUnfortunately, this is not supported in the current release. Other than some
sort of wrapper that chains together multiple reports, I can't think of how
you would do this.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Walls" <msnews@.travantsolutions.com> wrote in message
news:OtQ6K1meEHA.3984@.TK2MSFTNGP10.phx.gbl...
> We have a "Master" report that contains several sub-reports. Some of
> these
> sub-reports we need to print in landscape orientation. We have been unable
> to figure out how to set the page orientation for sub-reports. We also
> looked to see if we could create "sections" (like MS Word) where we could
> configure page breaks and page orientation.
> Can anyone point us in the right direction?
> Thanks,
> Chris
>

Changing order of columns at run time

Here's the scenario:
I want to be able to create a report (typically these reports are
"table like" reports ... in other words, several columns with a list
of data underneath) and I want to be able to re-order the columns (not
the rows) in these reports at runtime.
So, for instance, if the "report design" is as follows:
COLUMNA COLUMNB COLUMNC
... data goes here ...
... I'd like to be able to pass a parameter in to the report that may
be, for instance, "COLUMNC,COLUMNB,COLUMNA" ... and report columns
would re-order, like follows:
COLUMNC COLUMNB COLUMNA
... data goes here ...
... I don't really care what report designer object is used (Table,
Matrix, etc) ... but I don't yet see a good way to do this. It seems
like the Matrix object might be able to do this via the ColumnGroups
"Sorting" tab ... but I don't seem to be able to come up with an
expression that can make this occur.
Any help is greatly appreciated.
Thanks,
RichardOn Apr 27, 9:39 am, Richard.G...@.Pa-Tech.Com wrote:
> Here's the scenario:
> I want to be able to create a report (typically these reports are
> "table like" reports ... in other words, several columns with a list
> of data underneath) and I want to be able to re-order the columns (not
> the rows) in these reports at runtime.
> So, for instance, if the "report design" is as follows:
> COLUMNA COLUMNB COLUMNC
> ... data goes here ...
> ... I'd like to be able to pass a parameter in to the report that may
> be, for instance, "COLUMNC,COLUMNB,COLUMNA" ... and report columns
> would re-order, like follows:
> COLUMNC COLUMNB COLUMNA
> ... data goes here ...
> ... I don't really care what report designer object is used (Table,
> Matrix, etc) ... but I don't yet see a good way to do this. It seems
> like the Matrix object might be able to do this via the ColumnGroups
> "Sorting" tab ... but I don't seem to be able to come up with an
> expression that can make this occur.
> Any help is greatly appreciated.
> Thanks,
> Richard
If you are using a matrix report, you can control the column layout
(assuming you know the column names prior to runtime) by adding spaces
in front of the names of the columns (like values in the pivot column)
and ordering/sorting by ascending order. If you are using a table
control, you can allow the user to select a sort order (asc/desc) in
the report and then set the columns in the returned resultset
accordingly. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Just Like the report was built by Report Builder..
when click title of column ,the order will be change,right?
how to do it in vs2005?
"EMartinez" <emartinez.pr1@.gmail.com>
':1177733247.239100.15830@.n59g2000hsh.googlegroups.com...
> On Apr 27, 9:39 am, Richard.G...@.Pa-Tech.Com wrote:
>> Here's the scenario:
>> I want to be able to create a report (typically these reports are
>> "table like" reports ... in other words, several columns with a list
>> of data underneath) and I want to be able to re-order the columns (not
>> the rows) in these reports at runtime.
>> So, for instance, if the "report design" is as follows:
>> COLUMNA COLUMNB COLUMNC
>> ... data goes here ...
>> ... I'd like to be able to pass a parameter in to the report that may
>> be, for instance, "COLUMNC,COLUMNB,COLUMNA" ... and report columns
>> would re-order, like follows:
>> COLUMNC COLUMNB COLUMNA
>> ... data goes here ...
>> ... I don't really care what report designer object is used (Table,
>> Matrix, etc) ... but I don't yet see a good way to do this. It seems
>> like the Matrix object might be able to do this via the ColumnGroups
>> "Sorting" tab ... but I don't seem to be able to come up with an
>> expression that can make this occur.
>> Any help is greatly appreciated.
>> Thanks,
>> Richard
>
> If you are using a matrix report, you can control the column layout
> (assuming you know the column names prior to runtime) by adding spaces
> in front of the names of the columns (like values in the pivot column)
> and ordering/sorting by ascending order. If you are using a table
> control, you can allow the user to select a sort order (asc/desc) in
> the report and then set the columns in the returned resultset
> accordingly. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||That's called interactive sort. click on the textbox or table textbox
properties and select the interactive sort tab and set your values.
Amarnath
"renhanyue" wrote:
> Just Like the report was built by Report Builder..
> when click title of column ,the order will be change,right?
> how to do it in vs2005?
> "EMartinez" <emartinez.pr1@.gmail.com>
> ':1177733247.239100.15830@.n59g2000hsh.googlegroups.com...
> > On Apr 27, 9:39 am, Richard.G...@.Pa-Tech.Com wrote:
> >> Here's the scenario:
> >>
> >> I want to be able to create a report (typically these reports are
> >> "table like" reports ... in other words, several columns with a list
> >> of data underneath) and I want to be able to re-order the columns (not
> >> the rows) in these reports at runtime.
> >>
> >> So, for instance, if the "report design" is as follows:
> >>
> >> COLUMNA COLUMNB COLUMNC
> >> ... data goes here ...
> >>
> >> ... I'd like to be able to pass a parameter in to the report that may
> >> be, for instance, "COLUMNC,COLUMNB,COLUMNA" ... and report columns
> >> would re-order, like follows:
> >>
> >> COLUMNC COLUMNB COLUMNA
> >> ... data goes here ...
> >>
> >> ... I don't really care what report designer object is used (Table,
> >> Matrix, etc) ... but I don't yet see a good way to do this. It seems
> >> like the Matrix object might be able to do this via the ColumnGroups
> >> "Sorting" tab ... but I don't seem to be able to come up with an
> >> expression that can make this occur.
> >>
> >> Any help is greatly appreciated.
> >>
> >> Thanks,
> >> Richard
> >
> >
> > If you are using a matrix report, you can control the column layout
> > (assuming you know the column names prior to runtime) by adding spaces
> > in front of the names of the columns (like values in the pivot column)
> > and ordering/sorting by ascending order. If you are using a table
> > control, you can allow the user to select a sort order (asc/desc) in
> > the report and then set the columns in the returned resultset
> > accordingly. Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> >
>
>|||The issue is that I'm trying to change is the order of the columns
themselves (left to right) ... not the data "within" the column (which
would be the "top to bottom").
Normally, these reports would be simple "table" reports ... the
"extra" feature that I need to give to my users is the ability specify
the order of the columns (left to right)
To further clarify, if the report where a simple SQL statement, the
report designer might specify:
SELECT A, B, C FROM SOMETABLE
... but I want to give the report "user" the ability to say
SELECT C, B, A FROM SOMETABLE

Changing layout for report

Hi all!
Does anyone know if it is possible to change the layout of reports? I'm
using reporting services for some new reports in our application, and I want
the new reports to look similiar to the existing reports. Some of the things
I would like to do is to move the parameters to the right of the report
(instead of having them on top) and changing background color for parameters
area and tool bar.
Can anyone tell me if this is possible, and if so, how can I achieve this?
Thanks!
Regards
HanneUsing Report Manager this is not possible... You would have to use your own
ASPX pages to create what you wish.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Hanne" wrote:
> Hi all!
> Does anyone know if it is possible to change the layout of reports? I'm
> using reporting services for some new reports in our application, and I want
> the new reports to look similiar to the existing reports. Some of the things
> I would like to do is to move the parameters to the right of the report
> (instead of having them on top) and changing background color for parameters
> area and tool bar.
> Can anyone tell me if this is possible, and if so, how can I achieve this?
> Thanks!
> Regards
> Hanne|||I'm fairly new to both RS and ASP.NET... Could you please briefly explain how
this works and how I use the reports with my own ASPX pages? Would really
appreciate it if you could!! Do you have any samples?
Regards
Hanne
"Wayne Snyder" wrote:
> Using Report Manager this is not possible... You would have to use your own
> ASPX pages to create what you wish.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Hanne" wrote:
> > Hi all!
> >
> > Does anyone know if it is possible to change the layout of reports? I'm
> > using reporting services for some new reports in our application, and I want
> > the new reports to look similiar to the existing reports. Some of the things
> > I would like to do is to move the parameters to the right of the report
> > (instead of having them on top) and changing background color for parameters
> > area and tool bar.
> >
> > Can anyone tell me if this is possible, and if so, how can I achieve this?
> >
> > Thanks!
> >
> > Regards
> > Hanne

Changing language helps ( rrRenderingError) but.....

I want to display my reports in dutch.
Of what is the language dependent? server properties ?
Can you explain how the export to PDF-format effects the report-language
properties and/or serverproperties ?
Thanks in AdvanceLanguage is a Report property.
Open the Properties window (F4), and select 'Report' from the dropdown list.
Language is the second-last property displayed.
If you set it to Dutch, functions like Month() will return Dutch month names.
My 2c.
Flip
"Bobby" wrote:
> I want to display my reports in dutch.
> Of what is the language dependent? server properties ?
> Can you explain how the export to PDF-format effects the report-language
> properties and/or serverproperties ?
> Thanks in Advance
>
>
>

changing lable in bar chart

hi all

i am using bar chart in my reports , i want to show the intervel on my y axis like

0k,2k,4k,6k,.......

but it is showing like 0,2000,4000,6000 .... by default . i dont know hoe to achieve this please help.

Hi,

In the Value expression for the Data you are showing, divide by 1000. For example if the expression currently is

Fields!XYZ.Value, make it Fields!XYZ.Value/1000.

Then go to the Y Axis tab and in the Format Code option, put the value 0k.

I think this should give you the desired output.

-Aayush.

|||thanks Aayush it realy works

Changing Header based on subreport

Hi,
How can I change the contents of a container reports page header based on
the subreport that is being rendered?
Thanks,
JohnNever mind. Did workaround by putting each subreport in separate table with
separate table header and page break after table checked. originally had
each subreport in separate header lines in a single table.
Thanks,
John
"John" wrote:
> Hi,
> How can I change the contents of a container reports page header based on
> the subreport that is being rendered?
> Thanks,
> John

Changing font color dynamically in Crystal Reports

I have a windows app which uses the free version of Crystal Reports. The idea is that I should allow the users to choose their own font and colors (for example one might want to see the title green and arial). Do you happen to know how I can do that? I don't even know if it is possible given that there is practically no code behind the reports...

Thank you in advance. :)Add parameters to the report for font and font color. Right click the report field, select "format field", click the font tab and click the formula buttons next to each of the font attributes and add the code to read your parameters to make the select settings|||Can you please give me an example?|||Select {?FontColor} <--This is your parameter field
Case "Red": <-You should have a case stament for each color
crRed
Case "Black":
crBlack
Default:
DefaultAttribute

Here are the default color attributes.
crBlack
crMaroon
crGreen
crOlive
crNavy
crPurple
crTeal
crSilver
crRed
crLime
crYellow
crBlue
crFuchsia
crAqua
crWhite

Do the same for the font replacing the colors with the font names.|||But where do I write this code?|||Right click the report field, select "format field", click the font tab and click the formula buttons next to each of the font attributes and add the code to read your parameters to make the selected settings

As I originally stated above..|||try sample code as mentioned below. You can get access to any object in the report and from code, you can change the object property just like you do using visual studio. Sorry for not answering you stright. But this info will very helpful to you I recon.

Private Sub AdjustCarPicSize(ByVal iHeight As Integer, ByVal iWidth As Integer)
'For Each section As CrystalDecisions.CrystalReports.Engine.Section In reportDocument.ReportDefinition.Sections
' For Each reportObject As CrystalDecisions.CrystalReports.Engine.ReportObject In section.ReportObjects
' If reportObject.Kind = ReportObjectKind.SubreportObject Then
' Dim subReport As SubreportObject = CType(reportObject, SubreportObject)
' Dim subDocument As ReportDocument = subReport.OpenSubreport(subReport.SubreportName)
' If (subReport.SubreportName = "CarPic") Then
' For Each section1 As CrystalDecisions.CrystalReports.Engine.Section In subDocument.ReportDefinition.Sections
' For Each reportObject1 As CrystalDecisions.CrystalReports.Engine.ReportObject In section1.ReportObjects
' 'Response.Write(reportObject1.Name)
' If (reportObject1.Name = "carpicimage1") Then
' reportObject1.Height = iHeight
' reportObject1.Width = iWidth
' End If

' Next
' Next
' End If

' End If
' Next
'Next
Dim oCarPic As CrystalDecisions.CrystalReports.Engine.ReportObject = CType(reportDocument.ReportDefinition.Sections("DetailSection6").ReportObjects("Subreport1"), SubreportObject).OpenSubreport("CarPic").ReportDefinition.Sections("ReportHeaderSection2").ReportObjects("carpicimage1")

Changing domain password hoses subscriptions

Recently, I was prompted to change my domain password. Changed service
account for SQL and RS (2000 both) and reports and datasource credentials.
Reports run fine. However, getting the infamous "An internal error occurred
on the report server. See the error log for more details." error on all
subscriptions when nothing else changed. Went in and ran rsconfig to update
with the latest pwd but no joy. I know I'm missing something obvious but am
still futzing with this.
Any thoughts as to what I should be checking/correcting?Just a guess, but if your subscriptions store the report as a pdf in a
directory, could there be permissions problems there?
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"kvanhulle" wrote:
> Recently, I was prompted to change my domain password. Changed service
> account for SQL and RS (2000 both) and reports and datasource credentials.
> Reports run fine. However, getting the infamous "An internal error occurred
> on the report server. See the error log for more details." error on all
> subscriptions when nothing else changed. Went in and ran rsconfig to update
> with the latest pwd but no joy. I know I'm missing something obvious but am
> still futzing with this.
> Any thoughts as to what I should be checking/correcting?
>
>

Changing Default Rendering Method of Reports

Ladies and Gents,

I have a question with regards to the default rendering extensions for reports. I am using RS 2005 with SP1.

I am accessing a report as follows:

http://<ReportServerName>/Reportserver?/<Folder>/<Report Name>

Sample: http://TestServer/Reportserver?/Special Reports/Dealer Report

This displays the parameter bar and the view report button. When pressing the view report button, the report is automatically rendered into HTML 4.0. Is there a way to use the existing parameter bar and automatically render the report to a different extension (such as PDF) when the parameters are entered and the View Report Button is pressed.

Thank You for any advice you can give,

Raph

No, but you can specify the render format in the report URL, e.g. http://TestServer/Reportserver?/Special Reports/Dealer Report&rs:Format=PDF&rs:Command=Render|||

Teo,

Thank you for your reply, and for all the other documents and articles you have created about reporting services. They have been a great help during my current project.

I was trying to prevent reinventing the wheel. By that, I mean having to create a web form to capture the parameters for our reports when the report server seems to have one that works effectively (with the exception that the default format of report rendering is HTML 4.0 which behaves very poorly with alternative browsers) .

If you have any advice on any existing parameter capture tool that anyone has developed with RS that will allow us to choose the render method, I would be happy to take it.

Again, Thanks for the quick reply.

Raph

|||I understand but the standard toolbar is not customizable and you have no way to capture the event. If this was a custom web application and use the ASP.NET 2.0 ReportViewer control, then you could capture the event. Now, if you want to get innovative, you could create an HttpHandler that will change the URL requests accordingly. If you decide to do so, you may find my RSHttpHandler sample useful (see the Chapter 18 code in this download).|||

Teo,

Again, thanks for the help. I will look into your suggestions and see if they can be leveraged to meet our needs.

Raph

|||

I have a question similar to this - about changing default rendering:

I only want to change the default zoom to be page width. I'm not sure if I'm able to do this in the following environment:

RS 2005 SP2 on top of SharePoint Services 3.0 - I'm using the ReportViewer web part. Given that real estate is a bit of an issue when rendering webparts in a sharepoint page with other content, I'd like the default zoom to be page width based on the height and width of the webpart - so that I don't have to scroll horizontally within the webpart to see the report.

I know you can resize the webpart window - but I've got other content on the page, and I can't make it large enough to display the report width, so I'd like the default zoom to fit the size of the webpart (at least horizontally, scrolling vertically is not a big deal.

Is there a way to set this so that the Report Viewer web part can be configured to do this?

Thanks

|||

I'm not really sure whether you could do this using your current technology, but it certainly seems possible:

http://msdn2.microsoft.com/en-us/library/ms152835.aspx

The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width

|||Unfortunately, the Report Viewer web part doesn't surface the ZoomMode property of the underlying ASP.NET Report Viewer control. I suggest you add this to the wish list.|||I had to write my own web part to accomplish this in sts 2.0. SQL Server 2005 Service pack 2 was released recently, this allows you to run Sharepoint integration mode and possibly get a better view on reports.

Changing Default Rendering Method of Reports

Ladies and Gents,

I have a question with regards to the default rendering extensions for reports. I am using RS 2005 with SP1.

I am accessing a report as follows:

http://<ReportServerName>/Reportserver?/<Folder>/<Report Name>

Sample: http://TestServer/Reportserver?/Special Reports/Dealer Report

This displays the parameter bar and the view report button. When pressing the view report button, the report is automatically rendered into HTML 4.0. Is there a way to use the existing parameter bar and automatically render the report to a different extension (such as PDF) when the parameters are entered and the View Report Button is pressed.

Thank You for any advice you can give,

Raph

No, but you can specify the render format in the report URL, e.g. http://TestServer/Reportserver?/Special Reports/Dealer Report&rs:Format=PDF&rs:Command=Render|||

Teo,

Thank you for your reply, and for all the other documents and articles you have created about reporting services. They have been a great help during my current project.

I was trying to prevent reinventing the wheel. By that, I mean having to create a web form to capture the parameters for our reports when the report server seems to have one that works effectively (with the exception that the default format of report rendering is HTML 4.0 which behaves very poorly with alternative browsers) .

If you have any advice on any existing parameter capture tool that anyone has developed with RS that will allow us to choose the render method, I would be happy to take it.

Again, Thanks for the quick reply.

Raph

|||I understand but the standard toolbar is not customizable and you have no way to capture the event. If this was a custom web application and use the ASP.NET 2.0 ReportViewer control, then you could capture the event. Now, if you want to get innovative, you could create an HttpHandler that will change the URL requests accordingly. If you decide to do so, you may find my RSHttpHandler sample useful (see the Chapter 18 code in this download).|||

Teo,

Again, thanks for the help. I will look into your suggestions and see if they can be leveraged to meet our needs.

Raph

|||

I have a question similar to this - about changing default rendering:

I only want to change the default zoom to be page width. I'm not sure if I'm able to do this in the following environment:

RS 2005 SP2 on top of SharePoint Services 3.0 - I'm using the ReportViewer web part. Given that real estate is a bit of an issue when rendering webparts in a sharepoint page with other content, I'd like the default zoom to be page width based on the height and width of the webpart - so that I don't have to scroll horizontally within the webpart to see the report.

I know you can resize the webpart window - but I've got other content on the page, and I can't make it large enough to display the report width, so I'd like the default zoom to fit the size of the webpart (at least horizontally, scrolling vertically is not a big deal.

Is there a way to set this so that the Report Viewer web part can be configured to do this?

Thanks

|||

I'm not really sure whether you could do this using your current technology, but it certainly seems possible:

http://msdn2.microsoft.com/en-us/library/ms152835.aspx

The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width

|||Unfortunately, the Report Viewer web part doesn't surface the ZoomMode property of the underlying ASP.NET Report Viewer control. I suggest you add this to the wish list.|||I had to write my own web part to accomplish this in sts 2.0. SQL Server 2005 Service pack 2 was released recently, this allows you to run Sharepoint integration mode and possibly get a better view on reports.

Changing Default Rendering Method of Reports

Ladies and Gents,

I have a question with regards to the default rendering extensions for reports. I am using RS 2005 with SP1.

I am accessing a report as follows:

http://<ReportServerName>/Reportserver?/<Folder>/<Report Name>

Sample: http://TestServer/Reportserver?/Special Reports/Dealer Report

This displays the parameter bar and the view report button. When pressing the view report button, the report is automatically rendered into HTML 4.0. Is there a way to use the existing parameter bar and automatically render the report to a different extension (such as PDF) when the parameters are entered and the View Report Button is pressed.

Thank You for any advice you can give,

Raph

No, but you can specify the render format in the report URL, e.g. http://TestServer/Reportserver?/Special Reports/Dealer Report&rs:Format=PDF&rs:Command=Render|||

Teo,

Thank you for your reply, and for all the other documents and articles you have created about reporting services. They have been a great help during my current project.

I was trying to prevent reinventing the wheel. By that, I mean having to create a web form to capture the parameters for our reports when the report server seems to have one that works effectively (with the exception that the default format of report rendering is HTML 4.0 which behaves very poorly with alternative browsers) .

If you have any advice on any existing parameter capture tool that anyone has developed with RS that will allow us to choose the render method, I would be happy to take it.

Again, Thanks for the quick reply.

Raph

|||I understand but the standard toolbar is not customizable and you have no way to capture the event. If this was a custom web application and use the ASP.NET 2.0 ReportViewer control, then you could capture the event. Now, if you want to get innovative, you could create an HttpHandler that will change the URL requests accordingly. If you decide to do so, you may find my RSHttpHandler sample useful (see the Chapter 18 code in this download).|||

Teo,

Again, thanks for the help. I will look into your suggestions and see if they can be leveraged to meet our needs.

Raph

|||

I have a question similar to this - about changing default rendering:

I only want to change the default zoom to be page width. I'm not sure if I'm able to do this in the following environment:

RS 2005 SP2 on top of SharePoint Services 3.0 - I'm using the ReportViewer web part. Given that real estate is a bit of an issue when rendering webparts in a sharepoint page with other content, I'd like the default zoom to be page width based on the height and width of the webpart - so that I don't have to scroll horizontally within the webpart to see the report.

I know you can resize the webpart window - but I've got other content on the page, and I can't make it large enough to display the report width, so I'd like the default zoom to fit the size of the webpart (at least horizontally, scrolling vertically is not a big deal.

Is there a way to set this so that the Report Viewer web part can be configured to do this?

Thanks

|||

I'm not really sure whether you could do this using your current technology, but it certainly seems possible:

http://msdn2.microsoft.com/en-us/library/ms152835.aspx

The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width

|||Unfortunately, the Report Viewer web part doesn't surface the ZoomMode property of the underlying ASP.NET Report Viewer control. I suggest you add this to the wish list.|||I had to write my own web part to accomplish this in sts 2.0. SQL Server 2005 Service pack 2 was released recently, this allows you to run Sharepoint integration mode and possibly get a better view on reports.

changing datasource to SQL Server

Greetings,
I have a set of reports that were created using the report designer in
Visual Studio. They were originally written to run against an Informix
database, but I now need to change them to run against an SQL Server
DB. I added a new datasource for the SQL Server DB, but couldn't find
*any* way to change the reports to point to this new datasource. I've
worked around this problem by changing the properties of the existing
(Informix) datasource to point to the SQL Server DB, but if anyone
knows how to change *just* the datasource of a report, I'd be very
grateful if they'd let me know.
The queries that the reports execute currently use '?' to indicate an
Informix SQL parameter, but I believe SQL Server uses '@.param_name'
instead. If I replace each ? with @.param_name (in the 'SQL' pane of
the 'Data' tab) and map each @.param_name to the corresponding
ReportParameter, will this work, or is there something else I need to
do?
Thanks in Advance,
DonThe way you change the datasource is by going to the dataset, click on the
... and change the datasource. Or you can edit the rdl. Yes, changing and
remapping the parameters should work. One problem you will have is that RS
will try to create the report parameters so you very well will end up with
extra report parameters that you have to remove. Or, do this. Make sure you
have a copy of the rdl. Open up the report into the designer and go into
code view. Edit the xml with the parameter mapping, save, go to layout and
preview and see if it works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don" <donalmurtagh@.yahoo.co.uk> wrote in message
news:aa1c6f54.0504290857.60998e06@.posting.google.com...
> Greetings,
> I have a set of reports that were created using the report designer in
> Visual Studio. They were originally written to run against an Informix
> database, but I now need to change them to run against an SQL Server
> DB. I added a new datasource for the SQL Server DB, but couldn't find
> *any* way to change the reports to point to this new datasource. I've
> worked around this problem by changing the properties of the existing
> (Informix) datasource to point to the SQL Server DB, but if anyone
> knows how to change *just* the datasource of a report, I'd be very
> grateful if they'd let me know.
> The queries that the reports execute currently use '?' to indicate an
> Informix SQL parameter, but I believe SQL Server uses '@.param_name'
> instead. If I replace each ? with @.param_name (in the 'SQL' pane of
> the 'Data' tab) and map each @.param_name to the corresponding
> ReportParameter, will this work, or is there something else I need to
> do?
> Thanks in Advance,
> Don|||Hi Bruce,
Thanks very much for your response. I thought about editing the .rdl
directly in order to change the datasource, but the autogenerated IDs
scared me off - what exactly are these used for?
I'm aware that RS adds report parameters whenever you change an SQL
parameters - it's an annoying "feature", but not catastrophic. Are you
saying that if I replace every reference to the '?' parameters with a
'@.param' in the XML code then I won't have to deal with this?
Thanks Again,
Don|||Yep. I also do this sometimes when I am modifying a complicated SQL
Statement because sometimes with ODBC datasource it loses all the mappings
and I have to remap so I will go in and modify the SQL so the helpful IDE
doesn't mess everything up. Again, make a copy because it is easy to mess up
the xml.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<donalmurtagh@.yahoo.co.uk> wrote in message
news:1114946322.881807.132260@.g14g2000cwa.googlegroups.com...
> Hi Bruce,
> Thanks very much for your response. I thought about editing the .rdl
> directly in order to change the datasource, but the autogenerated IDs
> scared me off - what exactly are these used for?
> I'm aware that RS adds report parameters whenever you change an SQL
> parameters - it's an annoying "feature", but not catastrophic. Are you
> saying that if I replace every reference to the '?' parameters with a
> '@.param' in the XML code then I won't have to deal with this?
> Thanks Again,
> Don
>

Changing Databases

I have two databases on the same SQL server which have identical data
structures.
I want to be able to use one set of reports on my report server to run
against either database. How can I achieve this? Whenever I run the report
it always runs against whatever the datasource points at.
NickWhat you do is write a stored procedure for your sql need in third database
other than those two and write in a way that it can accept database name and
then fully qualify your object name and build a dynamic sql in the proc. Use
this proc in RS to buid one dataset and create another dataset with simple
query like "select dbname from sysdatabases where <criteira of your
interest>". Use this dataset as a input to the parameters of the first
database so the final report will have at least one parameter to pick a
database name from the dropdown list and you can run your report off of
selected database. I have implemented this way and I am running my report
off of more than two database from one server and it works great. Let me
know if you have any difficulties. email me.
Vipul Shah
"Nick Jacobs" wrote:
> I have two databases on the same SQL server which have identical data
> structures.
> I want to be able to use one set of reports on my report server to run
> against either database. How can I achieve this? Whenever I run the report
> it always runs against whatever the datasource points at.
> Nick
>
>