1. Karen Adams
  2. PowerBuilder
  3. Wednesday, 6 October 2021 15:51 PM UTC

Hello,

I need to know if there is a way to update the settings for the amount of rows that a query will populate/display.

I have a report, but it is limiting the number of rows which means I'm not getting all the information I need.

 

Thank you,

Karen

Shekar Reddy Accepted Answer Pending Moderation
  1. Wednesday, 6 October 2021 16:17 PM UTC
  2. PowerBuilder
  3. # 1

Verify the SQL WHERE clause and table joins inside the report DW.

Check for DataWindow > Rows > Retrieve Options > Rows as Needed.

Check for DataWindow > Rows > Filter menu.

Check for any Window logic that may be filtering out rows before/after retrieve (SQLPreview! event, etc).

Verify if you are connecting to the right database.

HTH

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.