How Drill Down on List Like report

Technical support

Moderators: Bob Cergol, Data Access, Cintac

How Drill Down on List Like report

Postby jldum » Fri May 08, 2009 11:40 am

Hi there,

I am trying (I think again after being away for months) the following

I have 3 tables related by one-t-many relations
I joined the tables in a DynaView (OK) retaining the columns I want to present.
I want to show 5 or 6 columns for table 1 (higher parent) , each hp column being in one-t-one relation with each other as a list , then
selecting a row at that level,
drill down to the next level (mid parent) each mp column being in one-t-one relation with each other as and show this info as a list ,
then drill down again ....

In a single (collection) report I can not get this to work

caption column seems to be limited to 2 columns,
even trying a 'technical' aggregation does not seem to help....

What would be the way to go here (best practice ?)

Awaiting reaction
regards

JL D
jldum
 
Posts: 29
Joined: Thu Jan 31, 2008 2:21 pm
Location: Kortrijk

Postby admin » Mon May 11, 2009 2:47 pm

Hi JL D,

If I understand you correctly, you can get the result that you want by checking an option on the list:
Image


My steps were:
Create a 3 table join:
Image

Create a report with grouping levels corresponding to the 3 tables:
Image

Check the Option "Grouped values on each row":
Image

Save and run the list:
Image


If this does not do what you were after, please write again, and provide a sample of your join source.

Best regards

Bo Andersen
User avatar
admin
Certified Dynamic AI Professional
 
Posts: 177
Joined: Thu Jan 01, 1970 1:00 am
Location: Copenhagen, Denmark

Postby jldum » Thu May 21, 2009 4:18 pm

Hi Bo,

thanks for the answer.
I'll put this in practice
regards

JL D
jldum
 
Posts: 29
Joined: Thu Jan 31, 2008 2:21 pm
Location: Kortrijk


Return to Technical Support

cron