Are the style templates offered by the Report Wizard accessible somewhere? Can I add my own standard templates (beyond the bold, casual, corporate, etc.)?
Thanks,
Warren ThornthwaiteStyle definitions be found in %Program Files%\Microsoft SQL
Server\80\Tools\Report Designer\Business Intelligence
Wizards\Reports\Styles\<Language> folders.
You can add your own style and it should be picked by report wizard.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"_WT_" <WT@.discussions.microsoft.com> wrote in message
news:13C29E40-8EB8-437D-8374-3F5B94C2C1F9@.microsoft.com...
> Are the style templates offered by the Report Wizard accessible somewhere?
> Can I add my own standard templates (beyond the bold, casual, corporate,
> etc.)?
> Thanks,
> Warren Thornthwaitesql
Showing posts with label templates. Show all posts
Showing posts with label templates. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
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!
>>
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!
>>
Tuesday, March 20, 2012
Report Template
Can you create Generic Report Templates with Reporting Services? My problem
is I need to create report templates that will be influenced by external
data. A report template would be generic and the external data would
influence the data to display. There would be some logic involved to
retrieve certain information. For example, can the text for a textbox be
setup generically with an expression or could I pass specifc information to a
query to pull the right text. For example, lets say I have a word that is
stored in the database in 5 languages. I want to pass the query an indicator
to pull the correct text for the language. Is that possible?
Also, can a graph be setup in a generic way? For example, can I pass the
plot values to a graph in a report template? Can I setup the X and Y axis
values to dynamically retrieve information for each value? Can each axis
value be a separate sql statement or can each individual axis be built with
seperate statements.
Thanks - mc>For example, lets say I have a word that is
> stored in the database in 5 languages. I want to pass the query an
> indicator
> to pull the correct text for the language. Is that possible?
Sure, you can set up a report parameter and pass its value to your report
query.
> Also, can a graph be setup in a generic way? For example, can I pass the
> plot values to a graph in a report template? Can I setup the X and Y axis
> values to dynamically retrieve information for each value? Can each axis
> value be a separate sql statement or can each individual axis be built
> with
> seperate statements.
Nope, the chart region can be bound to one dataset only. Max values of X
and Y axis are defined at design time. Sounds like the best option for you
is to pre-process the report definition. In this respect, you can view your
report as the ultimate template. If you need to tweak things, you change the
report definition, upload and render the report.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"mc" <mc@.discussions.microsoft.com> wrote in message
news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
> Can you create Generic Report Templates with Reporting Services? My
> problem
> is I need to create report templates that will be influenced by external
> data. A report template would be generic and the external data would
> influence the data to display. There would be some logic involved to
> retrieve certain information. For example, can the text for a textbox be
> setup generically with an expression or could I pass specifc information
> to a
> query to pull the right text. For example, lets say I have a word that is
> stored in the database in 5 languages. I want to pass the query an
> indicator
> to pull the correct text for the language. Is that possible?
> Also, can a graph be setup in a generic way? For example, can I pass the
> plot values to a graph in a report template? Can I setup the X and Y axis
> values to dynamically retrieve information for each value? Can each axis
> value be a separate sql statement or can each individual axis be built
> with
> seperate statements.
>
> Thanks - mc|||What do you mean by pre process the report the report definition? Do you
mean to programmatically find each graph in the report RDL and substitute the
data I need for each graph and then send it for rendering?
Also, when you say max values of X and Y are defined at design time, do you
mean the plot values for lets say a line graph?
Thanks
"Teo Lachev [MVP]" wrote:
> >For example, lets say I have a word that is
> > stored in the database in 5 languages. I want to pass the query an
> > indicator
> > to pull the correct text for the language. Is that possible?
> Sure, you can set up a report parameter and pass its value to your report
> query.
> > Also, can a graph be setup in a generic way? For example, can I pass the
> > plot values to a graph in a report template? Can I setup the X and Y axis
> > values to dynamically retrieve information for each value? Can each axis
> > value be a separate sql statement or can each individual axis be built
> > with
> > seperate statements.
> Nope, the chart region can be bound to one dataset only. Max values of X
> and Y axis are defined at design time. Sounds like the best option for you
> is to pre-process the report definition. In this respect, you can view your
> report as the ultimate template. If you need to tweak things, you change the
> report definition, upload and render the report.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
> > Can you create Generic Report Templates with Reporting Services? My
> > problem
> > is I need to create report templates that will be influenced by external
> > data. A report template would be generic and the external data would
> > influence the data to display. There would be some logic involved to
> > retrieve certain information. For example, can the text for a textbox be
> > setup generically with an expression or could I pass specifc information
> > to a
> > query to pull the right text. For example, lets say I have a word that is
> > stored in the database in 5 languages. I want to pass the query an
> > indicator
> > to pull the correct text for the language. Is that possible?
> >
> > Also, can a graph be setup in a generic way? For example, can I pass the
> > plot values to a graph in a report template? Can I setup the X and Y axis
> > values to dynamically retrieve information for each value? Can each axis
> > value be a separate sql statement or can each individual axis be built
> > with
> > seperate statements.
> >
> >
> > Thanks - mc
>
>|||Yes, I ment programatically changind the report definition.
> Also, when you say max values of X and Y are defined at design time, do
> you
> mean the plot values for lets say a line graph?
Whatever properties are not expression-based. If you expand a property and
don't see the Expression item, this property cannot be controlled duruing
runtime. Your only option is to pre-process the report definition.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"mc" <mc@.discussions.microsoft.com> wrote in message
news:79546631-3B40-4BB1-B31C-BFD28B77DCBC@.microsoft.com...
> What do you mean by pre process the report the report definition? Do you
> mean to programmatically find each graph in the report RDL and substitute
> the
> data I need for each graph and then send it for rendering?
> Also, when you say max values of X and Y are defined at design time, do
> you
> mean the plot values for lets say a line graph?
> Thanks
>
> "Teo Lachev [MVP]" wrote:
>> >For example, lets say I have a word that is
>> > stored in the database in 5 languages. I want to pass the query an
>> > indicator
>> > to pull the correct text for the language. Is that possible?
>> Sure, you can set up a report parameter and pass its value to your report
>> query.
>> > Also, can a graph be setup in a generic way? For example, can I pass
>> > the
>> > plot values to a graph in a report template? Can I setup the X and Y
>> > axis
>> > values to dynamically retrieve information for each value? Can each
>> > axis
>> > value be a separate sql statement or can each individual axis be built
>> > with
>> > seperate statements.
>> Nope, the chart region can be bound to one dataset only. Max values of X
>> and Y axis are defined at design time. Sounds like the best option for
>> you
>> is to pre-process the report definition. In this respect, you can view
>> your
>> report as the ultimate template. If you need to tweak things, you change
>> the
>> report definition, upload and render the report.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
>> > Can you create Generic Report Templates with Reporting Services? My
>> > problem
>> > is I need to create report templates that will be influenced by
>> > external
>> > data. A report template would be generic and the external data would
>> > influence the data to display. There would be some logic involved to
>> > retrieve certain information. For example, can the text for a textbox
>> > be
>> > setup generically with an expression or could I pass specifc
>> > information
>> > to a
>> > query to pull the right text. For example, lets say I have a word that
>> > is
>> > stored in the database in 5 languages. I want to pass the query an
>> > indicator
>> > to pull the correct text for the language. Is that possible?
>> >
>> > Also, can a graph be setup in a generic way? For example, can I pass
>> > the
>> > plot values to a graph in a report template? Can I setup the X and Y
>> > axis
>> > values to dynamically retrieve information for each value? Can each
>> > axis
>> > value be a separate sql statement or can each individual axis be built
>> > with
>> > seperate statements.
>> >
>> >
>> > Thanks - mc
>>
is I need to create report templates that will be influenced by external
data. A report template would be generic and the external data would
influence the data to display. There would be some logic involved to
retrieve certain information. For example, can the text for a textbox be
setup generically with an expression or could I pass specifc information to a
query to pull the right text. For example, lets say I have a word that is
stored in the database in 5 languages. I want to pass the query an indicator
to pull the correct text for the language. Is that possible?
Also, can a graph be setup in a generic way? For example, can I pass the
plot values to a graph in a report template? Can I setup the X and Y axis
values to dynamically retrieve information for each value? Can each axis
value be a separate sql statement or can each individual axis be built with
seperate statements.
Thanks - mc>For example, lets say I have a word that is
> stored in the database in 5 languages. I want to pass the query an
> indicator
> to pull the correct text for the language. Is that possible?
Sure, you can set up a report parameter and pass its value to your report
query.
> Also, can a graph be setup in a generic way? For example, can I pass the
> plot values to a graph in a report template? Can I setup the X and Y axis
> values to dynamically retrieve information for each value? Can each axis
> value be a separate sql statement or can each individual axis be built
> with
> seperate statements.
Nope, the chart region can be bound to one dataset only. Max values of X
and Y axis are defined at design time. Sounds like the best option for you
is to pre-process the report definition. In this respect, you can view your
report as the ultimate template. If you need to tweak things, you change the
report definition, upload and render the report.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"mc" <mc@.discussions.microsoft.com> wrote in message
news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
> Can you create Generic Report Templates with Reporting Services? My
> problem
> is I need to create report templates that will be influenced by external
> data. A report template would be generic and the external data would
> influence the data to display. There would be some logic involved to
> retrieve certain information. For example, can the text for a textbox be
> setup generically with an expression or could I pass specifc information
> to a
> query to pull the right text. For example, lets say I have a word that is
> stored in the database in 5 languages. I want to pass the query an
> indicator
> to pull the correct text for the language. Is that possible?
> Also, can a graph be setup in a generic way? For example, can I pass the
> plot values to a graph in a report template? Can I setup the X and Y axis
> values to dynamically retrieve information for each value? Can each axis
> value be a separate sql statement or can each individual axis be built
> with
> seperate statements.
>
> Thanks - mc|||What do you mean by pre process the report the report definition? Do you
mean to programmatically find each graph in the report RDL and substitute the
data I need for each graph and then send it for rendering?
Also, when you say max values of X and Y are defined at design time, do you
mean the plot values for lets say a line graph?
Thanks
"Teo Lachev [MVP]" wrote:
> >For example, lets say I have a word that is
> > stored in the database in 5 languages. I want to pass the query an
> > indicator
> > to pull the correct text for the language. Is that possible?
> Sure, you can set up a report parameter and pass its value to your report
> query.
> > Also, can a graph be setup in a generic way? For example, can I pass the
> > plot values to a graph in a report template? Can I setup the X and Y axis
> > values to dynamically retrieve information for each value? Can each axis
> > value be a separate sql statement or can each individual axis be built
> > with
> > seperate statements.
> Nope, the chart region can be bound to one dataset only. Max values of X
> and Y axis are defined at design time. Sounds like the best option for you
> is to pre-process the report definition. In this respect, you can view your
> report as the ultimate template. If you need to tweak things, you change the
> report definition, upload and render the report.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
> > Can you create Generic Report Templates with Reporting Services? My
> > problem
> > is I need to create report templates that will be influenced by external
> > data. A report template would be generic and the external data would
> > influence the data to display. There would be some logic involved to
> > retrieve certain information. For example, can the text for a textbox be
> > setup generically with an expression or could I pass specifc information
> > to a
> > query to pull the right text. For example, lets say I have a word that is
> > stored in the database in 5 languages. I want to pass the query an
> > indicator
> > to pull the correct text for the language. Is that possible?
> >
> > Also, can a graph be setup in a generic way? For example, can I pass the
> > plot values to a graph in a report template? Can I setup the X and Y axis
> > values to dynamically retrieve information for each value? Can each axis
> > value be a separate sql statement or can each individual axis be built
> > with
> > seperate statements.
> >
> >
> > Thanks - mc
>
>|||Yes, I ment programatically changind the report definition.
> Also, when you say max values of X and Y are defined at design time, do
> you
> mean the plot values for lets say a line graph?
Whatever properties are not expression-based. If you expand a property and
don't see the Expression item, this property cannot be controlled duruing
runtime. Your only option is to pre-process the report definition.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"mc" <mc@.discussions.microsoft.com> wrote in message
news:79546631-3B40-4BB1-B31C-BFD28B77DCBC@.microsoft.com...
> What do you mean by pre process the report the report definition? Do you
> mean to programmatically find each graph in the report RDL and substitute
> the
> data I need for each graph and then send it for rendering?
> Also, when you say max values of X and Y are defined at design time, do
> you
> mean the plot values for lets say a line graph?
> Thanks
>
> "Teo Lachev [MVP]" wrote:
>> >For example, lets say I have a word that is
>> > stored in the database in 5 languages. I want to pass the query an
>> > indicator
>> > to pull the correct text for the language. Is that possible?
>> Sure, you can set up a report parameter and pass its value to your report
>> query.
>> > Also, can a graph be setup in a generic way? For example, can I pass
>> > the
>> > plot values to a graph in a report template? Can I setup the X and Y
>> > axis
>> > values to dynamically retrieve information for each value? Can each
>> > axis
>> > value be a separate sql statement or can each individual axis be built
>> > with
>> > seperate statements.
>> Nope, the chart region can be bound to one dataset only. Max values of X
>> and Y axis are defined at design time. Sounds like the best option for
>> you
>> is to pre-process the report definition. In this respect, you can view
>> your
>> report as the ultimate template. If you need to tweak things, you change
>> the
>> report definition, upload and render the report.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:335A8727-9483-4351-929A-E1F9406A20B2@.microsoft.com...
>> > Can you create Generic Report Templates with Reporting Services? My
>> > problem
>> > is I need to create report templates that will be influenced by
>> > external
>> > data. A report template would be generic and the external data would
>> > influence the data to display. There would be some logic involved to
>> > retrieve certain information. For example, can the text for a textbox
>> > be
>> > setup generically with an expression or could I pass specifc
>> > information
>> > to a
>> > query to pull the right text. For example, lets say I have a word that
>> > is
>> > stored in the database in 5 languages. I want to pass the query an
>> > indicator
>> > to pull the correct text for the language. Is that possible?
>> >
>> > Also, can a graph be setup in a generic way? For example, can I pass
>> > the
>> > plot values to a graph in a report template? Can I setup the X and Y
>> > axis
>> > values to dynamically retrieve information for each value? Can each
>> > axis
>> > value be a separate sql statement or can each individual axis be built
>> > with
>> > seperate statements.
>> >
>> >
>> > Thanks - mc
>>
Subscribe to:
Posts (Atom)