1. Raj Kumar
  2. PowerBuilder
  3. Friday, 16 August 2019

Hello all,

I am trying to build a report through composite data window and my child data windows have different retrieval arguments (one is bounded by date whereas the other one is a list of all items). What I need to do is display the pieces of the item available based on date ordered (0-30 days, 31-60 days, etc.). Right now I am not seeing the item count for all my items ( only the ones that are ordered in the time frame - retrieval argument - are displayed). I am wondering if I can join these two child data windows so that I can show the relevant line on the composite.

Right Now these are the entries on my database for last 30 days:

Item
Pieces ordered within last 30 days

50

E

40

 

This is result of composite right now (which is incorrect as 40 pieces corresponds to Item E):

Item Pieces ordered within last 30 days
A 50
B 40
C  
D  
E  
   

 

I am looking to display something like this:

Item
Pieces ordered within last 30 days
A 50
B 0
C 0
D 0
E 40

 

Please guide me on what is the best way to approach my problem.

Thank you!

Accepted Answer
Olan Knight Accepted Answer Pending Moderation
1
Votes
Undo

OK:

   The top dw is simple: retrieve all products.

   The bottom DW should be one controlled by the date ranges. On the WINDOW, create a groupbox with 4 radio buttons. These buttons will control what's retrieved in the bottom  DW.

   rb_1.text = "0-30 days"
   rb_2.text = "31-60 days"
   rb_3.text = "61-90 days"
   rb_4.text = "90+ days"

Default to the 1st radio button. Users can click on the different buttons to get what they want to see.


Olan

 

Comment


Thanks Olan :). That certainly works. I am wondering if there is a way to display data for all date range at once instead of user selecting the date range, such that I have something like a aging report.





Thanks again!
  1. Raj Kumar
  2. Monday, 19 August 2019
All another button "All" or "All dates".

The bottom DW will reflect the top dw, but while the top DW is sorted by PRODUCT, the botton DW can be sorted by DATE and PRODUCT.



Olan
  1. Olan Knight
  2. Tuesday, 20 August 2019
There are no comments made yet.
  1. Monday, 19 August 2019
  2. PowerBuilder
  3. # Permalink
Olan Knight Accepted Answer Pending Moderation
1
Votes
Undo

In your parent DW, you should have SQL that retrieves all of the data required for use as your DatawindowChild parameters.

If a single retrieval cannot provide you with the data you need, perhaps because the user needs to select something first, then you need a parent-child pair of DWs, not a set of dwchild dws.

Or is it too late and I am missing the point of your question?  :/

 

Olan

Comment
Thanks Olan! But my columns have different retrieval arguments(Items ordered in last 30 days, Ordered 30-90 days ago etc._ so I am stuck on that regard. I'm not sure how I can do this as the columns would have different filter for the dates.
  1. Raj Kumar
  2. Monday, 19 August 2019
There are no comments made yet.
  1. Friday, 16 August 2019
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.