Is it possible to modify Report Builder template ?

Hi

I would like to be able to modify the basic report template offered by Report Builder , so as to be able to include custom fields that I would like to be present in every report (Company name , Logo , Date , etc) to achieve consistency in the presentation of the reports created with Report Builder

In Bob's Blog he explained how to include RDL expressions in Report Builder
http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx

What I would like to do is to use that technique (if possible) to modify the original template or templates offered by Report Builder to include my own fields.

============================================

I will appreciate some comments or suggestions about other approaches that can be used to address the issue mentioned in the first paragraph .

Thanks in advance ,

George

Just create a report as a template, with all your controls on it, and copy the rdl to this directory:

RS 2005:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

It will show up in your add new item window. I named my report templates Portrait.rdl and Landscape.rdl with the margins set in each. plus i added a table and changed the cell padding and fonts.

For 2000, I think the location is in \program files\sql server... But i can't remember where. You could search your PC for *.rdl

Anyway, there is a file called report.rdl; that is the default one from MS. One caveat, you will have to do this on every machine as the template is on your local PC.

|||Hi Steve ,

Thank you for your answer . I am refering to the Report Builder (ad-hoc reporting tool), not the Report Designer of Visual Studio .

Have you managed to do something similar with the Report Builder Tool ?

Regards ,

George
|||

My mistake. I have never used the report builder. here are a couple of threads I found, and it doesn't look to promising:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303097&SiteID=1

and here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=285749&SiteID=1

|||I see what you mean . Thank you very much for your help

George
|||

Hi,

I am truying to acheive the same. Please let me know if you found the solution.

Regards,

Prakash

|||

Hi
At moment support for templates, styles, and images are not available with report builder. For more information please see: http://www.microsoft.com/sql/technologies/reporting/faq.mspx, http://msdn2.microsoft.com/en-gb/library/aa964121.aspx (Understanding the Product Limitations)

The workaround for this is to have a report (just format) that will be served as template. User will required to open this report (template) then after making the required changes they make copy of the same by doing "Save As" instead of "Save"

Please let me know if you need some more information in this regard.

Regards;
Rakesh

Is it possible to modify Report Builder template ?

Hi

I would like to be able to modify the basic report template offered by Report Builder , so as to be able to include custom fields that I would like to be present in every report (Company name , Logo , Date , etc) to achieve consistency in the presentation of the reports created with Report Builder

In Bob's Blog he explained how to include RDL expressions in Report Builder
http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx

What I would like to do is to use that technique (if possible) to modify the original template or templates offered by Report Builder to include my own fields.

============================================

I will appreciate some comments or suggestions about other approaches that can be used to address the issue mentioned in the first paragraph .

Thanks in advance ,

George

Just create a report as a template, with all your controls on it, and copy the rdl to this directory:

RS 2005:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

It will show up in your add new item window. I named my report templates Portrait.rdl and Landscape.rdl with the margins set in each. plus i added a table and changed the cell padding and fonts.

For 2000, I think the location is in \program files\sql server... But i can't remember where. You could search your PC for *.rdl

Anyway, there is a file called report.rdl; that is the default one from MS. One caveat, you will have to do this on every machine as the template is on your local PC.

|||Hi Steve ,

Thank you for your answer . I am refering to the Report Builder (ad-hoc reporting tool), not the Report Designer of Visual Studio .

Have you managed to do something similar with the Report Builder Tool ?

Regards ,

George|||

My mistake. I have never used the report builder. here are a couple of threads I found, and it doesn't look to promising:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303097&SiteID=1

and here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=285749&SiteID=1

|||I see what you mean . Thank you very much for your help

George|||

Hi,

I am truying to acheive the same. Please let me know if you found the solution.

Regards,

Prakash

|||

Hi
At moment support for templates, styles, and images are not available with report builder. For more information please see: http://www.microsoft.com/sql/technologies/reporting/faq.mspx, http://msdn2.microsoft.com/en-gb/library/aa964121.aspx (Understanding the Product Limitations)

The workaround for this is to have a report (just format) that will be served as template. User will required to open this report (template) then after making the required changes they make copy of the same by doing "Save As" instead of "Save"

Please let me know if you need some more information in this regard.

Regards;
Rakesh

Is it possible to modify Report Builder template ?

Hi

I would like to be able to modify the basic report template offered by Report Builder , so as to be able to include custom fields that I would like to be present in every report (Company name , Logo , Date , etc) to achieve consistency in the presentation of the reports created with Report Builder

In Bob's Blog he explained how to include RDL expressions in Report Builder
http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx

What I would like to do is to use that technique (if possible) to modify the original template or templates offered by Report Builder to include my own fields.

============================================

I will appreciate some comments or suggestions about other approaches that can be used to address the issue mentioned in the first paragraph .

Thanks in advance ,

George

Just create a report as a template, with all your controls on it, and copy the rdl to this directory:

RS 2005:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

It will show up in your add new item window. I named my report templates Portrait.rdl and Landscape.rdl with the margins set in each. plus i added a table and changed the cell padding and fonts.

For 2000, I think the location is in \program files\sql server... But i can't remember where. You could search your PC for *.rdl

Anyway, there is a file called report.rdl; that is the default one from MS. One caveat, you will have to do this on every machine as the template is on your local PC.

|||Hi Steve ,

Thank you for your answer . I am refering to the Report Builder (ad-hoc reporting tool), not the Report Designer of Visual Studio .

Have you managed to do something similar with the Report Builder Tool ?

Regards ,

George|||

My mistake. I have never used the report builder. here are a couple of threads I found, and it doesn't look to promising:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303097&SiteID=1

and here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=285749&SiteID=1

|||I see what you mean . Thank you very much for your help

George|||

Hi,

I am truying to acheive the same. Please let me know if you found the solution.

Regards,

Prakash

|||

Hi
At moment support for templates, styles, and images are not available with report builder. For more information please see: http://www.microsoft.com/sql/technologies/reporting/faq.mspx, http://msdn2.microsoft.com/en-gb/library/aa964121.aspx (Understanding the Product Limitations)

The workaround for this is to have a report (just format) that will be served as template. User will required to open this report (template) then after making the required changes they make copy of the same by doing "Save As" instead of "Save"

Please let me know if you need some more information in this regard.

Regards;
Rakesh

Is it possible to enable TCP/IP connection to SQL Server programmatically? Is there any function

Anyone know? I'm making an installation package and I want my installation program (which is a custom action class inherited from Installer Class) to adjust the network configuration of SQL Server, for example enable TCP/IP. What can I do? Is that any function in SMO package that can do this for me?Hi,

that is a registry setting, you have to switch the appropiate network protocol values in this section to get it working:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Is it possible to enable TCP/IP connection to SQL Server programmatically? Is there any func

Anyone know? I'm making an installation package and I want my installation program (which is a custom action class inherited from Installer Class) to adjust the network configuration of SQL Server, for example enable TCP/IP. What can I do? Is that any function in SMO package that can do this for me?Hi,

that is a registry setting, you have to switch the appropiate network protocol values in this section to get it working:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

HTH, Jens Suessmeyer.

http://www.sqlserver2005.desql

is it possible to do a redirect in the custom code?

Is it possible to do a redirect to an arbitrary page in by using custom code?

eg.

Public sub myRedirect()

response.redirect(http://www.microsoft.com)

End sub

/Alex

Or automatically open a new webpage when viewing the report?

Is it possible to custom format the parameter dropdownlist?

I have a reporting services 2000 report that has only one string report
parameter with a prompt 'Select a Project'. The project list contains
project names that are so long that they take up about 95% of the page
width and the View report button becomes a partially visible button
with a horizontal scroll bar to scroll further to the right to view the
entire page.
My users hate to have to scroll to the right. They are requesting a
fixed width dropdownlist with fully visible 'View report' button.
We want to make our DDL pretty narrow so that it only shows the first n
characters of the project name string when the DDL is not dropped down.
When the user
drops the list down we want to resize it wide enough to show the entire
string.
We could also assign a tool tip to the DDL if we could supply a unique
tip
to each row in the DDL?
Any ideas? Does SSRS 2005 let the designer specify the parameter
control width?
Many thanks in advance.I've found that the parameter panel is not at all configurable and have
been creating a front-end web page for each report giving me total
control over presentation. Then I hide the parameter panel via a
parameter on the URL. It's my understanding RS 2005 has more control
over the parameter panel.|||Many thanks, Kent.

Is it possible to create a custom SQL session function/variable

To avoid having to pass this user specific ID via a parameter in the stored
procedure, is it possible to create your own function like (like
suser_sid()) or variable (like @.@.SPID) ?
This value would be passed from a Web Service (asp.net 2.0) in the
connection string or something and could be referred to anywhere in the SQL
code (SQL 2005).
Has anyone got a better solution than a SP parameter ?Take a look at CONTEXT_INFO in the Books Online. This allows you to store
up to 128 bytes of binary info that can be used anywhere in the session.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:uI04I9duHHA.4440@.TK2MSFTNGP06.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>

Is it possible to create a custom SQL session function/variable

To avoid having to pass this user specific ID via a parameter in the stored
procedure, is it possible to create your own function like (like
suser_sid()) or variable (like @.@.SPID) ?
This value would be passed from a Web Service (asp.net 2.0) in the
connection string or something and could be referred to anywhere in the SQL
code (SQL 2005).
Has anyone got a better solution than a SP parameter ?Take a look at CONTEXT_INFO in the Books Online. This allows you to store
up to 128 bytes of binary info that can be used anywhere in the session.
Hope this helps.
Dan Guzman
SQL Server MVP
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:uI04I9duHHA.4440@.TK2MSFTNGP06.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>sql

Is it possible to create a custom SQL session function/variable

To avoid having to pass this user specific ID via a parameter in the stored
procedure, is it possible to create your own function like (like
suser_sid()) or variable (like @.@.SPID) ?
This value would be passed from a Web Service (asp.net 2.0) in the
connection string or something and could be referred to anywhere in the SQL
code (SQL 2005).
Has anyone got a better solution than a SP parameter ?Asked and answered in .programming. Please refrain from multiposting.
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:%23cNc2ceuHHA.3376@.TK2MSFTNGP04.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>|||Take a look at SET CONTEXT_INFO in the Books Online. That allows you to set
a value for the connection that is accessible anywhere in the session with
the CONTEXT_INFO function. Since the value is binary, you'll need to
convert as needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:%23cNc2ceuHHA.3376@.TK2MSFTNGP04.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>

Is Forms Authentication available on Standard

I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is there any way to custom authenticate a user when using URL calls that is not windows Authentication?I have found the answer which is simply no. Back to Crystal Reports then. Good luck getting this off the ground when you have to buy Enterprise Edition just to securely provide reports over the web that have some kind of functionality.
"Ryan Smith" wrote:
> I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is there any way to custom authenticate a user when using URL calls that is not windows Authentication?|||Web services does not support everything as it only provides a snapshot of
the report and does not have drill down functionality. If you have a report
that has drill downs (95% of my reports) in it and you run a webservice for
it, when the user clicks on the drill down they get an error.
"Richard" wrote:
> You can still build your own web app (report manager) and use the web service
> to communitate with it. I have gone over the api for the ws and it supports
> everyting you need. Yes it's a bit of work up front but there are no
> licensing issues at all
> "Ryan Smith" wrote:
> > I have found the answer which is simply no. Back to Crystal Reports then. Good luck getting this off the ground when you have to buy Enterprise Edition just to securely provide reports over the web that have some kind of functionality.
> >
> > "Ryan Smith" wrote:
> >
> > > I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is there any way to custom authenticate a user when using URL calls that is not windows Authentication?