question about reporting service

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?
"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
"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?
> >
> >
> >
>|||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?
> >
> >
> >
>
>|||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?
> > >
> > >
> > >
> >
> >
> >|||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?
> > > >
> > > >
> > > >
> > >
> > >
> > >|||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 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?
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
>|||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?
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
>|||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/
---
"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/
---
"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?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> >
> >
>