PC Review


Reply
Thread Tools Rate Thread

How to design a drill-down grid ?

 
 
Bjorn Sagbakken
Guest
Posts: n/a
 
      10th Oct 2007
I should very much like to add a sophisticated drill-down feature to a
grid/table in our ASP.NET web pages (VS 2005), sort of like the funtionality
of the treeview. But I want the presentation to be as with a table with
columns and rows in different style/color for each indented drill-down step
(sub-tables).

An example would be a table of customers, but with a click on the + sign on
the left edge one can view a sub-table with all orders for a single
customer. Next, click on the + sign for a single order to view a new
sub-table containing the items on the order.

Is this possible? And what is the best approach?

Bjorn


 
Reply With Quote
 
 
 
 
Alvin Bruney [MVP]
Guest
Posts: n/a
 
      11th Oct 2007
It's very straightforward and easily accomplished. You will simply need to
handle the drill/click event and fire a query at the data with an updated
where clause containing the row item that you need to drill on.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99


"Bjorn Sagbakken" <bjo-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I should very much like to add a sophisticated drill-down feature to a
>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>funtionality of the treeview. But I want the presentation to be as with a
>table with columns and rows in different style/color for each indented
>drill-down step (sub-tables).
>
> An example would be a table of customers, but with a click on the + sign
> on the left edge one can view a sub-table with all orders for a single
> customer. Next, click on the + sign for a single order to view a new
> sub-table containing the items on the order.
>
> Is this possible? And what is the best approach?
>
> Bjorn
>



 
Reply With Quote
 
Bjorn Sagbakken
Guest
Posts: n/a
 
      11th Oct 2007
Yes, the database query is easy, but whitch grid/table component should be
used to present a dynamical table within a table within a table...

Bjorn

"Alvin Bruney [MVP]" <some guy without an email address> wrote in message
news:(E-Mail Removed)...
> It's very straightforward and easily accomplished. You will simply need to
> handle the drill/click event and fire a query at the data with an updated
> where clause containing the row item that you need to drill on.
>
> --
> Regards,
> Alvin Bruney
> ------------------------------------------------------
> Shameless Author Plug
> OWC Black Book 2nd Edition
> Exclusively on www.lulu.com/owc
> $24.99
>
>
> "Bjorn Sagbakken" <bjo-(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I should very much like to add a sophisticated drill-down feature to a
>>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>>funtionality of the treeview. But I want the presentation to be as with a
>>table with columns and rows in different style/color for each indented
>>drill-down step (sub-tables).
>>
>> An example would be a table of customers, but with a click on the + sign
>> on the left edge one can view a sub-table with all orders for a single
>> customer. Next, click on the + sign for a single order to view a new
>> sub-table containing the items on the order.
>>
>> Is this possible? And what is the best approach?
>>
>> Bjorn
>>

>
>



 
Reply With Quote
 
IfThenElse
Guest
Posts: n/a
 
      11th Oct 2007
Third party component, create your own or Google there are few free ones.

I will take you a while or some effort to learn how to use them however.



"Bjorn Sagbakken" <bjo-(E-Mail Removed)> wrote in message
news:I-(E-Mail Removed)...
> Yes, the database query is easy, but whitch grid/table component should be
> used to present a dynamical table within a table within a table...
>
> Bjorn
>
> "Alvin Bruney [MVP]" <some guy without an email address> wrote in message
> news:(E-Mail Removed)...
>> It's very straightforward and easily accomplished. You will simply need
>> to handle the drill/click event and fire a query at the data with an
>> updated where clause containing the row item that you need to drill on.
>>
>> --
>> Regards,
>> Alvin Bruney
>> ------------------------------------------------------
>> Shameless Author Plug
>> OWC Black Book 2nd Edition
>> Exclusively on www.lulu.com/owc
>> $24.99
>>
>>
>> "Bjorn Sagbakken" <bjo-(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I should very much like to add a sophisticated drill-down feature to a
>>>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>>>funtionality of the treeview. But I want the presentation to be as with a
>>>table with columns and rows in different style/color for each indented
>>>drill-down step (sub-tables).
>>>
>>> An example would be a table of customers, but with a click on the + sign
>>> on the left edge one can view a sub-table with all orders for a single
>>> customer. Next, click on the + sign for a single order to view a new
>>> sub-table containing the items on the order.
>>>
>>> Is this possible? And what is the best approach?
>>>
>>> Bjorn
>>>

>>
>>

>
>



 
Reply With Quote
 
Bjorn Sagbakken
Guest
Posts: n/a
 
      11th Oct 2007
Ok, that was useful information.

Bjorn

"IfThenElse" <(E-Mail Removed)> wrote in message
news:ur%23%(E-Mail Removed)...
> Third party component, create your own or Google there are few free ones.
>
> I will take you a while or some effort to learn how to use them however.
>
>
>
> "Bjorn Sagbakken" <bjo-(E-Mail Removed)> wrote in message
> news:I-(E-Mail Removed)...
>> Yes, the database query is easy, but whitch grid/table component should
>> be used to present a dynamical table within a table within a table...
>>
>> Bjorn
>>
>> "Alvin Bruney [MVP]" <some guy without an email address> wrote in message
>> news:(E-Mail Removed)...
>>> It's very straightforward and easily accomplished. You will simply need
>>> to handle the drill/click event and fire a query at the data with an
>>> updated where clause containing the row item that you need to drill on.
>>>
>>> --
>>> Regards,
>>> Alvin Bruney
>>> ------------------------------------------------------
>>> Shameless Author Plug
>>> OWC Black Book 2nd Edition
>>> Exclusively on www.lulu.com/owc
>>> $24.99
>>>
>>>
>>> "Bjorn Sagbakken" <bjo-(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>>I should very much like to add a sophisticated drill-down feature to a
>>>>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>>>>funtionality of the treeview. But I want the presentation to be as with
>>>>a table with columns and rows in different style/color for each indented
>>>>drill-down step (sub-tables).
>>>>
>>>> An example would be a table of customers, but with a click on the +
>>>> sign on the left edge one can view a sub-table with all orders for a
>>>> single customer. Next, click on the + sign for a single order to view a
>>>> new sub-table containing the items on the order.
>>>>
>>>> Is this possible? And what is the best approach?
>>>>
>>>> Bjorn
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unhide query design grid in design view. CT25 Microsoft Access 3 2nd Feb 2009 12:38 AM
Sandisk Cruzer Drill Drill Drill ben_k Storage Devices 4 6th Dec 2005 01:48 AM
Design Grid =?Utf-8?B?dG9yb250bzE=?= Microsoft Access 0 23rd Mar 2005 03:11 PM
Grid X & Grid Y not there in Format properties (design view of forms) Sitara Microsoft Access Forms 1 23rd Jan 2005 07:31 PM
Design Grid not visible Mike Microsoft Access Queries 2 21st Sep 2004 09:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:40 PM.