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

Resolved Changing the number of rows retrieved/displayed

  1. How-to
0
Votes
Undo
  1. Karen Adams
    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

Making a plan bord / graph
Native SCC Incorrect Status
Responses (1)
Shekar Reddy
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.