Salakhetdinov Shamil
mcp2004 at mail.ru
Fri Apr 10 14:30:00 CDT 2009
Hi Gustav, Yes, it's a powerful reports generation tool/environment. I prefer to not use Wizard at all as dragging and dropping fields from Datasets window is quick enough for rought outlining of a report with Table control already dropped on it. Note for Mike: ================= Please note that Table control sections' rows can be inserted above and below the current default row for all the sections: - detail, header, footer, group (when you introduce it/them). And you can merge adjacent cells etc. - first make layout as close as possible to the final layout by inseting rows and merging cells, then drag and drop dataset's(s') fields on table's cells... You can have several tables in one report each driven by its own dataset - that would be as having several detail sections. You cn suppress output of Table control's detail, header, footer, group rows... You can repeat table's header or group rows on new page, you can set property to insert page breaks on group footer output etc. ... ================= BTW, I have never developed *parameterized* MS ReportViewer control reports bound to *ADO.NET datasets* - I have only developed parameterized reports for MS SQL 2005 Reporting Services and for ASP.NET 2.0 but using MS SQL DataSources - I mean this kind of MS ReportViewer control reports' binding is new for me, and this time I expect to learn from you and Mike how to make them developed :) I must say I have also never used MS ReportViewer subreports - there was no need, and reports I developed were rather complex... I'd also note that when using ReportViewer Control one can experience VS2008 crashes - just accept it as inevitable fact... Thank you. -- Shamil -----Original Message----- From: "Gustav Brock" <Gustav at cactus.dk> To: <dba-vb at databaseadvisors.com> Date: Fri, 10 Apr 2009 20:22:31 +0200 Subject: Re: [dba-VB] SCRUM: Please use CodePlex Northwind.NET sources as > Hi Shamil and Mike > > That's fine - but I can add that the first reports I made were heavily assisted by the wizard you can select to use - makes at least some data to be presented initially which otherwise can be quite hard at the beginning when you try to find up and down of the designer. > > Further, many features are "hidden" - you have to right-click here and there to have a popup menu with a lot of interesting options - like page header and footer. The properties pane only displays a fraction of the options. > > Also, coming from Access, you wonder where the Details section is. At takes a little while for you to realize that everything like that is lists or tables. But it all adds up to a very powerful environment. > > /gustav > > > >>> Salakhetdinov Shamil <mcp2004 at mail.ru> 10-04-2009 20:10:00 >>> > > Hi Mike, > > Please ask any questions on how to make the "Invoice" report. > > Please do the report parameterized by Order.ID (in the case Order.ID is NULL all the invoices should be output to the report). > > Sorry, no time to prepare another tutorial: basically this Invoice report is expected to be rather simple stuff to develop (when one makes such reports regularily) but when one starts doing them they could have some tough times especially if they come with MS Access reporting experience: > > - the Invoice report is expected to use MS ReportViewer's Table control with one group with header and footer. > > For report' logo you can use NorthwindTradersLogoForOrderForm.jpg from \Resources subfolder (make it embedded into report by using MS ReportViewer's Image control) > > Please ask any questions. > > Gistav, please correct me if I'm wrong with something I have written above, please add your notes (if any) to help Mark to make his first(?) MS ReportViewer report... > > Thank you. > > -- > Shamil > > > -----Original Message----- > From: "Mike Mattys" <mmattys at rochester.rr.com> > To: "Salakhetdinov Shamil" <mcp2004 at mail.ru>,"Discussion concerning Visual Basic and related programming issues." <dba-vb at databaseadvisors.com> > Date: Thu, 9 Apr 2009 14:44:25 -0400 > Subject: Re: [dba-VB]SCRUM: Please use CodePlex Northwind.NET sources as > > > Hi Shamil & SCRUM Team, > > > > I'll choose the Invoice. > > > > - > > Michael R Mattys > >MapPoint and Database Dev > > www.mattysconsulting.com > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com >