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!
>>
Showing posts with label template. Show all posts
Showing posts with label template. Show all posts
Wednesday, March 21, 2012
Report template with totals?
Hello All,
Can someone tell me how to achieve this template of the report:
Initially when not expanded
+Item number
- - - - - -(these are summed values)
After expnading the fields(+)
-Item number
-item name
[ (details)
[ (details)
[ (details)
- - - -(summed values)
Right now, I can achive the second scenario (expanded one) but initially my report just comes up with
+Item number
and the second line (summed values) are not in there . Any sort of help will be appreciated.
Thanks,
Rashi
I'm not able to figure out the actual senario so that i can out work out on this but i'm sure that you can achive this by drill down option. and place the summed value at the group footer so that each time you will get summarize for that group (Item Number).
Will this help you ?
Regards,
Manoj Verma
|||You are right! A footer will also be a good option however, I figured out using a table group. That too works!
Thanks!
Rgds,
Rashi
Tuesday, March 20, 2012
Report Template
Created my first report...working fine...copied it created a new .RDL, added
to the solution, cleared the dataportion from the layout and deleted the
datasets...created new datasets and dropped a matrix in the data
portion...after assigning the values for the matrix when I preview, i get a
message "The definition of report is invalid...The datasetname is missing in
the data set region 'Data Set Name'...
Should we Not copy! Thats what we do in IT :)Ignore...Added the dataset to the matrix property "DataSetName"...
"Ranga" wrote:
> Created my first report...working fine...copied it created a new .RDL, added
> to the solution, cleared the dataportion from the layout and deleted the
> datasets...created new datasets and dropped a matrix in the data
> portion...after assigning the values for the matrix when I preview, i get a
> message "The definition of report is invalid...The datasetname is missing in
> the data set region 'Data Set Name'...
>
> Should we Not copy! Thats what we do in IT :)
>
to the solution, cleared the dataportion from the layout and deleted the
datasets...created new datasets and dropped a matrix in the data
portion...after assigning the values for the matrix when I preview, i get a
message "The definition of report is invalid...The datasetname is missing in
the data set region 'Data Set Name'...
Should we Not copy! Thats what we do in IT :)Ignore...Added the dataset to the matrix property "DataSetName"...
"Ranga" wrote:
> Created my first report...working fine...copied it created a new .RDL, added
> to the solution, cleared the dataportion from the layout and deleted the
> datasets...created new datasets and dropped a matrix in the data
> portion...after assigning the values for the matrix when I preview, i get a
> message "The definition of report is invalid...The datasetname is missing in
> the data set region 'Data Set Name'...
>
> Should we Not copy! Thats what we do in IT :)
>
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
>>
Wednesday, March 7, 2012
Report Server Project Template missing
Hi - I have installed VS 2005 Professional Edition and SQL 2005 Developer Edition with all the options(Reporting Services etc...). When I try to create new project, there is no "Report Server Project Template" under "Business Intelligence Projects". How to get that tempalte? Can any one help on this?
mail to : sugunsg@.yahoo.com
thanks in advance
sugu
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)