| Groups | Blog | Home |
vb.net data : Some Dataset advice please
Chapter 16? in my new book, you can choose to join the tables in a SELECT to provide a single rowset on which to report or return several rowsets from separate queries. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Vayse" <vvv> wrote in message news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... > Hi > I have a report in a report viewer control, based on Clients dataset. The > fields are like this > ClientName > ClientID > LastYearPremium > RenewalDate > > My report would display all renewals due in a particulat month, say Jan > 2007. Works fine. > These clients pay an annual premium, and some pay in advance. So they may > have an entry in the Transactions table. I'd like to add another field to > my report, which would show how much they paid this year. > Whats the best way to do this? > Is there a way to link up two datatables, and use that as the basis for my > report? Or I could add just loop through the clients dataset in code, and > search for an entry in the specified month - but I reckon that would be a > bit slow. > > I'm using SQL Server 2000 and Vb.net 2005. > > Thanks > Vayse >
Hi
I have a report in a report viewer control, based on Clients dataset. The fields are like this ClientName ClientID LastYearPremium RenewalDate My report would display all renewals due in a particulat month, say Jan 2007. Works fine. These clients pay an annual premium, and some pay in advance. So they may have an entry in the Transactions table. I'd like to add another field to my report, which would show how much they paid this year. Whats the best way to do this? Is there a way to link up two datatables, and use that as the basis for my report? Or I could add just loop through the clients dataset in code, and search for an entry in the specified month - but I reckon that would be a bit slow. I'm using SQL Server 2000 and Vb.net 2005. Thanks Vayse
Since I don't have your book to hand, could you provide a sample of what you
mean? [quoted text, click to view] "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >A report can be sourced from any number of data sources. As I describe in >Chapter 16? in my new book, you can choose to join the tables in a SELECT >to provide a single rowset on which to report or return several rowsets >from separate queries. > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no > rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > ----------------------------------------------------------------------------------------------------------------------- > > "Vayse" <vvv> wrote in message > news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >> Hi >> I have a report in a report viewer control, based on Clients dataset. The >> fields are like this >> ClientName >> ClientID >> LastYearPremium >> RenewalDate >> >> My report would display all renewals due in a particulat month, say Jan >> 2007. Works fine. >> These clients pay an annual premium, and some pay in advance. So they may >> have an entry in the Transactions table. I'd like to add another field to >> my report, which would show how much they paid this year. >> Whats the best way to do this? >> Is there a way to link up two datatables, and use that as the basis for >> my report? Or I could add just loop through the clients dataset in code, >> and search for an entry in the specified month - but I reckon that would >> be a bit slow. >> >> I'm using SQL Server 2000 and Vb.net 2005. >> >> Thanks >> Vayse >> > >
So, you just spent the last 2+ years working on a new project. Would you
like to hand it out for free to anyone who asks? In this case, I expect the (rather long) chapter on Reporting would have to read almost in its entirety to get a good understanding of the ReportViewer control. What you're asking for cannot be sent in a short email... -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Vayse" <vvv> wrote in message news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... > Since I don't have your book to hand, could you provide a sample of what > you mean? > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>A report can be sourced from any number of data sources. As I describe in >>Chapter 16? in my new book, you can choose to join the tables in a SELECT >>to provide a single rowset on which to report or return several rowsets >>from separate queries. >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> Visit www.hitchhikerguides.net to get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >> ----------------------------------------------------------------------------------------------------------------------- >> >> "Vayse" <vvv> wrote in message >> news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >>> Hi >>> I have a report in a report viewer control, based on Clients dataset. >>> The fields are like this >>> ClientName >>> ClientID >>> LastYearPremium >>> RenewalDate >>> >>> My report would display all renewals due in a particulat month, say Jan >>> 2007. Works fine. >>> These clients pay an annual premium, and some pay in advance. So they >>> may have an entry in the Transactions table. I'd like to add another >>> field to my report, which would show how much they paid this year. >>> Whats the best way to do this? >>> Is there a way to link up two datatables, and use that as the basis for >>> my report? Or I could add just loop through the clients dataset in code, >>> and search for an entry in the specified month - but I reckon that would >>> be a bit slow. >>> >>> I'm using SQL Server 2000 and Vb.net 2005. >>> >>> Thanks >>> Vayse >>> >> >> > >
According to http://www.hitchhikerguides.net/BookVS2005/TOC/default.aspx
there are only 15 chapters in your new book, so I'm sure you can understand why I'm not rushing off to buy a book for a mysterious chapter16! Still, I guess I'll have to buy it, as it seems my only option at the moment. [quoted text, click to view] "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message news:uxrO6rUHHHA.420@TK2MSFTNGP02.phx.gbl... > So, you just spent the last 2+ years working on a new project. Would you > like to hand it out for free to anyone who asks? In this case, I expect > the (rather long) chapter on Reporting would have to read almost in its > entirety to get a good understanding of the ReportViewer control. What > you're asking for cannot be sent in a short email... > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no > rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > ----------------------------------------------------------------------------------------------------------------------- > > "Vayse" <vvv> wrote in message > news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... >> Since I don't have your book to hand, could you provide a sample of what >> you mean? >> >> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >> news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>>A report can be sourced from any number of data sources. As I describe in >>>Chapter 16? in my new book, you can choose to join the tables in a SELECT >>>to provide a single rowset on which to report or return several rowsets >>>from separate queries. >>> >>> -- >>> ____________________________________ >>> William (Bill) Vaughn >>> Author, Mentor, Consultant >>> Microsoft MVP >>> INETA Speaker >>> www.betav.com/blog/billva >>> www.betav.com >>> Please reply only to the newsgroup so that others can benefit. >>> This posting is provided "AS IS" with no warranties, and confers no >>> rights. >>> __________________________________ >>> Visit www.hitchhikerguides.net to get more information on my latest >>> book: >>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>> ----------------------------------------------------------------------------------------------------------------------- >>> >>> "Vayse" <vvv> wrote in message >>> news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >>>> Hi >>>> I have a report in a report viewer control, based on Clients dataset. >>>> The fields are like this >>>> ClientName >>>> ClientID >>>> LastYearPremium >>>> RenewalDate >>>> >>>> My report would display all renewals due in a particulat month, say Jan >>>> 2007. Works fine. >>>> These clients pay an annual premium, and some pay in advance. So they >>>> may have an entry in the Transactions table. I'd like to add another >>>> field to my report, which would show how much they paid this year. >>>> Whats the best way to do this? >>>> Is there a way to link up two datatables, and use that as the basis for >>>> my report? Or I could add just loop through the clients dataset in >>>> code, and search for an entry in the specified month - but I reckon >>>> that would be a bit slow. >>>> >>>> I'm using SQL Server 2000 and Vb.net 2005. >>>> >>>> Thanks >>>> Vayse >>>> >>> >>> >> >> > >
Sorry, you're right. It was Chapter 16 but we combined two really long CLR
Executables chapters into one humongous chapter which pulled Chapter 16 down to 15. If you still have questions after buying it, get up on the book's support site and ask your question again. I check there first every day... -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Vayse" <vvv> wrote in message news:O8TuWqdHHHA.1264@TK2MSFTNGP03.phx.gbl... > According to http://www.hitchhikerguides.net/BookVS2005/TOC/default.aspx > there are only 15 chapters in your new book, so I'm sure you can > understand why I'm not rushing off to buy a book for a mysterious > chapter16! > Still, I guess I'll have to buy it, as it seems my only option at the > moment. > > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > news:uxrO6rUHHHA.420@TK2MSFTNGP02.phx.gbl... >> So, you just spent the last 2+ years working on a new project. Would you >> like to hand it out for free to anyone who asks? In this case, I expect >> the (rather long) chapter on Reporting would have to read almost in its >> entirety to get a good understanding of the ReportViewer control. What >> you're asking for cannot be sent in a short email... >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> Visit www.hitchhikerguides.net to get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >> ----------------------------------------------------------------------------------------------------------------------- >> >> "Vayse" <vvv> wrote in message >> news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... >>> Since I don't have your book to hand, could you provide a sample of what >>> you mean? >>> >>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>> news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>>>A report can be sourced from any number of data sources. As I describe >>>>in Chapter 16? in my new book, you can choose to join the tables in a >>>>SELECT to provide a single rowset on which to report or return several >>>>rowsets from separate queries. >>>> >>>> -- >>>> ____________________________________ >>>> William (Bill) Vaughn >>>> Author, Mentor, Consultant >>>> Microsoft MVP >>>> INETA Speaker >>>> www.betav.com/blog/billva >>>> www.betav.com >>>> Please reply only to the newsgroup so that others can benefit. >>>> This posting is provided "AS IS" with no warranties, and confers no >>>> rights. >>>> __________________________________ >>>> Visit www.hitchhikerguides.net to get more information on my latest >>>> book: >>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>> ----------------------------------------------------------------------------------------------------------------------- >>>> >>>> "Vayse" <vvv> wrote in message >>>> news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >>>>> Hi >>>>> I have a report in a report viewer control, based on Clients dataset. >>>>> The fields are like this >>>>> ClientName >>>>> ClientID >>>>> LastYearPremium >>>>> RenewalDate >>>>> >>>>> My report would display all renewals due in a particulat month, say >>>>> Jan 2007. Works fine. >>>>> These clients pay an annual premium, and some pay in advance. So they >>>>> may have an entry in the Transactions table. I'd like to add another >>>>> field to my report, which would show how much they paid this year. >>>>> Whats the best way to do this? >>>>> Is there a way to link up two datatables, and use that as the basis >>>>> for my report? Or I could add just loop through the clients dataset in >>>>> code, and search for an entry in the specified month - but I reckon >>>>> that would be a bit slow. >>>>> >>>>> I'm using SQL Server 2000 and Vb.net 2005. >>>>> >>>>> Thanks >>>>> Vayse >>>>> >>>> >>>> >>> >>> >> >> > >
Your book is on the way to me, so if I'm still confused after reading it,
expect a post from me on your site! Thanks Vayse [quoted text, click to view] "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message news:uGoNVViHHHA.924@TK2MSFTNGP02.phx.gbl... > Sorry, you're right. It was Chapter 16 but we combined two really long CLR > Executables chapters into one humongous chapter which pulled Chapter 16 > down to 15. If you still have questions after buying it, get up on the > book's support site and ask your question again. I check there first every > day... > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no > rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > ----------------------------------------------------------------------------------------------------------------------- > > "Vayse" <vvv> wrote in message > news:O8TuWqdHHHA.1264@TK2MSFTNGP03.phx.gbl... >> According to http://www.hitchhikerguides.net/BookVS2005/TOC/default.aspx >> there are only 15 chapters in your new book, so I'm sure you can >> understand why I'm not rushing off to buy a book for a mysterious >> chapter16! >> Still, I guess I'll have to buy it, as it seems my only option at the >> moment. >> >> >> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >> news:uxrO6rUHHHA.420@TK2MSFTNGP02.phx.gbl... >>> So, you just spent the last 2+ years working on a new project. Would you >>> like to hand it out for free to anyone who asks? In this case, I expect >>> the (rather long) chapter on Reporting would have to read almost in its >>> entirety to get a good understanding of the ReportViewer control. What >>> you're asking for cannot be sent in a short email... >>> >>> -- >>> ____________________________________ >>> William (Bill) Vaughn >>> Author, Mentor, Consultant >>> Microsoft MVP >>> INETA Speaker >>> www.betav.com/blog/billva >>> www.betav.com >>> Please reply only to the newsgroup so that others can benefit. >>> This posting is provided "AS IS" with no warranties, and confers no >>> rights. >>> __________________________________ >>> Visit www.hitchhikerguides.net to get more information on my latest >>> book: >>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>> ----------------------------------------------------------------------------------------------------------------------- >>> >>> "Vayse" <vvv> wrote in message >>> news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... >>>> Since I don't have your book to hand, could you provide a sample of >>>> what you mean? >>>> >>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>>> news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>>>>A report can be sourced from any number of data sources. As I describe >>>>>in Chapter 16? in my new book, you can choose to join the tables in a >>>>>SELECT to provide a single rowset on which to report or return several >>>>>rowsets from separate queries. >>>>> >>>>> -- >>>>> ____________________________________ >>>>> William (Bill) Vaughn >>>>> Author, Mentor, Consultant >>>>> Microsoft MVP >>>>> INETA Speaker >>>>> www.betav.com/blog/billva >>>>> www.betav.com >>>>> Please reply only to the newsgroup so that others can benefit. >>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>> rights. >>>>> __________________________________ >>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>> book: >>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>> >>>>> "Vayse" <vvv> wrote in message >>>>> news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >>>>>> Hi >>>>>> I have a report in a report viewer control, based on Clients dataset. >>>>>> The fields are like this >>>>>> ClientName >>>>>> ClientID >>>>>> LastYearPremium >>>>>> RenewalDate >>>>>> >>>>>> My report would display all renewals due in a particulat month, say >>>>>> Jan 2007. Works fine. >>>>>> These clients pay an annual premium, and some pay in advance. So they >>>>>> may have an entry in the Transactions table. I'd like to add another >>>>>> field to my report, which would show how much they paid this year. >>>>>> Whats the best way to do this? >>>>>> Is there a way to link up two datatables, and use that as the basis >>>>>> for my report? Or I could add just loop through the clients dataset >>>>>> in code, and search for an entry in the specified month - but I >>>>>> reckon that would be a bit slow. >>>>>> >>>>>> I'm using SQL Server 2000 and Vb.net 2005. >>>>>> >>>>>> Thanks >>>>>> Vayse >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Guess you must be popular here in Ireland, as the book is actually sold out,
and I have to wait until next week for more stock to come in. [quoted text, click to view] "Vayse" <vvv> wrote in message news:Oym3cr2HHHA.1252@TK2MSFTNGP02.phx.gbl... > Your book is on the way to me, so if I'm still confused after reading it, > expect a post from me on your site! > Thanks > Vayse > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > news:uGoNVViHHHA.924@TK2MSFTNGP02.phx.gbl... >> Sorry, you're right. It was Chapter 16 but we combined two really long >> CLR Executables chapters into one humongous chapter which pulled Chapter >> 16 down to 15. If you still have questions after buying it, get up on the >> book's support site and ask your question again. I check there first >> every day... >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> Visit www.hitchhikerguides.net to get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >> ----------------------------------------------------------------------------------------------------------------------- >> >> "Vayse" <vvv> wrote in message >> news:O8TuWqdHHHA.1264@TK2MSFTNGP03.phx.gbl... >>> According to http://www.hitchhikerguides.net/BookVS2005/TOC/default.aspx >>> there are only 15 chapters in your new book, so I'm sure you can >>> understand why I'm not rushing off to buy a book for a mysterious >>> chapter16! >>> Still, I guess I'll have to buy it, as it seems my only option at the >>> moment. >>> >>> >>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>> news:uxrO6rUHHHA.420@TK2MSFTNGP02.phx.gbl... >>>> So, you just spent the last 2+ years working on a new project. Would >>>> you like to hand it out for free to anyone who asks? In this case, I >>>> expect the (rather long) chapter on Reporting would have to read almost >>>> in its entirety to get a good understanding of the ReportViewer >>>> control. What you're asking for cannot be sent in a short email... >>>> >>>> -- >>>> ____________________________________ >>>> William (Bill) Vaughn >>>> Author, Mentor, Consultant >>>> Microsoft MVP >>>> INETA Speaker >>>> www.betav.com/blog/billva >>>> www.betav.com >>>> Please reply only to the newsgroup so that others can benefit. >>>> This posting is provided "AS IS" with no warranties, and confers no >>>> rights. >>>> __________________________________ >>>> Visit www.hitchhikerguides.net to get more information on my latest >>>> book: >>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>> ----------------------------------------------------------------------------------------------------------------------- >>>> >>>> "Vayse" <vvv> wrote in message >>>> news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... >>>>> Since I don't have your book to hand, could you provide a sample of >>>>> what you mean? >>>>> >>>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>>>> news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>>>>>A report can be sourced from any number of data sources. As I describe >>>>>>in Chapter 16? in my new book, you can choose to join the tables in a >>>>>>SELECT to provide a single rowset on which to report or return several >>>>>>rowsets from separate queries. >>>>>> >>>>>> -- >>>>>> ____________________________________ >>>>>> William (Bill) Vaughn >>>>>> Author, Mentor, Consultant >>>>>> Microsoft MVP >>>>>> INETA Speaker >>>>>> www.betav.com/blog/billva >>>>>> www.betav.com >>>>>> Please reply only to the newsgroup so that others can benefit. >>>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>>> rights. >>>>>> __________________________________ >>>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>>> book: >>>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>>> >>>>>> "Vayse" <vvv> wrote in message >>>>>> news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >>>>>>> Hi >>>>>>> I have a report in a report viewer control, based on Clients >>>>>>> dataset. The fields are like this >>>>>>> ClientName >>>>>>> ClientID >>>>>>> LastYearPremium >>>>>>> RenewalDate >>>>>>> >>>>>>> My report would display all renewals due in a particulat month, say >>>>>>> Jan 2007. Works fine. >>>>>>> These clients pay an annual premium, and some pay in advance. So >>>>>>> they may have an entry in the Transactions table. I'd like to add >>>>>>> another field to my report, which would show how much they paid this >>>>>>> year. >>>>>>> Whats the best way to do this? >>>>>>> Is there a way to link up two datatables, and use that as the basis >>>>>>> for my report? Or I could add just loop through the clients dataset >>>>>>> in code, and search for an entry in the specified month - but I >>>>>>> reckon that would be a bit slow. >>>>>>> >>>>>>> I'm using SQL Server 2000 and Vb.net 2005. >>>>>>> >>>>>>> Thanks >>>>>>> Vayse >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Hummm... It must be the jokes about Cleveland. ;)
I've been offline for 5 days due to the storm. Perhaps you'll have it by Christmas. The stores in the UK should carry stock... -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Vayse" <vvv> wrote in message news:OpWMomCIHHA.1264@TK2MSFTNGP03.phx.gbl... > Guess you must be popular here in Ireland, as the book is actually sold > out, and I have to wait until next week for more stock to come in. > > "Vayse" <vvv> wrote in message > news:Oym3cr2HHHA.1252@TK2MSFTNGP02.phx.gbl... >> Your book is on the way to me, so if I'm still confused after reading it, >> expect a post from me on your site! >> Thanks >> Vayse >> >> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >> news:uGoNVViHHHA.924@TK2MSFTNGP02.phx.gbl... >>> Sorry, you're right. It was Chapter 16 but we combined two really long >>> CLR Executables chapters into one humongous chapter which pulled Chapter >>> 16 down to 15. If you still have questions after buying it, get up on >>> the book's support site and ask your question again. I check there first >>> every day... >>> >>> -- >>> ____________________________________ >>> William (Bill) Vaughn >>> Author, Mentor, Consultant >>> Microsoft MVP >>> INETA Speaker >>> www.betav.com/blog/billva >>> www.betav.com >>> Please reply only to the newsgroup so that others can benefit. >>> This posting is provided "AS IS" with no warranties, and confers no >>> rights. >>> __________________________________ >>> Visit www.hitchhikerguides.net to get more information on my latest >>> book: >>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>> ----------------------------------------------------------------------------------------------------------------------- >>> >>> "Vayse" <vvv> wrote in message >>> news:O8TuWqdHHHA.1264@TK2MSFTNGP03.phx.gbl... >>>> According to >>>> http://www.hitchhikerguides.net/BookVS2005/TOC/default.aspx there are >>>> only 15 chapters in your new book, so I'm sure you can understand why >>>> I'm not rushing off to buy a book for a mysterious chapter16! >>>> Still, I guess I'll have to buy it, as it seems my only option at the >>>> moment. >>>> >>>> >>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>>> news:uxrO6rUHHHA.420@TK2MSFTNGP02.phx.gbl... >>>>> So, you just spent the last 2+ years working on a new project. Would >>>>> you like to hand it out for free to anyone who asks? In this case, I >>>>> expect the (rather long) chapter on Reporting would have to read >>>>> almost in its entirety to get a good understanding of the ReportViewer >>>>> control. What you're asking for cannot be sent in a short email... >>>>> >>>>> -- >>>>> ____________________________________ >>>>> William (Bill) Vaughn >>>>> Author, Mentor, Consultant >>>>> Microsoft MVP >>>>> INETA Speaker >>>>> www.betav.com/blog/billva >>>>> www.betav.com >>>>> Please reply only to the newsgroup so that others can benefit. >>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>> rights. >>>>> __________________________________ >>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>> book: >>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>> >>>>> "Vayse" <vvv> wrote in message >>>>> news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... >>>>>> Since I don't have your book to hand, could you provide a sample of >>>>>> what you mean? >>>>>> >>>>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in >>>>>> message news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>>>>>>A report can be sourced from any number of data sources. As I >>>>>>>describe in Chapter 16? in my new book, you can choose to join the >>>>>>>tables in a SELECT to provide a single rowset on which to report or >>>>>>>return several rowsets from separate queries. >>>>>>> >>>>>>> -- >>>>>>> ____________________________________ >>>>>>> William (Bill) Vaughn >>>>>>> Author, Mentor, Consultant >>>>>>> Microsoft MVP >>>>>>> INETA Speaker >>>>>>> www.betav.com/blog/billva >>>>>>> www.betav.com >>>>>>> Please reply only to the newsgroup so that others can benefit. >>>>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>>>> rights. >>>>>>> __________________________________ >>>>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>>>> book: >>>>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>>>> >>>>>>> "Vayse" <vvv> wrote in message >>>>>>> news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >>>>>>>> Hi >>>>>>>> I have a report in a report viewer control, based on Clients >>>>>>>> dataset. The fields are like this >>>>>>>> ClientName >>>>>>>> ClientID >>>>>>>> LastYearPremium >>>>>>>> RenewalDate >>>>>>>> >>>>>>>> My report would display all renewals due in a particulat month, say >>>>>>>> Jan 2007. Works fine. >>>>>>>> These clients pay an annual premium, and some pay in advance. So >>>>>>>> they may have an entry in the Transactions table. I'd like to add >>>>>>>> another field to my report, which would show how much they paid >>>>>>>> this year. >>>>>>>> Whats the best way to do this? >>>>>>>> Is there a way to link up two datatables, and use that as the basis >>>>>>>> for my report? Or I could add just loop through the clients dataset >>>>>>>> in code, and search for an entry in the specified month - but I >>>>>>>> reckon that would be a bit slow. >>>>>>>> >>>>>>>> I'm using SQL Server 2000 and Vb.net 2005. >>>>>>>> >>>>>>>> Thanks >>>>>>>> Vayse >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Postage from the UK costs more than the book itself!
Anyway, got it yesterday, have read a few chapters. I'll read some more before I post a question on this particular topic, but it looks good so far. [quoted text, click to view] "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:ukJSa38IHHA.4712@TK2MSFTNGP04.phx.gbl... > Hummm... It must be the jokes about Cleveland. ;) > I've been offline for 5 days due to the storm. Perhaps you'll have it by > Christmas. The stores in the UK should carry stock... > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no > rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > ----------------------------------------------------------------------------------------------------------------------- > > "Vayse" <vvv> wrote in message > news:OpWMomCIHHA.1264@TK2MSFTNGP03.phx.gbl... >> Guess you must be popular here in Ireland, as the book is actually sold >> out, and I have to wait until next week for more stock to come in. >> >> "Vayse" <vvv> wrote in message >> news:Oym3cr2HHHA.1252@TK2MSFTNGP02.phx.gbl... >>> Your book is on the way to me, so if I'm still confused after reading >>> it, expect a post from me on your site! >>> Thanks >>> Vayse >>> >>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>> news:uGoNVViHHHA.924@TK2MSFTNGP02.phx.gbl... >>>> Sorry, you're right. It was Chapter 16 but we combined two really long >>>> CLR Executables chapters into one humongous chapter which pulled >>>> Chapter 16 down to 15. If you still have questions after buying it, get >>>> up on the book's support site and ask your question again. I check >>>> there first every day... >>>> >>>> -- >>>> ____________________________________ >>>> William (Bill) Vaughn >>>> Author, Mentor, Consultant >>>> Microsoft MVP >>>> INETA Speaker >>>> www.betav.com/blog/billva >>>> www.betav.com >>>> Please reply only to the newsgroup so that others can benefit. >>>> This posting is provided "AS IS" with no warranties, and confers no >>>> rights. >>>> __________________________________ >>>> Visit www.hitchhikerguides.net to get more information on my latest >>>> book: >>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>> ----------------------------------------------------------------------------------------------------------------------- >>>> >>>> "Vayse" <vvv> wrote in message >>>> news:O8TuWqdHHHA.1264@TK2MSFTNGP03.phx.gbl... >>>>> According to >>>>> http://www.hitchhikerguides.net/BookVS2005/TOC/default.aspx there are >>>>> only 15 chapters in your new book, so I'm sure you can understand why >>>>> I'm not rushing off to buy a book for a mysterious chapter16! >>>>> Still, I guess I'll have to buy it, as it seems my only option at the >>>>> moment. >>>>> >>>>> >>>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>>>> news:uxrO6rUHHHA.420@TK2MSFTNGP02.phx.gbl... >>>>>> So, you just spent the last 2+ years working on a new project. Would >>>>>> you like to hand it out for free to anyone who asks? In this case, I >>>>>> expect the (rather long) chapter on Reporting would have to read >>>>>> almost in its entirety to get a good understanding of the >>>>>> ReportViewer control. What you're asking for cannot be sent in a >>>>>> short email... >>>>>> >>>>>> -- >>>>>> ____________________________________ >>>>>> William (Bill) Vaughn >>>>>> Author, Mentor, Consultant >>>>>> Microsoft MVP >>>>>> INETA Speaker >>>>>> www.betav.com/blog/billva >>>>>> www.betav.com >>>>>> Please reply only to the newsgroup so that others can benefit. >>>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>>> rights. >>>>>> __________________________________ >>>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>>> book: >>>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>>> >>>>>> "Vayse" <vvv> wrote in message >>>>>> news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... >>>>>>> Since I don't have your book to hand, could you provide a sample of >>>>>>> what you mean? >>>>>>> >>>>>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in >>>>>>> message news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>>>>>>>A report can be sourced from any number of data sources. As I >>>>>>>>describe in Chapter 16? in my new book, you can choose to join the >>>>>>>>tables in a SELECT to provide a single rowset on which to report or >>>>>>>>return several rowsets from separate queries. >>>>>>>> >>>>>>>> -- >>>>>>>> ____________________________________ >>>>>>>> William (Bill) Vaughn >>>>>>>> Author, Mentor, Consultant >>>>>>>> Microsoft MVP >>>>>>>> INETA Speaker >>>>>>>> www.betav.com/blog/billva >>>>>>>> www.betav.com >>>>>>>> Please reply only to the newsgroup so that others can benefit. >>>>>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>>>>> rights. >>>>>>>> __________________________________ >>>>>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>>>>> book: >>>>>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>>>>> >>>>>>>> "Vayse" <vvv> wrote in message >>>>>>>> news:urg6ewuGHHA.3468@TK2MSFTNGP04.phx.gbl... >>>>>>>>> Hi >>>>>>>>> I have a report in a report viewer control, based on Clients >>>>>>>>> dataset. The fields are like this >>>>>>>>> ClientName >>>>>>>>> ClientID >>>>>>>>> LastYearPremium >>>>>>>>> RenewalDate >>>>>>>>> >>>>>>>>> My report would display all renewals due in a particulat month, >>>>>>>>> say Jan 2007. Works fine. >>>>>>>>> These clients pay an annual premium, and some pay in advance. So >>>>>>>>> they may have an entry in the Transactions table. I'd like to add >>>>>>>>> another field to my report, which would show how much they paid >>>>>>>>> this year. >>>>>>>>> Whats the best way to do this? >>>>>>>>> Is there a way to link up two datatables, and use that as the
Great. If you like it, please post a review on Amazon. If you don't... ;)
If you have any questions, get up on the support site. I get notified immediately when someone asks a question there. I only get here a few times a week. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Vayse" <vvv> wrote in message news:e0WctjBJHHA.1468@TK2MSFTNGP04.phx.gbl...
> Postage from the UK costs more than the book itself! > Anyway, got it yesterday, have read a few chapters. I'll read some more > before I post a question on this particular topic, but it looks good so > far. > > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > news:ukJSa38IHHA.4712@TK2MSFTNGP04.phx.gbl... >> Hummm... It must be the jokes about Cleveland. ;) >> I've been offline for 5 days due to the storm. Perhaps you'll have it by >> Christmas. The stores in the UK should carry stock... >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> Visit www.hitchhikerguides.net to get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >> ----------------------------------------------------------------------------------------------------------------------- >> >> "Vayse" <vvv> wrote in message >> news:OpWMomCIHHA.1264@TK2MSFTNGP03.phx.gbl... >>> Guess you must be popular here in Ireland, as the book is actually sold >>> out, and I have to wait until next week for more stock to come in. >>> >>> "Vayse" <vvv> wrote in message >>> news:Oym3cr2HHHA.1252@TK2MSFTNGP02.phx.gbl... >>>> Your book is on the way to me, so if I'm still confused after reading >>>> it, expect a post from me on your site! >>>> Thanks >>>> Vayse >>>> >>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message >>>> news:uGoNVViHHHA.924@TK2MSFTNGP02.phx.gbl... >>>>> Sorry, you're right. It was Chapter 16 but we combined two really long >>>>> CLR Executables chapters into one humongous chapter which pulled >>>>> Chapter 16 down to 15. If you still have questions after buying it, >>>>> get up on the book's support site and ask your question again. I check >>>>> there first every day... >>>>> >>>>> -- >>>>> ____________________________________ >>>>> William (Bill) Vaughn >>>>> Author, Mentor, Consultant >>>>> Microsoft MVP >>>>> INETA Speaker >>>>> www.betav.com/blog/billva >>>>> www.betav.com >>>>> Please reply only to the newsgroup so that others can benefit. >>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>> rights. >>>>> __________________________________ >>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>> book: >>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>> >>>>> "Vayse" <vvv> wrote in message >>>>> news:O8TuWqdHHHA.1264@TK2MSFTNGP03.phx.gbl... >>>>>> According to >>>>>> http://www.hitchhikerguides.net/BookVS2005/TOC/default.aspx there are >>>>>> only 15 chapters in your new book, so I'm sure you can understand why >>>>>> I'm not rushing off to buy a book for a mysterious chapter16! >>>>>> Still, I guess I'll have to buy it, as it seems my only option at the >>>>>> moment. >>>>>> >>>>>> >>>>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in >>>>>> message news:uxrO6rUHHHA.420@TK2MSFTNGP02.phx.gbl... >>>>>>> So, you just spent the last 2+ years working on a new project. Would >>>>>>> you like to hand it out for free to anyone who asks? In this case, I >>>>>>> expect the (rather long) chapter on Reporting would have to read >>>>>>> almost in its entirety to get a good understanding of the >>>>>>> ReportViewer control. What you're asking for cannot be sent in a >>>>>>> short email... >>>>>>> >>>>>>> -- >>>>>>> ____________________________________ >>>>>>> William (Bill) Vaughn >>>>>>> Author, Mentor, Consultant >>>>>>> Microsoft MVP >>>>>>> INETA Speaker >>>>>>> www.betav.com/blog/billva >>>>>>> www.betav.com >>>>>>> Please reply only to the newsgroup so that others can benefit. >>>>>>> This posting is provided "AS IS" with no warranties, and confers no >>>>>>> rights. >>>>>>> __________________________________ >>>>>>> Visit www.hitchhikerguides.net to get more information on my latest >>>>>>> book: >>>>>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >>>>>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >>>>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>>>> >>>>>>> "Vayse" <vvv> wrote in message >>>>>>> news:Oy80xQQHHHA.536@TK2MSFTNGP02.phx.gbl... >>>>>>>> Since I don't have your book to hand, could you provide a sample of >>>>>>>> what you mean? >>>>>>>> >>>>>>>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in >>>>>>>> message news:emXj%23JvGHHA.420@TK2MSFTNGP02.phx.gbl... >>>>>>>>>A report can be sourced from any number of data sources. As I >>>>>>>>>describe in Chapter 16? in my new book, you can choose to join the >>>>>>>>>tables in a SELECT to provide a single rowset on which to report or >>>>>>>>>return several rowsets from separate queries. >>>>>>>>> >>>>>>>>> -- >>>>>>>>> ____________________________________ >>>>>>>>> William (Bill) Vaughn >>>>>>>>> Author, Mentor, Consultant >>>>>>>>> Microsoft MVP >>>>>>>>> INETA Speaker >>>>>>>>> www.betav.com/blog/billva >>>>>>>>> www.betav.com >>>>>>>>> Please reply only to the newsgroup so that others can benefit. >>>>>>>>> This posting is provided "AS IS" with no warranties, and confers >>>>>>>>> no rights. >>>>>>>>> __________________________________ >>>>>>>>> Visit www.hitchhikerguides.net to get more information on my
Don't see what you're looking for? Try a search.
|
February 2004
March 2004
April 2004
May 2004
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
| home · blog · groups | Questions? Comments? Contact the dn |