Report with a frame

Hi,
I need to put a frame around all my report include the page header. I
tried to use a list or a rectangle in the body of the report but I
couldn't write the page No. in the body part. On the other hand, I
couldn't put a rectangle that in includes the body and the header
parts.
Any ideas?
Thank you.
AviI haven't tried this, but can you set the Body border left,right properties,
then set the header and footer border properties to give the effect of a
report border or frame?
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1161471963.293489.166440@.b28g2000cwb.googlegroups.com...
> Hi,
> I need to put a frame around all my report include the page header. I
> tried to use a list or a rectangle in the body of the report but I
> couldn't write the page No. in the body part. On the other hand, I
> couldn't put a rectangle that in includes the body and the header
> parts.
> Any ideas?
> Thank you.
> Avi
>sql

report templates

We want all our reports to have the same header and footer, in crystal
reports we could make a template report... can something similar be done in
report services? Thanks!Sort of. You can create a style template for the creation of reports.
However, if you want to change it later you have to go to each report one by
one and modify it.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:%23q9LZBmNHHA.2140@.TK2MSFTNGP03.phx.gbl...
> We want all our reports to have the same header and footer, in crystal
> reports we could make a template report... can something similar be done
> in report services? Thanks!
>|||thanks!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ejuo$PmNHHA.4928@.TK2MSFTNGP06.phx.gbl...
> Sort of. You can create a style template for the creation of reports.
> However, if you want to change it later you have to go to each report one
> by one and modify it.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:%23q9LZBmNHHA.2140@.TK2MSFTNGP03.phx.gbl...
>> We want all our reports to have the same header and footer, in crystal
>> reports we could make a template report... can something similar be done
>> in report services? Thanks!
>|||Awesome, thanks!
"Reeves Smith" <ReevesSmith@.discussions.microsoft.com> wrote in message
news:1725398D-0098-4EC6-AF16-C1AADFC53241@.microsoft.com...
> Another Idea:
> Create a template RDL file and save it.
> Place the RDL file into the location:
> Drive:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
> Now when you click add a new item (from a reports project), it will be one
> the available selections.
> Reeves
> "Smokey Grindle" wrote:
>> We want all our reports to have the same header and footer, in crystal
>> reports we could make a template report... can something similar be done
>> in
>> report services? Thanks!
>>

Report Record Count in Header Section

Do anyone know how to do a count on the number of records in a data set and
display the information in the header section of the report? I can easily
perform this operation in the data section using the Count() method against
the data set, but RS does not allow datasets/fields to be referenced in the
header section. By required design, this record count textbox is above a
page count textbox (which must also be in the header since it's a global
variable), so I can't cheat by moving the field to the data section - it must
live in the header. Any help would be appreciated.
The only alternatives that I can think of are:
-Somehow reference a textbox that is using the Count() method in the data
section, and display the same text in the header section. (I have no idea
how I would do this.)
-Determine the record count and page count in SQL to move both fields to the
data section. I didn't want to do this because if the report layout changes,
the page count might not be correct.You can achieve this by using scope. Get the count of records for the table
level as follows:
In the header section add an expression as follows:
=Count(<field>, "<table name>")
Regards,
SaraS|||Unfortunately, you can't use Count() or CountRows() in headers or footers.
"saras" wrote:
> You can achieve this by using scope. Get the count of records for the table
> level as follows:
> In the header section add an expression as follows:
> =Count(<field>, "<table name>")
> Regards,
> SaraS
>|||Have you tried to use Report!Items.whatever.Value?
These fields are used in headers and footers. If you manage to get this data
in data section you can copy it to header section by
Report!Items.fieldname.Value.
"Bryan" wrote:
> Do anyone know how to do a count on the number of records in a data set and
> display the information in the header section of the report? I can easily
> perform this operation in the data section using the Count() method against
> the data set, but RS does not allow datasets/fields to be referenced in the
> header section. By required design, this record count textbox is above a
> page count textbox (which must also be in the header since it's a global
> variable), so I can't cheat by moving the field to the data section - it must
> live in the header. Any help would be appreciated.
> The only alternatives that I can think of are:
> -Somehow reference a textbox that is using the Count() method in the data
> section, and display the same text in the header section. (I have no idea
> how I would do this.)
> -Determine the record count and page count in SQL to move both fields to the
> data section. I didn't want to do this because if the report layout changes,
> the page count might not be correct.
>