|
|
You're in the
sql server reporting services
group:Dynamicly build report against Reporting Services
sql server reporting services:
I would like to know if it's possible to dynamicly build report againt RS ? Thanks alots Best Regards and seasons greetings! Patrice Lamarche
Possible but not that easy. Here is what you have to do today. First, you
need to learn the rdl specification (you can find that on MS site) which is XML and create the report yourself. Then you have to deploy it using web services. Since it is a server based solution you have to deploy it with a unique name so that only the user you want to use it uses it. So, two things skills you have to have for this: web services and creating the rdl on the fly. With Yukon there will be both a winform and webform control that will work with the server if it is there but does not require it. In theory (I have not use it since it is not even out in beta yet) you should be able to give it the rdl. So with Yukon you at least do not have the hoops to jump through on deploying the report you generated. What are you wanting to do that requires dynamically building the report. If it is data you have the option of filtering the data based on the user. Also, there are many many places that expressions can be used in the report that allow a degree of dynamic changes to the report. My advice is only go this route if you have to. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Patrice Lamarche" <Patrice_lamarche@Removethis.gco.ca> wrote in message news:unkvErc6EHA.4028@TK2MSFTNGP15.phx.gbl... > Hello Every one, > > I would like to know if it's possible to dynamicly build report againt RS > ? > > Thanks alots > > Best Regards and seasons greetings! > > Patrice Lamarche > Groupe Conseil Omnitech
In addition to what Bruce said, this is how I addressed a similiar problem
in the past. The customer wanted to have a report with sections which are shown on demand, that is the user could select which sections she wants to see. To minimize development effort, I decideded to have a report template which has all the sections. Then, it was just a matter of loading the report RDL in XML DOM and removing the section elements you don't need. I addition, I had to take care of re-positioning (moving up) the remaining sections to fill in the emtpy space left by the deleted sections. -- Hope this helps. --------------------------------------------- Teo Lachev, MVP [SQL Server], MCSD, MCT Author: "Microsoft Reporting Services in Action" Publisher website: http://www.manning.com/lachev Buy it from Amazon.com: http://shrinkster.com/eq Home page and blog: http://www.prologika.com/ --------------------------------------------- [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:O9bMOLd6EHA.2552@TK2MSFTNGP09.phx.gbl... > Possible but not that easy. Here is what you have to do today. First, you > need to learn the rdl specification (you can find that on MS site) which > is XML and create the report yourself. Then you have to deploy it using > web services. Since it is a server based solution you have to deploy it > with a unique name so that only the user you want to use it uses it. So, > two things skills you have to have for this: web services and creating the > rdl on the fly. With Yukon there will be both a winform and webform > control that will work with the server if it is there but does not require > it. In theory (I have not use it since it is not even out in beta yet) you > should be able to give it the rdl. So with Yukon you at least do not have > the hoops to jump through on deploying the report you generated. > > What are you wanting to do that requires dynamically building the report. > If it is data you have the option of filtering the data based on the user. > Also, there are many many places that expressions can be used in the > report that allow a degree of dynamic changes to the report. > > My advice is only go this route if you have to. > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "Patrice Lamarche" <Patrice_lamarche@Removethis.gco.ca> wrote in message > news:unkvErc6EHA.4028@TK2MSFTNGP15.phx.gbl... >> Hello Every one, >> >> I would like to know if it's possible to dynamicly build report againt RS >> ? >> >> Thanks alots >> >> Best Regards and seasons greetings! >> >> Patrice Lamarche >> Groupe Conseil Omnitech > >
You can generate the RDL/XML on the fly using the RDL reader/writer
http://www.rdlcomponents.com Jerry [quoted text, click to view] "Teo Lachev [MVP]" wrote:
> In addition to what Bruce said, this is how I addressed a similiar problem > in the past. The customer wanted to have a report with sections which are > shown on demand, that is the user could select which sections she wants to > see. To minimize development effort, I decideded to have a report template > which has all the sections. Then, it was just a matter of loading the report > RDL in XML DOM and removing the section elements you don't need. I addition, > I had to take care of re-positioning (moving up) the remaining sections to > fill in the emtpy space left by the deleted sections. > > -- > Hope this helps. > > --------------------------------------------- > Teo Lachev, MVP [SQL Server], MCSD, MCT > Author: "Microsoft Reporting Services in Action" > Publisher website: http://www.manning.com/lachev > Buy it from Amazon.com: http://shrinkster.com/eq > Home page and blog: http://www.prologika.com/ > --------------------------------------------- > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:O9bMOLd6EHA.2552@TK2MSFTNGP09.phx.gbl... > > Possible but not that easy. Here is what you have to do today. First, you > > need to learn the rdl specification (you can find that on MS site) which > > is XML and create the report yourself. Then you have to deploy it using > > web services. Since it is a server based solution you have to deploy it > > with a unique name so that only the user you want to use it uses it. So, > > two things skills you have to have for this: web services and creating the > > rdl on the fly. With Yukon there will be both a winform and webform > > control that will work with the server if it is there but does not require > > it. In theory (I have not use it since it is not even out in beta yet) you > > should be able to give it the rdl. So with Yukon you at least do not have > > the hoops to jump through on deploying the report you generated. > > > > What are you wanting to do that requires dynamically building the report. > > If it is data you have the option of filtering the data based on the user. > > Also, there are many many places that expressions can be used in the > > report that allow a degree of dynamic changes to the report. > > > > My advice is only go this route if you have to. > > -- > > Bruce Loehle-Conger > > MVP SQL Server Reporting Services > > > > > > "Patrice Lamarche" <Patrice_lamarche@Removethis.gco.ca> wrote in message > > news:unkvErc6EHA.4028@TK2MSFTNGP15.phx.gbl... > >> Hello Every one, > >> > >> I would like to know if it's possible to dynamicly build report againt RS > >> ? > >> > >> Thanks alots > >> > >> Best Regards and seasons greetings! > >> > >> Patrice Lamarche > >> Groupe Conseil Omnitech > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |