Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved DDLB values in a report

  1. How-to
0
Votes
Undo
  1. Nick R
    Nick R
  2. PowerBuilder
  3. Tuesday, 8 September 2020 15:45 PM UTC

One quick question on generating reports out of DDLB values. I have a requirement of adding DDLB values to an existing report and these values are coming from a DW. I have followed these steps:

In the design mode of that particular report, in the data source, i have tried making changes to existing SQL Query by adding the new DDLB values with the case statements. However, this change didn't really help instead, it disturbed the existing report. 

Your help is appreciated!! Thanks.

 

CrypterObject shared encrypted data across two pro...
Can 2017 R2 & 2019 both be installed?
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 9 September 2020 01:09 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Nick;

  In that case, I would replace the DDLB with a DDDW (drop down data-window). That will dynamically interrogate the DB for you and populate the data values automatically vs a DDLB where you would have to manually code the DB access and then change the DW column's DD values at runtime.

Food for thought.
Regards ... Chris

Comment
Olan Knight
  1. Olan Knight
  2. Wednesday, 9 September 2020 22:27 PM UTC
This is a good example of using the correct tool for the job.

A DDLB is excellent for a small, fixed sete of values.

If your list can be dynamically expanded, use a DDDW.
  1. Helpful
There are no comments made yet.
Responses (2)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 9 September 2020 22:48 PM UTC
  2. PowerBuilder
  3. # 1

I agree with Chris & Olan's suggestion, and want to build on it a little.

You do not have to populate a DDDW with a database table, although this is frequently done. You have the option of creating the DW object as an external source DW where you manually populate the display value/data value contents of the DW object in the DW Painter and save the data in the DW object.

Yes, you "hard code" the data/display values in this case, but you only have to do it once and then you can reuse the DDDW throughout your application. If you do have to make changes to the values, you can do this ONCE in the DW Painter and the revision is available throughout the app.

More food for thought (munch, munch...)

Regards, John

Comment
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.