|
|
You're in the
sql server reporting services
group:question about reporting service
sql server reporting services:
regions(table/matrix) on the report has to be assigned to a dataset at design time. Surekha. [quoted text, click to view] "Britney" wrote:
> oh... to be more specific, it seems like you always have to get the dataset > from databases for reporting service, > can I get it from different application (application level) then pass it > into reporting service to use it? > > "Britney" <britneychen_2001@yahoo.com> wrote in message > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > Hi, > > After playing around with reporting service for a few days, > > I can see that it's very easy to create dataset and design page styles > > within > > the reporting service. > > Now I have a question, what if a third party company send me a dataset > (not > > belong to reporting service), > > then I want to pass this dataset to reporting service and do further > > formatting and style. is that possible? > > > > > > > >
As Bruce mentioned it is possible but it is not an easy process as one can
expect. Read more in Books online for reporting service – there is an update for books online as well. I am generating a dataset and saving it in XML format file with unique name. Then I am passing that unique name to Report via parameter (url) and with custom data processing extension I am able to read that xml file convert it to a dataset which Reporting Services uses to render a report. You will need to adjust example that you can find on the net to meet your application needs. Best of luck [quoted text, click to view] "hf" wrote:
> As far as I know, I dont think it is possible, because the data > regions(table/matrix) on the report has to be assigned to a dataset at design > time. > > Surekha. > > "Britney" wrote: > > > oh... to be more specific, it seems like you always have to get the dataset > > from databases for reporting service, > > can I get it from different application (application level) then pass it > > into reporting service to use it? > > > > "Britney" <britneychen_2001@yahoo.com> wrote in message > > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > > Hi, > > > After playing around with reporting service for a few days, > > > I can see that it's very easy to create dataset and design page styles > > > within > > > the reporting service. > > > Now I have a question, what if a third party company send me a dataset > > (not > > > belong to reporting service), > > > then I want to pass this dataset to reporting service and do further > > > formatting and style. is that possible? > > > > > > > > > > > > >
But as Surekha mentioned you can not use report design to acess dataset
schema structure to design a report. You will need to know a schema in advance while designing it. Dejan [quoted text, click to view] "Pendula" wrote:
> As Bruce mentioned it is possible but it is not an easy process as one can > expect. > Read more in Books online for reporting service – there is an update for > books online as well. > I am generating a dataset and saving it in XML format file with unique name. > Then I am passing that unique name to Report via parameter (url) and with > custom data processing extension I am able to read that xml file convert it > to a dataset which Reporting Services uses to render a report. > > You will need to adjust example that you can find on the net to meet your > application needs. > > Best of luck > > "hf" wrote: > > > As far as I know, I dont think it is possible, because the data > > regions(table/matrix) on the report has to be assigned to a dataset at design > > time. > > > > Surekha. > > > > "Britney" wrote: > > > > > oh... to be more specific, it seems like you always have to get the dataset > > > from databases for reporting service, > > > can I get it from different application (application level) then pass it > > > into reporting service to use it? > > > > > > "Britney" <britneychen_2001@yahoo.com> wrote in message > > > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > > > Hi, > > > > After playing around with reporting service for a few days, > > > > I can see that it's very easy to create dataset and design page styles > > > > within > > > > the reporting service. > > > > Now I have a question, what if a third party company send me a dataset > > > (not > > > > belong to reporting service), > > > > then I want to pass this dataset to reporting service and do further > > > > formatting and style. is that possible? > > > > > > > > > > > > > > > > > >
Read up on data processing extension. That is how to do this sort of thing.
-- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Britney" <britneychen_2001@yahoo.com> wrote in message news:uh0RTMn0EHA.1392@TK2MSFTNGP14.phx.gbl... > oh... to be more specific, it seems like you always have to get the dataset > from databases for reporting service, > can I get it from different application (application level) then pass it > into reporting service to use it? > > "Britney" <britneychen_2001@yahoo.com> wrote in message > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > Hi, > > After playing around with reporting service for a few days, > > I can see that it's very easy to create dataset and design page styles > > within > > the reporting service. > > Now I have a question, what if a third party company send me a dataset > (not > > belong to reporting service), > > then I want to pass this dataset to reporting service and do further > > formatting and style. is that possible? > > > > > > > >
Hi,
After playing around with reporting service for a few days, I can see that it's very easy to create dataset and design page styles within the reporting service. Now I have a question, what if a third party company send me a dataset (not belong to reporting service), then I want to pass this dataset to reporting service and do further formatting and style. is that possible?
oh... to be more specific, it seems like you always have to get the dataset
from databases for reporting service, can I get it from different application (application level) then pass it into reporting service to use it? [quoted text, click to view] "Britney" <britneychen_2001@yahoo.com> wrote in message news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > Hi, > After playing around with reporting service for a few days, > I can see that it's very easy to create dataset and design page styles > within > the reporting service. > Now I have a question, what if a third party company send me a dataset (not > belong to reporting service), > then I want to pass this dataset to reporting service and do further > formatting and style. is that possible? > > >
With version 1.0 you have to write a custom data extension to do so.
Accidentally, I wrote one which allows you to "bind" the report to an ADO.NET dataset. And yes, it allows you drag-and-drop fields in the Report Designer just like you would do it with standard RS datasets. http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5 Moving forward, version 2005 will comes with WinForm and ASP.NET controls which will support a disconnected mode where the application will be able to bind the report to ADO.NET datasets. -- 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] "Pendula" <Pendula@discussions.microsoft.com> wrote in message news:66B0063A-0BE4-4A73-B875-2227187A1580@microsoft.com... > But as Surekha mentioned you can not use report design to acess dataset > schema structure to design a report. You will need to know a schema in > advance while designing it. > > Dejan > > "Pendula" wrote: > > > As Bruce mentioned it is possible but it is not an easy process as one can > > expect. > > Read more in Books online for reporting service - there is an update for > > books online as well. > > I am generating a dataset and saving it in XML format file with unique name. > > Then I am passing that unique name to Report via parameter (url) and with > > custom data processing extension I am able to read that xml file convert it > > to a dataset which Reporting Services uses to render a report. > > > > You will need to adjust example that you can find on the net to meet your > > application needs. > > > > Best of luck > > > > "hf" wrote: > > > > > As far as I know, I dont think it is possible, because the data > > > regions(table/matrix) on the report has to be assigned to a dataset at design > > > time. > > > > > > Surekha. > > > > > > "Britney" wrote: > > > > > > > oh... to be more specific, it seems like you always have to get the dataset > > > > from databases for reporting service, > > > > can I get it from different application (application level) then pass it > > > > into reporting service to use it? > > > > > > > > "Britney" <britneychen_2001@yahoo.com> wrote in message > > > > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > > > > Hi, > > > > > After playing around with reporting service for a few days, > > > > > I can see that it's very easy to create dataset and design page styles > > > > > within > > > > > the reporting service. > > > > > Now I have a question, what if a third party company send me a dataset > > > > (not > > > > > belong to reporting service), > > > > > then I want to pass this dataset to reporting service and do further > > > > > formatting and style. is that possible? > > > > > > > > > > > > > > > > > > > > > > > > > > >
I have service pack 1, is there already a custom data extension build-in in
reporting service? [quoted text, click to view] "Teo Lachev [MVP]" <teo.lachev@nospam.prologika.com> wrote in message news:%23uV08k80EHA.1400@TK2MSFTNGP11.phx.gbl... > With version 1.0 you have to write a custom data extension to do so. > Accidentally, I wrote one which allows you to "bind" the report to an > ADO.NET dataset. And yes, it allows you drag-and-drop fields in the Report > Designer just like you would do it with standard RS datasets. > > http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5 > > Moving forward, version 2005 will comes with WinForm and ASP.NET controls > which will support a disconnected mode where the application will be able to > bind the report to ADO.NET datasets. > > -- > 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/ > --------------------------------------------- > > "Pendula" <Pendula@discussions.microsoft.com> wrote in message > news:66B0063A-0BE4-4A73-B875-2227187A1580@microsoft.com... > > But as Surekha mentioned you can not use report design to acess dataset > > schema structure to design a report. You will need to know a schema in > > advance while designing it. > > > > Dejan > > > > "Pendula" wrote: > > > > > As Bruce mentioned it is possible but it is not an easy process as one > can > > > expect. > > > Read more in Books online for reporting service - there is an update for > > > books online as well. > > > I am generating a dataset and saving it in XML format file with unique > name. > > > Then I am passing that unique name to Report via parameter (url) and > with > > > custom data processing extension I am able to read that xml file convert > it > > > to a dataset which Reporting Services uses to render a report. > > > > > > You will need to adjust example that you can find on the net to meet > your > > > application needs. > > > > > > Best of luck > > > > > > "hf" wrote: > > > > > > > As far as I know, I dont think it is possible, because the data > > > > regions(table/matrix) on the report has to be assigned to a dataset at > design > > > > time. > > > > > > > > Surekha. > > > > > > > > "Britney" wrote: > > > > > > > > > oh... to be more specific, it seems like you always have to get the > dataset > > > > > from databases for reporting service, > > > > > can I get it from different application (application level) then > pass it > > > > > into reporting service to use it? > > > > > > > > > > "Britney" <britneychen_2001@yahoo.com> wrote in message > > > > > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > > > > > Hi, > > > > > > After playing around with reporting service for a few days, > > > > > > I can see that it's very easy to create dataset and design page > styles > > > > > > within > > > > > > the reporting service. > > > > > > Now I have a question, what if a third party company send me a > dataset > > > > > (not > > > > > > belong to reporting service), > > > > > > then I want to pass this dataset to reporting service and do > further > > > > > > formatting and style. is that possible? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
I read the custom data extension 's readme file,
it said the following, URL Due to the URL size limitations, passing a large dataset as a query parameter is not possible. so my question is, what is the size limit? [quoted text, click to view] "Teo Lachev [MVP]" <teo.lachev@nospam.prologika.com> wrote in message news:%23uV08k80EHA.1400@TK2MSFTNGP11.phx.gbl... > With version 1.0 you have to write a custom data extension to do so. > Accidentally, I wrote one which allows you to "bind" the report to an > ADO.NET dataset. And yes, it allows you drag-and-drop fields in the Report > Designer just like you would do it with standard RS datasets. > > http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5 > > Moving forward, version 2005 will comes with WinForm and ASP.NET controls > which will support a disconnected mode where the application will be able to > bind the report to ADO.NET datasets. > > -- > 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/ > --------------------------------------------- > > "Pendula" <Pendula@discussions.microsoft.com> wrote in message > news:66B0063A-0BE4-4A73-B875-2227187A1580@microsoft.com... > > But as Surekha mentioned you can not use report design to acess dataset > > schema structure to design a report. You will need to know a schema in > > advance while designing it. > > > > Dejan > > > > "Pendula" wrote: > > > > > As Bruce mentioned it is possible but it is not an easy process as one > can > > > expect. > > > Read more in Books online for reporting service - there is an update for > > > books online as well. > > > I am generating a dataset and saving it in XML format file with unique > name. > > > Then I am passing that unique name to Report via parameter (url) and > with > > > custom data processing extension I am able to read that xml file convert > it > > > to a dataset which Reporting Services uses to render a report. > > > > > > You will need to adjust example that you can find on the net to meet > your > > > application needs. > > > > > > Best of luck > > > > > > "hf" wrote: > > > > > > > As far as I know, I dont think it is possible, because the data > > > > regions(table/matrix) on the report has to be assigned to a dataset at > design > > > > time. > > > > > > > > Surekha. > > > > > > > > "Britney" wrote: > > > > > > > > > oh... to be more specific, it seems like you always have to get the > dataset > > > > > from databases for reporting service, > > > > > can I get it from different application (application level) then > pass it > > > > > into reporting service to use it? > > > > > > > > > > "Britney" <britneychen_2001@yahoo.com> wrote in message > > > > > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > > > > > Hi, > > > > > > After playing around with reporting service for a few days, > > > > > > I can see that it's very easy to create dataset and design page > styles > > > > > > within > > > > > > the reporting service. > > > > > > Now I have a question, what if a third party company send me a > dataset > > > > > (not > > > > > > belong to reporting service), > > > > > > then I want to pass this dataset to reporting service and do > further > > > > > > formatting and style. is that possible? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Britney,
There isn't a builtin extension that will allow you do what you want. There is a sample File Share data extension which comes with the RS sample and can be used as a starting point. However, you can save yourself a lot of effort by using mine. -- 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] "Britney" <britneychen_2001@yahoo.com> wrote in message news:eq9Opei1EHA.1452@TK2MSFTNGP11.phx.gbl... > I have service pack 1, is there already a custom data extension build-in in > reporting service? > > > "Teo Lachev [MVP]" <teo.lachev@nospam.prologika.com> wrote in message > news:%23uV08k80EHA.1400@TK2MSFTNGP11.phx.gbl... > > With version 1.0 you have to write a custom data extension to do so. > > Accidentally, I wrote one which allows you to "bind" the report to an > > ADO.NET dataset. And yes, it allows you drag-and-drop fields in the Report > > Designer just like you would do it with standard RS datasets. > > > > > http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5 > > > > Moving forward, version 2005 will comes with WinForm and ASP.NET controls > > which will support a disconnected mode where the application will be able > to > > bind the report to ADO.NET datasets. > > > > -- > > 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/ > > --------------------------------------------- > > > > "Pendula" <Pendula@discussions.microsoft.com> wrote in message > > news:66B0063A-0BE4-4A73-B875-2227187A1580@microsoft.com... > > > But as Surekha mentioned you can not use report design to acess dataset > > > schema structure to design a report. You will need to know a schema in > > > advance while designing it. > > > > > > Dejan > > > > > > "Pendula" wrote: > > > > > > > As Bruce mentioned it is possible but it is not an easy process as one > > can > > > > expect. > > > > Read more in Books online for reporting service - there is an update > for > > > > books online as well. > > > > I am generating a dataset and saving it in XML format file with unique > > name. > > > > Then I am passing that unique name to Report via parameter (url) and > > with > > > > custom data processing extension I am able to read that xml file > convert > > it > > > > to a dataset which Reporting Services uses to render a report. > > > > > > > > You will need to adjust example that you can find on the net to meet > > your > > > > application needs. > > > > > > > > Best of luck > > > > > > > > "hf" wrote: > > > > > > > > > As far as I know, I dont think it is possible, because the data > > > > > regions(table/matrix) on the report has to be assigned to a dataset > at > > design > > > > > time. > > > > > > > > > > Surekha. > > > > > > > > > > "Britney" wrote: > > > > > > > > > > > oh... to be more specific, it seems like you always have to get > the > > dataset > > > > > > from databases for reporting service, > > > > > > can I get it from different application (application level) then > > pass it > > > > > > into reporting service to use it? > > > > > > > > > > > > "Britney" <britneychen_2001@yahoo.com> wrote in message > > > > > > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > > > > > > Hi, > > > > > > > After playing around with reporting service for a few days, > > > > > > > I can see that it's very easy to create dataset and design page > > styles > > > > > > > within > > > > > > > the reporting service. > > > > > > > Now I have a question, what if a third party company send me a > > dataset > > > > > > (not > > > > > > > belong to reporting service), > > > > > > > then I want to pass this dataset to reporting service and do > > further > > > > > > > formatting and style. is that possible? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
The IE limit is 2K and due to this limitation passing a dataset by URL is
not practical. Instead, my dataset extension supports: 1. Passing the serialized dataset XML (typically used with SOAP addressability). 2. Reporting from saved as files datasets. In this case, you can pass the file path as a parameter and render the report via URL. -- 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] "Britney" <britneychen_2001@yahoo.com> wrote in message news:O%23%23ZXki1EHA.2824@TK2MSFTNGP09.phx.gbl... > I read the custom data extension 's readme file, > it said the following, > > URL > Due to the URL size limitations, passing a large dataset as a query > parameter is not possible. > > so my question is, what is the size limit? > > > > "Teo Lachev [MVP]" <teo.lachev@nospam.prologika.com> wrote in message > news:%23uV08k80EHA.1400@TK2MSFTNGP11.phx.gbl... > > With version 1.0 you have to write a custom data extension to do so. > > Accidentally, I wrote one which allows you to "bind" the report to an > > ADO.NET dataset. And yes, it allows you drag-and-drop fields in the Report > > Designer just like you would do it with standard RS datasets. > > > > > http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5 > > > > Moving forward, version 2005 will comes with WinForm and ASP.NET controls > > which will support a disconnected mode where the application will be able > to > > bind the report to ADO.NET datasets. > > > > -- > > 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/ > > --------------------------------------------- > > > > "Pendula" <Pendula@discussions.microsoft.com> wrote in message > > news:66B0063A-0BE4-4A73-B875-2227187A1580@microsoft.com... > > > But as Surekha mentioned you can not use report design to acess dataset > > > schema structure to design a report. You will need to know a schema in > > > advance while designing it. > > > > > > Dejan > > > > > > "Pendula" wrote: > > > > > > > As Bruce mentioned it is possible but it is not an easy process as one > > can > > > > expect. > > > > Read more in Books online for reporting service - there is an update > for > > > > books online as well. > > > > I am generating a dataset and saving it in XML format file with unique > > name. > > > > Then I am passing that unique name to Report via parameter (url) and > > with > > > > custom data processing extension I am able to read that xml file > convert > > it > > > > to a dataset which Reporting Services uses to render a report. > > > > > > > > You will need to adjust example that you can find on the net to meet > > your > > > > application needs. > > > > > > > > Best of luck > > > > > > > > "hf" wrote: > > > > > > > > > As far as I know, I dont think it is possible, because the data > > > > > regions(table/matrix) on the report has to be assigned to a dataset > at > > design > > > > > time. > > > > > > > > > > Surekha. > > > > > > > > > > "Britney" wrote: > > > > > > > > > > > oh... to be more specific, it seems like you always have to get > the > > dataset > > > > > > from databases for reporting service, > > > > > > can I get it from different application (application level) then > > pass it > > > > > > into reporting service to use it? > > > > > > > > > > > > "Britney" <britneychen_2001@yahoo.com> wrote in message > > > > > > news:uNLTsJn0EHA.1300@TK2MSFTNGP14.phx.gbl... > > > > > > > Hi, > > > > > > > After playing around with reporting service for a few days, > > > > > > > I can see that it's very easy to create dataset and design page > > styles > > > > > > > within > > > > > > > the reporting service. > > > > > > > Now I have a question, what if a third party company send me a > > dataset > > > > > > (not > > > > > > > belong to reporting service), > > > > > > > then I want to pass this dataset to reporting service and do > > further > > > > > > > formatting and style. is that possible? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
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 |