Report Designer: REPORT(!) templates?

Hi,
I found STYLE templates for the appearance of tables and matrices, but I
want to retain my header and margins and grid spacing and possibly some
common Datasets and references to assemblies when creating a new report with
REPORT Designer.
I want to create a new Report against an OLAP Cube with the report designer.
So I can get all the necessary datasets for cascading parameters. But then
all my above mentioned settings are lost.
Any ideas?
Many thanks in advance,
RalphYou can make a general report, with a page header and footer and datasets
for parameters you will use in many reports. Create it's own project so you
don't mess it up. Then you save it in either
For SQL Server 2000
C:\Program Files\Microsoft SQL Server\80\Tools\ Report
Designer\ProjectItems\ReportProject
or
For SQL Server 2005
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
Give it an easily recognizable name, like <clientname>_template.rdl.
Then create a new project for the different reports. Create a Shared Data
Source named the same as in you template. RIght click on the Reports folder,
choose Add new item and choose your newly created template from the list of
templates.
You can also save your Shared Data Sources, and just add them to new
projects later.
Kaisa
"Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
news:e$pQ$wd8FHA.1276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I found STYLE templates for the appearance of tables and matrices, but I
> want to retain my header and margins and grid spacing and possibly some
> common Datasets and references to assemblies when creating a new report
> with REPORT Designer.
> I want to create a new Report against an OLAP Cube with the report
> designer. So I can get all the necessary datasets for cascading
> parameters. But then all my above mentioned settings are lost.
> Any ideas?
> Many thanks in advance,
> Ralph
>|||Many thanks for yor answer, but my problem with RS 2005 is a bit more
complex:
I want to use the Report Designer to get those complex MDX-Statements for
the main dataset and the cascading parameters (sometimes ~ 15 datasets) so I
can't add the report-template in the way you suggested, or do I miss
something?
The best solution I found so far is to put at least the header and
report-layout and so on into the mini-template of the Report-Designer. But
if i put my datasets there to, then I end up with two <Datasets /> in XML
what lead of course to an error. Same thing with common parameters. So there
is LOTS OF "intelligent" copy and paste to do with a lot of possible
mistakes... Really no fun...
So to summarize: I just have to decide wether I want to retain parameters
and datasets or get MDX/cascading parameters the easy way?... Really
tedius work..!'
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> schrieb im Newsbeitrag
news:updxECF9FHA.1248@.TK2MSFTNGP14.phx.gbl...
> You can make a general report, with a page header and footer and datasets
> for parameters you will use in many reports. Create it's own project so
> you don't mess it up. Then you save it in either
> For SQL Server 2000
> C:\Program Files\Microsoft SQL Server\80\Tools\ Report
> Designer\ProjectItems\ReportProject
> or
> For SQL Server 2005
> C:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
> Give it an easily recognizable name, like <clientname>_template.rdl.
> Then create a new project for the different reports. Create a Shared Data
> Source named the same as in you template. RIght click on the Reports
> folder, choose Add new item and choose your newly created template from
> the list of templates.
> You can also save your Shared Data Sources, and just add them to new
> projects later.
> Kaisa
> "Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
> news:e$pQ$wd8FHA.1276@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> I found STYLE templates for the appearance of tables and matrices, but I
>> want to retain my header and margins and grid spacing and possibly some
>> common Datasets and references to assemblies when creating a new report
>> with REPORT Designer.
>> I want to create a new Report against an OLAP Cube with the report
>> designer. So I can get all the necessary datasets for cascading
>> parameters. But then all my above mentioned settings are lost.
>> Any ideas?
>> Many thanks in advance,
>> Ralph
>>
>

Report Design Question two horizontal column headers one below other

I have a report requirement, i am new to reports.

I want to have two lines of column headers.( with 7 columns in parent columns header)

and 7 columns in child column header.

The first column header will show a parent record.

And after the parent record i want to show the next child related horizontal column headers and will show all child record related to the above parent record.

its a one to many: 1 parent record and below all child records for that parent record.

can i use subreports controls to show all child records of the parent.

Thank you very much for the information.

I would recommend that you a table report

Assume that you have a structure

Country A

Region A1

Region A2

Country B

Region B1

Region B2

Region B3

In this scenario create a table that groups records by country. In the group header/footer (depending on your need) add a new table that contains regions associated with the country.

HTH.

Report design Issues.

Hi All,
Please let me know of this problem.
Can I have a static row in a matrix'
The design of the report should be like this
Matrix Header
Totals : Static Header
Row1
Row2
Row3
Labor : Static Header
Row4
Row5
Row6
The number of rows in each section is the same (only three)..
I have been breaking my head to get the design right...
Any help please....
Thanks in Advance.....I have an example of a Matrix report with Static columns on
www.msbicentral.com
register, then go to downloads, Reporting Services, RDL and search for
Static... The file is Matrix.StaticColumns.RDL
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CCP" <CCP@.discussions.microsoft.com> wrote in message
news:636BC8E1-D49A-4130-A393-FC132812593D@.microsoft.com...
> Hi All,
> Please let me know of this problem.
> Can I have a static row in a matrix'
> The design of the report should be like this
> Matrix Header
> Totals : Static Header
> Row1
> Row2
> Row3
> Labor : Static Header
> Row4
> Row5
> Row6
>
> The number of rows in each section is the same (only three)..
> I have been breaking my head to get the design right...
> Any help please....
> Thanks in Advance.....
>
>

Report Design & Layout

Hi Everybody, i have been having problems in design & layout of the following report .
i need the report layout as follows a
-
HP- FIELDS IN HEADER OF PAGE -REPEATED IN EVERY PAGE.
HR- FIELDS IN HEADER OF REPORT-ONLY ONCE ON 1st PAGE OF REPORT.

i have created a table report in the body of the report as follows.

HP - In Page Header, i have placed some text and page no
HR - In Table Header, i have placed some text & fields.
HP - In Group Header 1, i have some text & fields. & RepeatOnNewPage = true
HR - IN GROUP HEADER 1, text & fields, which i want to repeat on only 1st page.
(this is were i am having problems to set the group header for the table to
to repeat only on 1st page)
HP - In Group Header 1, some text & fields
DETAIL- some fields.

I would really appreciate your help, or any changes in design & layout of the report.

Thanks A lot IN ADVANCE
Sud

As I understand your issue, you have three rows in Group Header 1, the first row you want to repeat on every page, the second row you only want it to show on the 1st page, is this correct?

You can try creating two groups with the same group expressions. Put the first row in the first group and mark it RepeatOnNewPage. Put the second row in the second group and don't repeat it.

Report Deployment Error:

Hi while deploying the reports to the server I get the following error.
Server did not recognize the value of HTTP Header SOAPAction:
http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
Could anyone help me to overcome this?
Please mention if any configuration changes are to be made.
Thanks.Looks like a version mismatch between your client (VS.NET) and your
server... open http://<servername>/reportserver and in VS.NET open Help |
About Microsoft Development Environment and select "Microsoft SQL Server
Report Designer"... compare the version numbers
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"Thyagu" <Thyagu@.discussions.microsoft.com> wrote in message
news:A10C3285-CAB6-4A19-93A3-6DD7365F49B7@.microsoft.com...
> Hi while deploying the reports to the server I get the following error.
> Server did not recognize the value of HTTP Header SOAPAction:
> http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
> Could anyone help me to overcome this?
> Please mention if any configuration changes are to be made.
> Thanks.|||Douglas,
Thanks very much. The problem got solved once I upgraded the package to a
newer version.
Regards,
Thyagu
"Douglas McDowell" wrote:
> Looks like a version mismatch between your client (VS.NET) and your
> server... open http://<servername>/reportserver and in VS.NET open Help |
> About Microsoft Development Environment and select "Microsoft SQL Server
> Report Designer"... compare the version numbers
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "Thyagu" <Thyagu@.discussions.microsoft.com> wrote in message
> news:A10C3285-CAB6-4A19-93A3-6DD7365F49B7@.microsoft.com...
> > Hi while deploying the reports to the server I get the following error.
> >
> > Server did not recognize the value of HTTP Header SOAPAction:
> > http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
> >
> > Could anyone help me to overcome this?
> > Please mention if any configuration changes are to be made.
> >
> > Thanks.
>
>

Report Common Header

I have 70 reports which all have company logo. If the name of logo is
changed, I have to modify this 70 times and upload to report server 70 times.
Do you have any suggestion that can minimize those tedious work load ?
Can report service allow to include HTML file which can be located in local
drive of report server (e.g. d:\Company Name\Company Logo.html) or the HTML
file is locate in Reporting Manager Folder ?I would assume that the company logo is an image. You can use several types
of external images:
* "Project" images. These are image resources that get published to a report
server and are referenced by relative paths in the reports. See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_1qcl.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
* "Database" images. The images are stored in a database.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_5ktv.asp
* External images on web servers or network shares.
Please check the related information in the RS 2000 SP1 Readme file:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:D8C67C57-0F15-4D4E-BF50-5C6E6123BA11@.microsoft.com...
> I have 70 reports which all have company logo. If the name of logo is
> changed, I have to modify this 70 times and upload to report server 70
times.
> Do you have any suggestion that can minimize those tedious work load ?
> Can report service allow to include HTML file which can be located in
local
> drive of report server (e.g. d:\Company Name\Company Logo.html) or the
HTML
> file is locate in Reporting Manager Folder ?|||I can't enter the image's relative path e.g. /Reports/images/CompanyLogo.gif.
An error 'The URL is not valid' is shown. But if I enter
http://localhost/Reports/images/CompanyLogo.gif, it's ok. Can I just input
the relative path instead of the exact url ? As the name of web server
will be changed, the same problem is still exist that I need to modify 70
times and upload to report server 70 times.
Thanks a lot !!!
"Robert Bruckner [MSFT]" wrote:
> I would assume that the company logo is an image. You can use several types
> of external images:
> * "Project" images. These are image resources that get published to a report
> server and are referenced by relative paths in the reports. See also:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_1qcl.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> * "Database" images. The images are stored in a database.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_5ktv.asp
> * External images on web servers or network shares.
> Please check the related information in the RS 2000 SP1 Readme file:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:D8C67C57-0F15-4D4E-BF50-5C6E6123BA11@.microsoft.com...
> > I have 70 reports which all have company logo. If the name of logo is
> > changed, I have to modify this 70 times and upload to report server 70
> times.
> > Do you have any suggestion that can minimize those tedious work load ?
> > Can report service allow to include HTML file which can be located in
> local
> > drive of report server (e.g. d:\Company Name\Company Logo.html) or the
> HTML
> > file is locate in Reporting Manager Folder ?
>
>|||The correct relative path of the image should be (don't specify "Reports" in
the path):
/images/CompanyLogo.gif
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:28EAA57D-0F1B-4602-AA43-43D0129B5656@.microsoft.com...
> I can't enter the image's relative path e.g.
/Reports/images/CompanyLogo.gif.
> An error 'The URL is not valid' is shown. But if I enter
> http://localhost/Reports/images/CompanyLogo.gif, it's ok. Can I just
input
> the relative path instead of the exact url ? As the name of web server
> will be changed, the same problem is still exist that I need to modify 70
> times and upload to report server 70 times.
> Thanks a lot !!!
> "Robert Bruckner [MSFT]" wrote:
> > I would assume that the company logo is an image. You can use several
types
> > of external images:
> > * "Project" images. These are image resources that get published to a
report
> > server and are referenced by relative paths in the reports. See also:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_1qcl.asp
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> >
> > * "Database" images. The images are stored in a database.
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_5ktv.asp
> >
> > * External images on web servers or network shares.
> > Please check the related information in the RS 2000 SP1 Readme file:
> >
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> > news:D8C67C57-0F15-4D4E-BF50-5C6E6123BA11@.microsoft.com...
> > > I have 70 reports which all have company logo. If the name of logo is
> > > changed, I have to modify this 70 times and upload to report server 70
> > times.
> > > Do you have any suggestion that can minimize those tedious work load
?
> > > Can report service allow to include HTML file which can be located in
> > local
> > > drive of report server (e.g. d:\Company Name\Company Logo.html) or the
> > HTML
> > > file is locate in Reporting Manager Folder ?
> >
> >
> >

Report Builder: Is there a way to have a repeating page header and page footer?

Dear Anyone,

Is there a way to have a repeating page header and page footer in report builder? I know this is possible with Reporting Services but I cant seem to find any info regarding this Report Builder? Can anyone shed a light in this?
Thanks,
JosephPage headers/footers are not supported in RB in this release. You can add them to an RB report by opening it in Report Designer and modifying the layout there.

Report Builder page header

SSRS 2005. When I create a report in Report Builder from a model, I can add a
title to the report, but it doesn't repeat on subsequent pages. How can I get
it (or something) to repeat at the top of every page?
Thanks
VernI have the exact same question. If anyone could point me in the direction of
the answer in this newsgroup it would be greatly appreciated.
"Vern Rabe" wrote:
> SSRS 2005. When I create a report in Report Builder from a model, I can add a
> title to the report, but it doesn't repeat on subsequent pages. How can I get
> it (or something) to repeat at the top of every page?
> Thanks
> Vern

Report

Hi is it possible to have a header and footer text on every page generated in an aspx report (rsdl)?
I tried to put it in a textbox, but then the table containing the report data is displayed on top of it so that doesn't work... Any ideas?

Cheers, mc

I think you can set it in the properties window "repeat in every page" = true/false.