Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2009-10-08 : 08:45:47
|
| Hi all,I am new to SSRS. I like it! For the last few weeks, I have been creating some new reports. Most of my reports all have the same header info like company name, page number, date / time, etc. I spend a lot of time recreating this info. Is there a way I can create a template or shell report that I can bring in each time I set-uo a new report?Thanks in advance!Bob |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-08 : 10:03:27
|
| Definitely. First, create a template report with the reusable objects like headers, footers, text boxes with report names globals, page x of y, etc... Select each text box, rectangle, whatever object you created on the template and change the name. VERY Important. You do not want any objects to have the default names like TextBox2, Rectangle1 because when you go to use the template, the designer assumes empty. Once you have designed it to your liking, save to the proper folder for templates. I only use the SQL Server BI Dev studio but I suspect you can find it. Mine is located at:C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProjectJohn |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-08 : 10:12:04
|
Yes!You can create a new report that has all the things you want in your template.Then store this as your_template_name.rdl in:C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-08 : 10:13:00
|
 edit: It took me too long to find that folder in my C:-drive again...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
bh0526
Yak Posting Veteran
71 Posts |
Posted - 2009-10-08 : 10:27:30
|
| Thanks everyone! That did it. It worked like a charm!! You guys are great!Bob |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-08 : 10:32:08
|
quote:
Originally posted by webfred
Yes!You can create a new report that has all the things you want in your template.Then store this as your_template_name.rdl in:C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
No, you're never too old to Yak'n'Roll if you're too young to die.
I would normally say it is because of age... but I am older by 1 year  John |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-08 : 12:05:07
|
Then it maybe because I am already a Grandpa?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
|
|
Can I create a report template?