Hi all,
If it is possible, how I can extend the Textbox item with a DataSet
property. In order to display a field from multiple rows, with a separator ?
Example:
a dataset with 10 rows (and 1 field "Name")
and I want to display in the Textbox
"Name1, Name2, Name3, Name4, Name5, Name6, Name7, Name8, Name9, Name10"
ThanksI'm sure this is possible, just to give you a point in one possible
direction...
From a Database side of things, you could pivot the data in your SQL
statement. SQL Server 2005 has new SQL commands called PIVOT and UNPIVOT...
Once your rows values are pivotted to columns in a single row, then you
could specify them easily enough in the text box.
Hope that helps.
Dan.
"gbouzebra" <gbouzebra@.discussions.microsoft.com> wrote in message
news:D8959BBA-3778-4129-9E3F-AB4443A58C5F@.microsoft.com...
> Hi all,
> If it is possible, how I can extend the Textbox item with a DataSet
> property. In order to display a field from multiple rows, with a separator
> ?
> Example:
> a dataset with 10 rows (and 1 field "Name")
> and I want to display in the Textbox
> "Name1, Name2, Name3, Name4, Name5, Name6, Name7, Name8, Name9, Name10"
> Thanks
Showing posts with label dataset. Show all posts
Showing posts with label dataset. Show all posts
Monday, March 19, 2012
Sunday, March 11, 2012
Custom object or DataSet ?
Hello
I'm using SQL 2000 server and I have question about logining to server. Is it possible to include Active Directory structure? I know I can define SQL user or use Windows Based Account, but I havent read anywhere how to integrate Active Directory. If there is solution or if anybody has experience with this problem, I would be grateful forhelp or reference (btw, I'm using win 2003 server).
Thanks
MatjazCheck this link (http://search.win2000mag.net/query.html) and corresponding links.
I'm using SQL 2000 server and I have question about logining to server. Is it possible to include Active Directory structure? I know I can define SQL user or use Windows Based Account, but I havent read anywhere how to integrate Active Directory. If there is solution or if anybody has experience with this problem, I would be grateful forhelp or reference (btw, I'm using win 2003 server).
Thanks
MatjazCheck this link (http://search.win2000mag.net/query.html) and corresponding links.
Wednesday, March 7, 2012
Custom DataSets
Is there any way to add a dataset to RS without it being a SP or Query? I
have .Net code that handles all of the database connections and SP calls and
returns datasets that I would like to plug into RS for my repotsOn Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> Is there any way to add a dataset to RS without it being a SP or Query? I
> have .Net code that handles all of the database connections and SP calls and
> returns datasets that I would like to plug into RS for my repots
You could try using the Code section (via: Layout view >> Report drop-
down >> Report Properties... >> Code tab); however, I'm not certain
that it will work. That said, its best for performance for you to use
the built in dataset options available (preferably stored procedure-
based datasets). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks I will keep that in mind.. the only issue I have with the SP route is
moving the code across environments(DEV, TEST to PRD). Each of these
environments are on different servers with different connection strings.
"EMartinez" wrote:
> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> > Is there any way to add a dataset to RS without it being a SP or Query? I
> > have .Net code that handles all of the database connections and SP calls and
> > returns datasets that I would like to plug into RS for my repots
>
> You could try using the Code section (via: Layout view >> Report drop-
> down >> Report Properties... >> Code tab); however, I'm not certain
> that it will work. That said, its best for performance for you to use
> the built in dataset options available (preferably stored procedure-
> based datasets). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||You can do data processing extension but it is non-trivial and I really
recommend against it.
As far as moving across Dev/Test/Production. This is no problem whatsoever.
While reports can have their own per report data source I strongly suggest
not doing that. Instead you use shared data sources. The first time you
deploy a report based on a shared datasource the datasource gets deployed.
By default thereafter the data source does not get deployed. After the first
deployment of the datasource you set up the connection strings and
credentials for that data source. For each place (Dev/test/production) you
would have different connections/credentials.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adam" <Adam@.discussions.microsoft.com> wrote in message
news:2E856BD3-2D8F-430F-8CDD-C67A3160BC08@.microsoft.com...
> Thanks I will keep that in mind.. the only issue I have with the SP route
> is
> moving the code across environments(DEV, TEST to PRD). Each of these
> environments are on different servers with different connection strings.
> "EMartinez" wrote:
>> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
>> > Is there any way to add a dataset to RS without it being a SP or Query?
>> > I
>> > have .Net code that handles all of the database connections and SP
>> > calls and
>> > returns datasets that I would like to plug into RS for my repots
>>
>> You could try using the Code section (via: Layout view >> Report drop-
>> down >> Report Properties... >> Code tab); however, I'm not certain
>> that it will work. That said, its best for performance for you to use
>> the built in dataset options available (preferably stored procedure-
>> based datasets). Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant|||On Dec 21, 8:50 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You can do data processing extension but it is non-trivial and I really
> recommend against it.
> As far as moving across Dev/Test/Production. This is no problem whatsoever.
> While reports can have their own per report data source I strongly suggest
> not doing that. Instead you use shared data sources. The first time you
> deploy a report based on a shared datasource the datasource gets deployed.
> By default thereafter the data source does not get deployed. After the first
> deployment of the datasource you set up the connection strings and
> credentials for that data source. For each place (Dev/test/production) you
> would have different connections/credentials.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Adam" <A...@.discussions.microsoft.com> wrote in message
> news:2E856BD3-2D8F-430F-8CDD-C67A3160BC08@.microsoft.com...
> > Thanks I will keep that in mind.. the only issue I have with the SP route
> > is
> > moving the code across environments(DEV, TEST to PRD). Each of these
> > environments are on different servers with different connection strings.
> > "EMartinez" wrote:
> >> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> >> > Is there any way to add a dataset to RS without it being a SP or Query?
> >> > I
> >> > have .Net code that handles all of the database connections and SP
> >> > calls and
> >> > returns datasets that I would like to plug into RS for my repots
> >> You could try using the Code section (via: Layout view >> Report drop-
> >> down >> Report Properties... >> Code tab); however, I'm not certain
> >> that it will work. That said, its best for performance for you to use
> >> the built in dataset options available (preferably stored procedure-
> >> based datasets). Hope this helps.
> >> Regards,
> >> Enrique Martinez
> >> Sr. Software Consultant
You're welcome. Also, you could have a table that exists in every
environment that basically tells what the environment is and the
locations of the remote environments and uses linked servers to
execute the local stored procedure of the desired environment. Hope
this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant
have .Net code that handles all of the database connections and SP calls and
returns datasets that I would like to plug into RS for my repotsOn Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> Is there any way to add a dataset to RS without it being a SP or Query? I
> have .Net code that handles all of the database connections and SP calls and
> returns datasets that I would like to plug into RS for my repots
You could try using the Code section (via: Layout view >> Report drop-
down >> Report Properties... >> Code tab); however, I'm not certain
that it will work. That said, its best for performance for you to use
the built in dataset options available (preferably stored procedure-
based datasets). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks I will keep that in mind.. the only issue I have with the SP route is
moving the code across environments(DEV, TEST to PRD). Each of these
environments are on different servers with different connection strings.
"EMartinez" wrote:
> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> > Is there any way to add a dataset to RS without it being a SP or Query? I
> > have .Net code that handles all of the database connections and SP calls and
> > returns datasets that I would like to plug into RS for my repots
>
> You could try using the Code section (via: Layout view >> Report drop-
> down >> Report Properties... >> Code tab); however, I'm not certain
> that it will work. That said, its best for performance for you to use
> the built in dataset options available (preferably stored procedure-
> based datasets). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||You can do data processing extension but it is non-trivial and I really
recommend against it.
As far as moving across Dev/Test/Production. This is no problem whatsoever.
While reports can have their own per report data source I strongly suggest
not doing that. Instead you use shared data sources. The first time you
deploy a report based on a shared datasource the datasource gets deployed.
By default thereafter the data source does not get deployed. After the first
deployment of the datasource you set up the connection strings and
credentials for that data source. For each place (Dev/test/production) you
would have different connections/credentials.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adam" <Adam@.discussions.microsoft.com> wrote in message
news:2E856BD3-2D8F-430F-8CDD-C67A3160BC08@.microsoft.com...
> Thanks I will keep that in mind.. the only issue I have with the SP route
> is
> moving the code across environments(DEV, TEST to PRD). Each of these
> environments are on different servers with different connection strings.
> "EMartinez" wrote:
>> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
>> > Is there any way to add a dataset to RS without it being a SP or Query?
>> > I
>> > have .Net code that handles all of the database connections and SP
>> > calls and
>> > returns datasets that I would like to plug into RS for my repots
>>
>> You could try using the Code section (via: Layout view >> Report drop-
>> down >> Report Properties... >> Code tab); however, I'm not certain
>> that it will work. That said, its best for performance for you to use
>> the built in dataset options available (preferably stored procedure-
>> based datasets). Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant|||On Dec 21, 8:50 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You can do data processing extension but it is non-trivial and I really
> recommend against it.
> As far as moving across Dev/Test/Production. This is no problem whatsoever.
> While reports can have their own per report data source I strongly suggest
> not doing that. Instead you use shared data sources. The first time you
> deploy a report based on a shared datasource the datasource gets deployed.
> By default thereafter the data source does not get deployed. After the first
> deployment of the datasource you set up the connection strings and
> credentials for that data source. For each place (Dev/test/production) you
> would have different connections/credentials.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Adam" <A...@.discussions.microsoft.com> wrote in message
> news:2E856BD3-2D8F-430F-8CDD-C67A3160BC08@.microsoft.com...
> > Thanks I will keep that in mind.. the only issue I have with the SP route
> > is
> > moving the code across environments(DEV, TEST to PRD). Each of these
> > environments are on different servers with different connection strings.
> > "EMartinez" wrote:
> >> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> >> > Is there any way to add a dataset to RS without it being a SP or Query?
> >> > I
> >> > have .Net code that handles all of the database connections and SP
> >> > calls and
> >> > returns datasets that I would like to plug into RS for my repots
> >> You could try using the Code section (via: Layout view >> Report drop-
> >> down >> Report Properties... >> Code tab); however, I'm not certain
> >> that it will work. That said, its best for performance for you to use
> >> the built in dataset options available (preferably stored procedure-
> >> based datasets). Hope this helps.
> >> Regards,
> >> Enrique Martinez
> >> Sr. Software Consultant
You're welcome. Also, you could have a table that exists in every
environment that basically tells what the environment is and the
locations of the remote environments and uses linked servers to
execute the local stored procedure of the desired environment. Hope
this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant
Custom Dataset Data Extension Tutorial
I posted an excerpt from my book "Microsoft Reporting Services in Action" on
the TheServerSide.net
(http://www.theserverside.net/books/manning/ReportingServices/index.tss).
The article discusses how developers can implement a custom dataset data
extension to report off ADO.NET datasets.
---
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/
---This book has a great section on Advanced reporting that covers reporting
off of an ADO.NET dataset and a custom security log on for Windows Forms.
Teo also gave a great presentation at the .NET user group and the SQL Server
user group in Atlanta, I could only find the slides and code on the SQL
Server group: http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
. This book has helped me thousands of times and it is one of the better
books on drilling down into Reporting Services.
Brendon Schwartz
http://weblogs.cerkit.com/regularguys
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>I posted an excerpt from my book "Microsoft Reporting Services in Action"
>on
> the TheServerSide.net
> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
> The article discusses how developers can implement a custom dataset data
> extension to report off ADO.NET datasets.
>
> ---
> 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/
> ---
>|||Thanks for liking my book, Brendon.
To use this occasion, I would really appreciate it if I could get some
feedback from the RS technical community as far what could be improved in my
book moving forward to RS 2005. I actually posted a blog to solicit some
input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
it's been a voice in the desert. Not even a curse! There must be something
wrong here... Don't you guys read my blog or what? :-)
Seriously, everyone that cares about my writings, please take moment to drop
me an e-mail or add a feedback to the blog link and let me know your
thoughts around the questions I listed in the Road Ahead blog.
Thank you in advance,
---
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/
---
"Brendon Schwartz" <nomail@.workinghard.com> wrote in message
news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
> This book has a great section on Advanced reporting that covers reporting
> off of an ADO.NET dataset and a custom security log on for Windows Forms.
> Teo also gave a great presentation at the .NET user group and the SQL
Server
> user group in Atlanta, I could only find the slides and code on the SQL
> Server group:
http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
> . This book has helped me thousands of times and it is one of the better
> books on drilling down into Reporting Services.
> Brendon Schwartz
> http://weblogs.cerkit.com/regularguys
>
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
> >I posted an excerpt from my book "Microsoft Reporting Services in Action"
> >on
> > the TheServerSide.net
> >
(http://www.theserverside.net/books/manning/ReportingServices/index.tss).
> > The article discusses how developers can implement a custom dataset data
> > extension to report off ADO.NET datasets.
> >
> >
> > ---
> > 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/
> > ---
> >
> >
>|||Teo,
I am currently trying to implement your dataset data extension and have
encountered several issues, most of which I have gotten worked out. However,
when I try to preview the report inside of VS.Net 2003, I get an error.
The error states: An error has occurred during report processing. Object
reference not set to an instance of an object.
Any ideas?
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:OrynjDb2EHA.1076@.TK2MSFTNGP09.phx.gbl...
> Thanks for liking my book, Brendon.
> To use this occasion, I would really appreciate it if I could get some
> feedback from the RS technical community as far what could be improved in
> my
> book moving forward to RS 2005. I actually posted a blog to solicit some
> input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
> it's been a voice in the desert. Not even a curse! There must be something
> wrong here... Don't you guys read my blog or what? :-)
> Seriously, everyone that cares about my writings, please take moment to
> drop
> me an e-mail or add a feedback to the blog link and let me know your
> thoughts around the questions I listed in the Road Ahead blog.
> Thank you in advance,
> ---
> 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/
> ---
> "Brendon Schwartz" <nomail@.workinghard.com> wrote in message
> news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
>> This book has a great section on Advanced reporting that covers reporting
>> off of an ADO.NET dataset and a custom security log on for Windows Forms.
>> Teo also gave a great presentation at the .NET user group and the SQL
> Server
>> user group in Atlanta, I could only find the slides and code on the SQL
>> Server group:
> http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
>> . This book has helped me thousands of times and it is one of the better
>> books on drilling down into Reporting Services.
>> Brendon Schwartz
>> http://weblogs.cerkit.com/regularguys
>>
>> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
>> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>> >I posted an excerpt from my book "Microsoft Reporting Services in
>> >Action"
>> >on
>> > the TheServerSide.net
>> >
> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
>> > The article discusses how developers can implement a custom dataset
>> > data
>> > extension to report off ADO.NET datasets.
>> >
>> >
>> > ---
>> > 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/
>> > ---
>> >
>> >
>>
>|||Does clicking on the Refresh Fields button help? You could get more
troubleshooting tips from the log on GotDotNet.com
(http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5)
--
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/
---
"Tarik Peterson" <tarikp@.investigo.net> wrote in message
news:udixGjA9EHA.368@.TK2MSFTNGP10.phx.gbl...
> Teo,
> I am currently trying to implement your dataset data extension and have
> encountered several issues, most of which I have gotten worked out.
> However, when I try to preview the report inside of VS.Net 2003, I get an
> error.
> The error states: An error has occurred during report processing. Object
> reference not set to an instance of an object.
> Any ideas?
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:OrynjDb2EHA.1076@.TK2MSFTNGP09.phx.gbl...
>> Thanks for liking my book, Brendon.
>> To use this occasion, I would really appreciate it if I could get some
>> feedback from the RS technical community as far what could be improved in
>> my
>> book moving forward to RS 2005. I actually posted a blog to solicit some
>> input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
>> it's been a voice in the desert. Not even a curse! There must be
>> something
>> wrong here... Don't you guys read my blog or what? :-)
>> Seriously, everyone that cares about my writings, please take moment to
>> drop
>> me an e-mail or add a feedback to the blog link and let me know your
>> thoughts around the questions I listed in the Road Ahead blog.
>> Thank you in advance,
>> ---
>> 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/
>> ---
>> "Brendon Schwartz" <nomail@.workinghard.com> wrote in message
>> news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
>> This book has a great section on Advanced reporting that covers
>> reporting
>> off of an ADO.NET dataset and a custom security log on for Windows
>> Forms.
>> Teo also gave a great presentation at the .NET user group and the SQL
>> Server
>> user group in Atlanta, I could only find the slides and code on the SQL
>> Server group:
>> http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
>> . This book has helped me thousands of times and it is one of the
>> better
>> books on drilling down into Reporting Services.
>> Brendon Schwartz
>> http://weblogs.cerkit.com/regularguys
>>
>> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
>> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>> >I posted an excerpt from my book "Microsoft Reporting Services in
>> >Action"
>> >on
>> > the TheServerSide.net
>> >
>> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
>> > The article discusses how developers can implement a custom dataset
>> > data
>> > extension to report off ADO.NET datasets.
>> >
>> >
>> > ---
>> > 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/
>> > ---
>> >
>> >
>>
>>
>
the TheServerSide.net
(http://www.theserverside.net/books/manning/ReportingServices/index.tss).
The article discusses how developers can implement a custom dataset data
extension to report off ADO.NET datasets.
---
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/
---This book has a great section on Advanced reporting that covers reporting
off of an ADO.NET dataset and a custom security log on for Windows Forms.
Teo also gave a great presentation at the .NET user group and the SQL Server
user group in Atlanta, I could only find the slides and code on the SQL
Server group: http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
. This book has helped me thousands of times and it is one of the better
books on drilling down into Reporting Services.
Brendon Schwartz
http://weblogs.cerkit.com/regularguys
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>I posted an excerpt from my book "Microsoft Reporting Services in Action"
>on
> the TheServerSide.net
> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
> The article discusses how developers can implement a custom dataset data
> extension to report off ADO.NET datasets.
>
> ---
> 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/
> ---
>|||Thanks for liking my book, Brendon.
To use this occasion, I would really appreciate it if I could get some
feedback from the RS technical community as far what could be improved in my
book moving forward to RS 2005. I actually posted a blog to solicit some
input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
it's been a voice in the desert. Not even a curse! There must be something
wrong here... Don't you guys read my blog or what? :-)
Seriously, everyone that cares about my writings, please take moment to drop
me an e-mail or add a feedback to the blog link and let me know your
thoughts around the questions I listed in the Road Ahead blog.
Thank you in advance,
---
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/
---
"Brendon Schwartz" <nomail@.workinghard.com> wrote in message
news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
> This book has a great section on Advanced reporting that covers reporting
> off of an ADO.NET dataset and a custom security log on for Windows Forms.
> Teo also gave a great presentation at the .NET user group and the SQL
Server
> user group in Atlanta, I could only find the slides and code on the SQL
> Server group:
http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
> . This book has helped me thousands of times and it is one of the better
> books on drilling down into Reporting Services.
> Brendon Schwartz
> http://weblogs.cerkit.com/regularguys
>
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
> >I posted an excerpt from my book "Microsoft Reporting Services in Action"
> >on
> > the TheServerSide.net
> >
(http://www.theserverside.net/books/manning/ReportingServices/index.tss).
> > The article discusses how developers can implement a custom dataset data
> > extension to report off ADO.NET datasets.
> >
> >
> > ---
> > 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/
> > ---
> >
> >
>|||Teo,
I am currently trying to implement your dataset data extension and have
encountered several issues, most of which I have gotten worked out. However,
when I try to preview the report inside of VS.Net 2003, I get an error.
The error states: An error has occurred during report processing. Object
reference not set to an instance of an object.
Any ideas?
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:OrynjDb2EHA.1076@.TK2MSFTNGP09.phx.gbl...
> Thanks for liking my book, Brendon.
> To use this occasion, I would really appreciate it if I could get some
> feedback from the RS technical community as far what could be improved in
> my
> book moving forward to RS 2005. I actually posted a blog to solicit some
> input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
> it's been a voice in the desert. Not even a curse! There must be something
> wrong here... Don't you guys read my blog or what? :-)
> Seriously, everyone that cares about my writings, please take moment to
> drop
> me an e-mail or add a feedback to the blog link and let me know your
> thoughts around the questions I listed in the Road Ahead blog.
> Thank you in advance,
> ---
> 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/
> ---
> "Brendon Schwartz" <nomail@.workinghard.com> wrote in message
> news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
>> This book has a great section on Advanced reporting that covers reporting
>> off of an ADO.NET dataset and a custom security log on for Windows Forms.
>> Teo also gave a great presentation at the .NET user group and the SQL
> Server
>> user group in Atlanta, I could only find the slides and code on the SQL
>> Server group:
> http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
>> . This book has helped me thousands of times and it is one of the better
>> books on drilling down into Reporting Services.
>> Brendon Schwartz
>> http://weblogs.cerkit.com/regularguys
>>
>> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
>> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>> >I posted an excerpt from my book "Microsoft Reporting Services in
>> >Action"
>> >on
>> > the TheServerSide.net
>> >
> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
>> > The article discusses how developers can implement a custom dataset
>> > data
>> > extension to report off ADO.NET datasets.
>> >
>> >
>> > ---
>> > 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/
>> > ---
>> >
>> >
>>
>|||Does clicking on the Refresh Fields button help? You could get more
troubleshooting tips from the log on GotDotNet.com
(http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5)
--
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/
---
"Tarik Peterson" <tarikp@.investigo.net> wrote in message
news:udixGjA9EHA.368@.TK2MSFTNGP10.phx.gbl...
> Teo,
> I am currently trying to implement your dataset data extension and have
> encountered several issues, most of which I have gotten worked out.
> However, when I try to preview the report inside of VS.Net 2003, I get an
> error.
> The error states: An error has occurred during report processing. Object
> reference not set to an instance of an object.
> Any ideas?
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:OrynjDb2EHA.1076@.TK2MSFTNGP09.phx.gbl...
>> Thanks for liking my book, Brendon.
>> To use this occasion, I would really appreciate it if I could get some
>> feedback from the RS technical community as far what could be improved in
>> my
>> book moving forward to RS 2005. I actually posted a blog to solicit some
>> input(http://prologika.com/blog/archive/2004/11/21/185.aspx), but so far
>> it's been a voice in the desert. Not even a curse! There must be
>> something
>> wrong here... Don't you guys read my blog or what? :-)
>> Seriously, everyone that cares about my writings, please take moment to
>> drop
>> me an e-mail or add a feedback to the blog link and let me know your
>> thoughts around the questions I listed in the Road Ahead blog.
>> Thank you in advance,
>> ---
>> 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/
>> ---
>> "Brendon Schwartz" <nomail@.workinghard.com> wrote in message
>> news:OBKLtqa2EHA.3000@.TK2MSFTNGP15.phx.gbl...
>> This book has a great section on Advanced reporting that covers
>> reporting
>> off of an ADO.NET dataset and a custom security log on for Windows
>> Forms.
>> Teo also gave a great presentation at the .NET user group and the SQL
>> Server
>> user group in Atlanta, I could only find the slides and code on the SQL
>> Server group:
>> http://www.atlantamdf.com/Presentations/AtlantaMDF_101104.zip
>> . This book has helped me thousands of times and it is one of the
>> better
>> books on drilling down into Reporting Services.
>> Brendon Schwartz
>> http://weblogs.cerkit.com/regularguys
>>
>> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
>> news:uBp9Wga2EHA.4028@.TK2MSFTNGP15.phx.gbl...
>> >I posted an excerpt from my book "Microsoft Reporting Services in
>> >Action"
>> >on
>> > the TheServerSide.net
>> >
>> (http://www.theserverside.net/books/manning/ReportingServices/index.tss).
>> > The article discusses how developers can implement a custom dataset
>> > data
>> > extension to report off ADO.NET datasets.
>> >
>> >
>> > ---
>> > 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/
>> > ---
>> >
>> >
>>
>>
>
Custom data processing extension with dataset
I have been getting to grips with writing a custom data processing extension for using a supplied dataset. I have got it working OK so far, but I don't see how to make use of relational data. There's plenty of code for walking through the fields, but nothing to walk through the tables. Since this clearly has to be possible can someone tell me where I'm going wrong?
Thanks
John Williams.
John,A CustomReportItem only has one reporting services dataset, which is only a single table, so there are no tables to walk through.
Ian|||
This seems extraordinary! Is there really no way of reporting on more complex data when using a data processing extension?
I suppose theoretically it might be possible to write one dpx for each table, using one table in the main report and one in a sub-report, etc. But when running the reports how would you pass the dataset across ensuring that each dpx received the data that it needed?
We were hoping to use SSRS as a drop in replacement for Crystal Reports, but this is a major blow as it will mean extensive rewriting of our application in order to store the data in to temporary tables in SQL server in order to report on it, and then delete the data afterwards.
|||
Each subreport has its own datasets, separate from the main report's datasets. It is just that you can only have one dataset per data region.
Ian
Custom Data Pre-Processing
Is there anyway I can send report properties to a custom
assembly which does all the work and passes back a dataset
that I can then bind to a report?
I've got to do some extensive pre-processing of the data,
which I couldnt really do with sql query alone, but I'd
still like to take advantage of all the other benefits of
sql reporting services.
Thanks in advance,
Weston WeemsYes, I think you can do this by writing a "Data Processing Extension" to
Reporting Services. There are examples and documentation in RS books on
line...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Weston Weems" <anonymous@.discussions.microsoft.com> wrote in message
news:05fd01c4f426$138c6880$a301280a@.phx.gbl...
> Is there anyway I can send report properties to a custom
> assembly which does all the work and passes back a dataset
> that I can then bind to a report?
> I've got to do some extensive pre-processing of the data,
> which I couldnt really do with sql query alone, but I'd
> still like to take advantage of all the other benefits of
> sql reporting services.
> Thanks in advance,
> Weston Weems
assembly which does all the work and passes back a dataset
that I can then bind to a report?
I've got to do some extensive pre-processing of the data,
which I couldnt really do with sql query alone, but I'd
still like to take advantage of all the other benefits of
sql reporting services.
Thanks in advance,
Weston WeemsYes, I think you can do this by writing a "Data Processing Extension" to
Reporting Services. There are examples and documentation in RS books on
line...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Weston Weems" <anonymous@.discussions.microsoft.com> wrote in message
news:05fd01c4f426$138c6880$a301280a@.phx.gbl...
> Is there anyway I can send report properties to a custom
> assembly which does all the work and passes back a dataset
> that I can then bind to a report?
> I've got to do some extensive pre-processing of the data,
> which I couldnt really do with sql query alone, but I'd
> still like to take advantage of all the other benefits of
> sql reporting services.
> Thanks in advance,
> Weston Weems
Saturday, February 25, 2012
Custom Data Extensions Previewing Report
I have created a custom Data extension that returns a dataset through
a datareader. I am attempting to create a report using this extension
as the datasource and am receiving an error when trying to view the
report in Preview. The error is saying it can not find my extension
Datasource.
Any ideas on how to fix this? Or any reasons why this is occuring?
Thanks,
JerryJerry wrote:
> report in Preview. The error is saying it can not find my extension
> Datasource.
Check out this[0] article, especially about 3/4 of the way down under
"deploying the extension". I'm betting your missing a config file
modification.
[0]
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/rsdsetex3.asp
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
a datareader. I am attempting to create a report using this extension
as the datasource and am receiving an error when trying to view the
report in Preview. The error is saying it can not find my extension
Datasource.
Any ideas on how to fix this? Or any reasons why this is occuring?
Thanks,
JerryJerry wrote:
> report in Preview. The error is saying it can not find my extension
> Datasource.
Check out this[0] article, especially about 3/4 of the way down under
"deploying the extension". I'm betting your missing a config file
modification.
[0]
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/rsdsetex3.asp
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
Custom Data Ext. Query Editor trouble
I created a custom data extension for reporting services in C#.
The CDE implements a dataset with one datatable now but I can't get it to
display in the query editor in the data tab of the report designer.
Any ideas on what needs to be done to expose it and additional data tables
to the query editor for some easy point and click query building?
thanksHave you added to required entries into the RSReportDesigner.config and
RSReportServer.config?
"paul" wrote:
> I created a custom data extension for reporting services in C#.
> The CDE implements a dataset with one datatable now but I can't get it to
> display in the query editor in the data tab of the report designer.
> Any ideas on what needs to be done to expose it and additional data tables
> to the query editor for some easy point and click query building?
> thanks|||Thanks for the reply.
I did add the necessary entries to the rsreportdesigner.config file.
For viewing the report in VS2005 though, both in the data and preview panes,
I'm not sure why I'd need to add any entries to the rsreportserver.config
file?
"SvdSinner" wrote:
> Have you added to required entries into the RSReportDesigner.config and
> RSReportServer.config?
> "paul" wrote:
> > I created a custom data extension for reporting services in C#.
> >
> > The CDE implements a dataset with one datatable now but I can't get it to
> > display in the query editor in the data tab of the report designer.
> >
> > Any ideas on what needs to be done to expose it and additional data tables
> > to the query editor for some easy point and click query building?
> >
> > thanks
The CDE implements a dataset with one datatable now but I can't get it to
display in the query editor in the data tab of the report designer.
Any ideas on what needs to be done to expose it and additional data tables
to the query editor for some easy point and click query building?
thanksHave you added to required entries into the RSReportDesigner.config and
RSReportServer.config?
"paul" wrote:
> I created a custom data extension for reporting services in C#.
> The CDE implements a dataset with one datatable now but I can't get it to
> display in the query editor in the data tab of the report designer.
> Any ideas on what needs to be done to expose it and additional data tables
> to the query editor for some easy point and click query building?
> thanks|||Thanks for the reply.
I did add the necessary entries to the rsreportdesigner.config file.
For viewing the report in VS2005 though, both in the data and preview panes,
I'm not sure why I'd need to add any entries to the rsreportserver.config
file?
"SvdSinner" wrote:
> Have you added to required entries into the RSReportDesigner.config and
> RSReportServer.config?
> "paul" wrote:
> > I created a custom data extension for reporting services in C#.
> >
> > The CDE implements a dataset with one datatable now but I can't get it to
> > display in the query editor in the data tab of the report designer.
> >
> > Any ideas on what needs to be done to expose it and additional data tables
> > to the query editor for some easy point and click query building?
> >
> > thanks
Friday, February 24, 2012
Custom Code accessing Dataset
Hello
my problem is this ...i pass a parameter from an asp page to open a report which works fine, however the display name for the text box in the header of the report should be the description of the parameter not the parameter id
i would like to create a function in the custom code that passes the parameter id and returns the parameter description as the possible description values are dynamic and there are over 400 hardcoding the code is not an option
thanks in advance for any advice
I'm not clear on what you are reffering to as "parameter description"? A report parameter will have three values accessible through either custom code or through a report expression: Value, Label, and IsMultiValue. If the "parameter description" is something defeined outside of the report you can access it in cusom code just as you could in any other .NET code.
Thanks, Jon
|||
You mean that you have a parameter which includes description as text and ID as value?
You should be able to query this in the way described here:
http://msdn2.microsoft.com/en-us/library/ms157274.aspx
The Parameters collection contains the report parameter objects within the report. Parameters can be passed to queries, used in filters, or used in other functions that alter the report appearance and content based on the parameter. When you define query parameters, they are automatically added to the report parameter collection. The following table describes the properties defined on a Parameter: Count, IsMultiValue, Value and Label.
Count
An integer that indicates the number of parameters in the collection.
IsMultiValue
A Boolean that identifies this parameter as having a set of values.
Value
The value for the parameter. For a multivalued parameter, Value returns an array of objects.
Label
A user-friendly label for the parameter. If no label is specified, the value of the Label property equals the Value property. If more than one Label is associated with the same Value, the first matching Label is used. For a multivalued parameter, Label returns an array of objects.
Parameters can be accessed through either the property syntax or the collection syntax. The following expression shows how to access every member of the Parameters collection and, when placed in a text box in a report item, displays the contents of the parameter ProductSubCategory.
So a proper expression for e.g. a parameter called Product would be:
Parameters!Product.Label
cheers,
Markus
Custom Code & Dataset (Reporting Services 2007)
Hi,
Can you pass a DataSet into the custom code?
If so are there any examples
ThanksThis is the same in RS 2008 as RS 2005. The answer is no, you cannot pass a
dataset into custom code. Your custom code can be called for each detail
line though.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Jacks" <AndrewJacks@.discussions.microsoft.com> wrote in message
news:D7866039-0E38-4FF9-BA3A-D3601825FA0B@.microsoft.com...
> Hi,
> Can you pass a DataSet into the custom code?
> If so are there any examples
> Thanks|||Bruce,
Thanks for the feedback.
Just trying to pass a value from a row and return a value from data i
already have in another dataset (One dataset being reported from via SQL the
other dataset has data from Sharepoint) and I need to join them together.
Stumbling around looking for solutions
"Bruce L-C [MVP]" wrote:
> This is the same in RS 2008 as RS 2005. The answer is no, you cannot pass a
> dataset into custom code. Your custom code can be called for each detail
> line though.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Andrew Jacks" <AndrewJacks@.discussions.microsoft.com> wrote in message
> news:D7866039-0E38-4FF9-BA3A-D3601825FA0B@.microsoft.com...
> > Hi,
> >
> > Can you pass a DataSet into the custom code?
> >
> > If so are there any examples
> > Thanks
>
>
Can you pass a DataSet into the custom code?
If so are there any examples
ThanksThis is the same in RS 2008 as RS 2005. The answer is no, you cannot pass a
dataset into custom code. Your custom code can be called for each detail
line though.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Jacks" <AndrewJacks@.discussions.microsoft.com> wrote in message
news:D7866039-0E38-4FF9-BA3A-D3601825FA0B@.microsoft.com...
> Hi,
> Can you pass a DataSet into the custom code?
> If so are there any examples
> Thanks|||Bruce,
Thanks for the feedback.
Just trying to pass a value from a row and return a value from data i
already have in another dataset (One dataset being reported from via SQL the
other dataset has data from Sharepoint) and I need to join them together.
Stumbling around looking for solutions
"Bruce L-C [MVP]" wrote:
> This is the same in RS 2008 as RS 2005. The answer is no, you cannot pass a
> dataset into custom code. Your custom code can be called for each detail
> line though.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Andrew Jacks" <AndrewJacks@.discussions.microsoft.com> wrote in message
> news:D7866039-0E38-4FF9-BA3A-D3601825FA0B@.microsoft.com...
> > Hi,
> >
> > Can you pass a DataSet into the custom code?
> >
> > If so are there any examples
> > Thanks
>
>
Subscribe to:
Posts (Atom)