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
>>