Custom Report Header and footer

Hi,
We have very specific requirement for
Header and footer in which company logo
is there.But it can be changable like when
i change it for one plcae all the existing report's
header and footer should be changed.
How could i achieve this.Also Style for
header and footer should be same for all
the report.
Can i create Custom template for it ?
If yes than how ?
--
Thanks
Malkesh
--
Message posted via http://www.sqlmonster.comMalkesh, Is the header to be set at design time or run-time?
If at design time, create the various reports you want to use as
templates. Save them somewhere obvious (away from actual projects) with
obvious names, when you want to create a new report based on these
'templates' simply 'Add existing item' to your project navigate to the
'template' folder and use the appropriate template.
This actually copies it into the project without affecting the original.
If you are changing images at run time, you can specify the image to
use as an expression.
Regards
chris
Malkesh Sheth via SQLMonster.com wrote:
> Hi,
> We have very specific requirement for
> Header and footer in which company logo
> is there.But it can be changable like when
> i change it for one plcae all the existing report's
> header and footer should be changed.
> How could i achieve this.Also Style for
> header and footer should be same for all
> the report.
> Can i create Custom template for it ?
> If yes than how ?|||Thanks Chris,
Your Suggestion helped me.
Yes,I made templates for header and footer and
kept it in Reporting Service's template folder.
Now i can use it as my report templete.
But my main worry abt images. The req. is
that suppose we made no of reports using the
client logo. Now suppose client says to change their
logo then how can i change it , so that my all existing report's
logo should be changed at once.
What should be my stratagy to develope report using images ?
--
Thanks & Regards
Malkesh
"Chris McGuigan" wrote:
> Malkesh, Is the header to be set at design time or run-time?
> If at design time, create the various reports you want to use as
> templates. Save them somewhere obvious (away from actual projects) with
> obvious names, when you want to create a new report based on these
> 'templates' simply 'Add existing item' to your project navigate to the
> 'template' folder and use the appropriate template.
> This actually copies it into the project without affecting the original.
> If you are changing images at run time, you can specify the image to
> use as an expression.
> Regards
> chris
> Malkesh Sheth via SQLMonster.com wrote:
> > Hi,
> > We have very specific requirement for
> > Header and footer in which company logo
> > is there.But it can be changable like when
> > i change it for one plcae all the existing report's
> > header and footer should be changed.
> > How could i achieve this.Also Style for
> > header and footer should be same for all
> > the report.
> > Can i create Custom template for it ?
> > If yes than how ?
>|||Malkesh,
There are a couple of options but I think the simplest in your scenario
would be to use 'external' images in the report, called logo.jpg for
example, then merely overwriting the logo.jpg would change it
automatically in any report referencing it.
Be careful to make the external path absolute. Your developement
environment will need access to this path as well as the ReportServer.
You will also need to make sure that the account used to run the
ReportServer service has access rights to image files too.
You may also have to issue guidelines on the image size of any image
file to make sure it fits nicely into your report.
Hope that helps.
Chris
Malkesh wrote:
> Thanks Chris,
> Your Suggestion helped me.
> Yes,I made templates for header and footer and
> kept it in Reporting Service's template folder.
> Now i can use it as my report templete.
> But my main worry abt images. The req. is
> that suppose we made no of reports using the
> client logo. Now suppose client says to change their
> logo then how can i change it , so that my all existing report's
> logo should be changed at once.
> What should be my stratagy to develope report using images ?|||Thanks,
It works fine.
--
Thanks & Regards
Malkesh
"Chris McGuigan" wrote:
> Malkesh,
> There are a couple of options but I think the simplest in your scenario
> would be to use 'external' images in the report, called logo.jpg for
> example, then merely overwriting the logo.jpg would change it
> automatically in any report referencing it.
> Be careful to make the external path absolute. Your developement
> environment will need access to this path as well as the ReportServer.
> You will also need to make sure that the account used to run the
> ReportServer service has access rights to image files too.
> You may also have to issue guidelines on the image size of any image
> file to make sure it fits nicely into your report.
> Hope that helps.
> Chris
>
> Malkesh wrote:
> > Thanks Chris,
> > Your Suggestion helped me.
> > Yes,I made templates for header and footer and
> > kept it in Reporting Service's template folder.
> > Now i can use it as my report templete.
> > But my main worry abt images. The req. is
> > that suppose we made no of reports using the
> > client logo. Now suppose client says to change their
> > logo then how can i change it , so that my all existing report's
> > logo should be changed at once.
> > What should be my stratagy to develope report using images ?
>|||Malkesh - Can you please advice where I can find Reporting Service's template
folder. Is that a custom folder you have created in your project ? BTW do you
work in the US or India.
Thanks,
Kiran
"Malkesh" wrote:
> Thanks Chris,
> Your Suggestion helped me.
> Yes,I made templates for header and footer and
> kept it in Reporting Service's template folder.
> Now i can use it as my report templete.
> But my main worry abt images. The req. is
> that suppose we made no of reports using the
> client logo. Now suppose client says to change their
> logo then how can i change it , so that my all existing report's
> logo should be changed at once.
> What should be my stratagy to develope report using images ?
> --
> Thanks & Regards
> Malkesh
>
> "Chris McGuigan" wrote:
> > Malkesh, Is the header to be set at design time or run-time?
> >
> > If at design time, create the various reports you want to use as
> > templates. Save them somewhere obvious (away from actual projects) with
> > obvious names, when you want to create a new report based on these
> > 'templates' simply 'Add existing item' to your project navigate to the
> > 'template' folder and use the appropriate template.
> > This actually copies it into the project without affecting the original.
> >
> > If you are changing images at run time, you can specify the image to
> > use as an expression.
> >
> > Regards
> > chris
> >
> > Malkesh Sheth via SQLMonster.com wrote:
> >
> > > Hi,
> > > We have very specific requirement for
> > > Header and footer in which company logo
> > > is there.But it can be changable like when
> > > i change it for one plcae all the existing report's
> > > header and footer should be changed.
> > > How could i achieve this.Also Style for
> > > header and footer should be same for all
> > > the report.
> > > Can i create Custom template for it ?
> > > If yes than how ?
> >
> >|||Kiran,
I think the folder below is the location for templates;
C:\Program Files\Microsoft SQL Server\80\Tools\Report
Designer\ProjectItems\ReportProject
Chris
Kiran wrote:
> Malkesh - Can you please advice where I can find Reporting Service's
> template folder. Is that a custom folder you have created in your
> project ? BTW do you work in the US or India.
> Thanks,
> Kiran
> "Malkesh" wrote:
> > Thanks Chris,
> > Your Suggestion helped me.
> > Yes,I made templates for header and footer and
> > kept it in Reporting Service's template folder.
> > Now i can use it as my report templete.
> > But my main worry abt images. The req. is
> > that suppose we made no of reports using the
> > client logo. Now suppose client says to change their
> > logo then how can i change it , so that my all existing report's
> > logo should be changed at once.
> > What should be my stratagy to develope report using images ?
> > --
> > Thanks & Regards
> > Malkesh
> >
> >
> > "Chris McGuigan" wrote:
> >
> > > Malkesh, Is the header to be set at design time or run-time?
> > >
> > > If at design time, create the various reports you want to use as
> > > templates. Save them somewhere obvious (away from actual
> > > projects) with obvious names, when you want to create a new
> > > report based on these 'templates' simply 'Add existing item' to
> > > your project navigate to the 'template' folder and use the
> > > appropriate template. This actually copies it into the project
> > > without affecting the original.
> > >
> > > If you are changing images at run time, you can specify the image
> > > to use as an expression.
> > >
> > > Regards
> > > chris
> > >
> > > Malkesh Sheth via SQLMonster.com wrote:
> > >
> > > > Hi,
> > > > We have very specific requirement for
> > > > Header and footer in which company logo
> > > > is there.But it can be changable like when
> > > > i change it for one plcae all the existing report's
> > > > header and footer should be changed.
> > > > How could i achieve this.Also Style for
> > > > header and footer should be same for all
> > > > the report.
> > > > Can i create Custom template for it ?
> > > > If yes than how ?
> > >
> > >