Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
You need to be logged in to view a user's profile.
View Replies (2)

Resolved Composite Datawindow Report

  1. How-to
0
Votes
Undo
  1. Raj Kumar
    Raj Kumar
  2. PowerBuilder
  3. Friday, 16 August 2019 04:13 AM UTC

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
A 

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!

  1. Data
  2. Database
  3. DataWindow
  4. Filter
  5. PowerBuilder (Appeon)
How to fill an external PDF File (Forms)
Datwindow saveas not working.
Accepted Answer
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 19 August 2019 15:36 PM UTC
  2. PowerBuilder
  3. # Permalink

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
Raj Kumar
  1. Raj Kumar
  2. Monday, 19 August 2019 23:05 PM UTC


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. Helpful
Olan Knight
  1. Olan Knight
  2. Tuesday, 20 August 2019 00:43 AM UTC
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. Helpful
There are no comments made yet.
Responses (2)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 16 August 2019 04:32 AM UTC
  2. PowerBuilder
  3. # 1

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
Raj Kumar
  1. Raj Kumar
  2. Monday, 19 August 2019 00:56 AM UTC
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. Helpful
There are no comments made yet.
  • Page :
  • 1


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