1. Berka Frenfert
  2. PowerBuilder
  3. Monday, 23 January 2023 14:08 PM UTC

Scenario:

1st User can design report in crystal reports and attach to PowerBuilder app has admin rights.He can design PB reports as well and same way attach the PB DW he do with Crystal Report. Only difference is either path on disk or the dataobject name.

2nd user open up a form from menu and selects or edit values which are parameters that goes to crystal report  datawindow. He is data entry operator.

I am a developer and i have no idea what query was used behind Crystal report or the datawindow object. All i know is the parameter sent to the report. The 1st user know what to do with the parameter. He knows which parameter is matched with what column of the report object. All i do is call retrieve for both of them. So far things are working good.

Problem:

for example there is AccIDFrom and AccIDTo range set through the parameter form and results are like 10 to 15. In a situation i have to show list of retrieved account numbers in a DDLB so that user can click on any acccount number and another report opens based on that account number clicked.

I get query somehow and try to find how many places the parameter AccIDFrom was compared or used in the query and it turned out to be a supper crazy idea. Because queries are too complex and column name varies from report to report.

Question: What is the easiest way to find or if there is way PB help with column name a parameter is compared to?

Accepted Answer
Berka Frenfert Accepted Answer Pending Moderation
  1. Thursday, 11 May 2023 10:22 AM UTC
  2. PowerBuilder
  3. # Permalink

That thing is almost impossible to achieve. Lets just close this topic now.

Comment
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.