How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports
How to create Drill-down forms/reports How to create Drill-down forms/reports
How to create Drill-down forms/reports
Go Back  Xtreme Visual Basic Talk > > > How to create Drill-down forms/reports


Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2004, 09:29 AM
Don Johnson Don Johnson is offline
Regular
 
Join Date: Jun 2004
Posts: 62
Question How to create Drill-down forms/reports


Hello!

My user wants to see a summary level display of some information (up to 4 rows , each with 5 fields) which I obtain from SQL Svr. With each row, he would like the ability to click something (button, or ??) that would allow him to drill down from that row to the details supporting that row. Then, he would again like to drill down further if possible.

The hierarchy would be:
Date (the main driver for the query)
>Location (here are the 4 rows max - 1 for each plant)
>>Project
>>>Shift
>>>>(Details) - project activity list (1 to maybe 5 or 6)

Then to complicate it, he would like the ability to switch the hierarchy from Date/Location/Project/Shift to Date/Project/Location/Shift, changing the drill-downs to support that.

I am too green to figure this out in VB/SQL, and would welcome your kind assistance, or direction to another website. Examples are gratefully received, too!

Thanks in advance!
Don
Reply With Quote
  #2  
Old 10-20-2004, 10:35 AM
lebb's Avatar
lebbHow to create Drill-down forms/reports lebb is offline
Disillusioned Code Poet

Retired Moderator
* Guru *
 
Join Date: Apr 2002
Location: Tennessee, USA
Posts: 12,808
Default

Continued private discussion is here regarding your account.

I would suggest that, as a start, you have the 4 criteria as comboboxes, and based on the selections made in those comboboxes, construct the where clause of an SQL statement used to pull data into a flexgrid, listview, listbox, etc. Does this help as a place to start?
__________________
Laura

Ita erat quando hic adveni.
Reply With Quote
  #3  
Old 10-20-2004, 11:25 AM
Don Johnson Don Johnson is offline
Regular
 
Join Date: Jun 2004
Posts: 62
Default

Quote:
Originally Posted by lebb
I would suggest that, as a start, you have the 4 criteria as comboboxes, and based on the selections made in those comboboxes, construct the where clause of an SQL statement used to pull data into a flexgrid, listview, listbox, etc. Does this help as a place to start?
That would work, but after discussing this with the user manager, his preference is to see the summary rows (location), then to select one of these from the display to bring up the second level, then to select one from that display to go to the third level, etc. I will see if I can create something like an Excel filter to sit above the grid. Doyou think I could use a hierarchy grid to help out?

Don
Reply With Quote
  #4  
Old 10-20-2004, 12:42 PM
lebb's Avatar
lebbHow to create Drill-down forms/reports lebb is offline
Disillusioned Code Poet

Retired Moderator
* Guru *
 
Join Date: Apr 2002
Location: Tennessee, USA
Posts: 12,808
Default

The idea intrigued me a bit, so I threw together a very simple project to demonstrate using a grid to filter (using a small Access database, included). It has no error handling and isn't the most efficient, since it continually requeries the database, but might give you some ideas.

Double-click a cell in the grid to filter on that value.
Attached Files
File Type: zip DrillDownSample.zip (9.1 KB, 22 views)
__________________
Laura

Ita erat quando hic adveni.
Reply With Quote
  #5  
Old 10-20-2004, 01:10 PM
Don Johnson Don Johnson is offline
Regular
 
Join Date: Jun 2004
Posts: 62
Default

Thanks, Laura - that example works great - now for a little twist from the original - Is there any way to make a summary row (preferably somehow highlighted or bolded) that has the summary of the selected drill-down?

For example (in your db), if I have (shift 1) or (bldg a) filtered, to have a summary row (preferably at the top) with the sum of the details?

Don
Reply With Quote
  #6  
Old 10-20-2004, 01:39 PM
lebb's Avatar
lebbHow to create Drill-down forms/reports lebb is offline
Disillusioned Code Poet

Retired Moderator
* Guru *
 
Join Date: Apr 2002
Location: Tennessee, USA
Posts: 12,808
Default

Sure, just begin populating your grid at row 2 rather than row 1 (adding an extra row at the end, of course), then after you have it filled, loop back through (or else keep a running total as you are populating the grid) and accumulate your summary data.
__________________
Laura

Ita erat quando hic adveni.
Reply With Quote
  #7  
Old 11-26-2004, 02:33 PM
Don Johnson Don Johnson is offline
Regular
 
Join Date: Jun 2004
Posts: 62
Default

Quote:
Originally Posted by lebb
Sure, just begin populating your grid at row 2 rather than row 1 (adding an extra row at the end, of course), then after you have it filled, loop back through (or else keep a running total as you are populating the grid) and accumulate your summary data.
Well, Laura, that's what I did, and here I am a month later, with a finished project going through user testing. Thanks for your help!

Don
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports How to create Drill-down forms/reports
How to create Drill-down forms/reports
How to create Drill-down forms/reports
 
How to create Drill-down forms/reports
How to create Drill-down forms/reports
 
-->