[dba-VB] SCRUM: Sprint - 2nd week plan

Hi SCRUM Team,

I have made the following reports:

- Alphabetical List of Products
- Product By Category

but the second one is not yet finished - looking for a way to make it multi-column. Any proposals?

Current solution is uploaded to the server.
Please always look at \!Documents\Notes.txt file after you update your code from server to find are there any new SQL scripts to apply - here is the current list:

0001_vw_CustomerOrdersProducts.sql
0002_vw_CustomerOrderTotals.sql
0003_vw_CustomerCountries.sql
0004_vw_AlphabeticalListOfProductsReport.sql

Please add your SQL scripts' file names to this list if you'll create some.

Please put all the scripts into \Datasets\SQL subfolder named using numeric prefix to have the scripts sorted inthe sequence they were created.

Please note how I made SimpleReportsDataSet to keep 'Alphabetical List of Products' and 'Product by Category' reports' sources. I used the same vw_AlphabeicalListOfProductsReport view for both reports but I have renamed table objects in dataset to allow in the future to substitute the database object e.g with stored procedure etc. without the need to rename anything in the code/forms/reports, which are using this dataset.

Thank you.

--
Shamil


-----Original Message-----
From: Salakhetdinov Shamil <mcp2004 at mail.ru>
To: "Discussion concerning Visual Basic and related programming issues."<dba-vb at databaseadvisors.com>
Date: Fri, 03 Apr 2009 03:22:44 +0400
Subject: Re: [dba-VB] SCRUM: Sprint - 2nd week plan

> Hi SCRUM team,
> 
> Thee three dialog froms are done, and committed to our SCC server as well as published within new source code set at CodePlex.
> 
> I will also take 'Product By Category' Report
> 
> Note: please create new views, SPs, UDFs for reports if the existing set tables, views, SPs, UDFs is not enough to develop reports. Please also create a new strongly typed dataset dedicated to a certain report in the case you create new views, SPs or UDFs for this report. Please put all the database objects you'll use in report in this dataset.
> 
> Forms
> ======
> 1  Customers Labels Dialog  => DONE
> 3  Customer Phone List      => Mike
> 2  Quaterly Order           => Gustav
> 2  Quaterly Orders Subform  => Gustav
> 1  Sales By Year Dialog         => DONE
> 2  Sales Reports Dialog         => DONE
> 
> Reports
> ========
> 2 Alphabetical List of Products
> 1 Product By Category      => Shamil
> 2 Sales Totals by Amount
> --------------------------------
> 16 hours
> 
> Thank you.
> 
> --
> Shamil
> 
> 
> -----Original Message-----
> From: Salakhetdinov Shamil <mcp2004 at mail.ru>
> To: "Discussion concerning Visual Basic and related programming issues."<dba-vb at databaseadvisors.com>
> Date: Fri, 03 Apr 2009 00:15:57 +0400
> Subject: Re: [dba-VB] SCRUM: Sprint - 2nd week plan
> 
> > Hi Gustav,
> > 
> > OK, please tell what report would you like to develop? (I will make all the dialog forms now - they are small - just to have them ready to be used to run other forms/reports):
> > 
> > Forms
> > ======
> > 1  Customers Labels Dialog    => Shamil
> > 3  Customer Phone List        => Mike
> > 2  Quaterly Order             => Gustav
> > 2  Quaterly Orders Subform    => Gustav
> > 1  Sales By Year Dialog       => Shamil 
> > 2  Sales Reports Dialog       => Shamil 
> > 
> > Reports
> > ========
> > 2 Alphabetical List of Products
> > 1 Product By Category
> > 2 Sales Totals by Amount
> > --------------------------------
> > 16 hours
> > 
> > Thank you.
> > 
> > --
> > Shamil
> > 
> > -----Original Message-----
> > From: "Gustav Brock" <Gustav at cactus.dk>
> > To: <dba-vb at databaseadvisors.com>
> > Date: Thu, 02 Apr 2009 18:09:23 +0200
> > Subject: Re: [dba-VB] SCRUM: Sprint - 2nd week plan
> > 
> > > Hi SCRUM Team
> > > 
> > > I could take, say, the Quarterly Orders including Subform and one of the reports.
> > > 
> > > /gustav
> > > 
> > > >>> Salakhetdinov Shamil <mcp2004 at mail.ru> 01-04-2009 19:49 >>>
> > > Hi SCRUM Team,
> > > 
> > > The following is the plan for the second week.
> > > Please select forms/reports your wanted to develop during this week.
> > > Please ask any questions.
> > > Please before asking the questions on forms check how the current set of forms is done: let's follow currently this "lightweight" development style for this project - we can do enhancements in the end of this project or in the follow-up project.
> > > 
> > > Forms
> > > ======
> > > 1  Customers Labels Dialog
> > > 3  Customer Phone List
> > > 2  Quaterly Order
> > > 2  Quaterly Orders Subform
> > > 1  Sales By Year Dialog
> > > 2  Sales Reports Dialog
> > > 
> > > Reports
> > > ========
> > > 2 Alphabetical List of Products
> > > 1 Product By Category
> > > 2 Sales Totals by Amount
> > > --------------------------------
> > > 16 hours
> > > 
> > > Thank you.
> > > 
> > > --
> > > Shamil
> > > 
> > > 
> > > 
> > > _______________________________________________
> > > dba-VB mailing list
> > > dba-VB at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > > http://www.databaseadvisors.com
> > > 
> > 
> > _______________________________________________
> > dba-VB mailing list
> > dba-VB at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > http://www.databaseadvisors.com
> > 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>