• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Can i move the columns of my CrossTab Datawindow ?

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

Resolved Can i move the columns of my CrossTab Datawindow ?

  1. How-to
1
Votes
Undo
  1. Edinson Nongrados
    Edinson Nongrados
  2. PowerBuilder
  3. Thursday, 30 September 2021 11:13 AM UTC

I have a crosstab datawindow, and i want to change the Totals column to the left because the results of the datawindow are many and the totals columns are shown on a different page.

I want to show my totals column next to the first column.

  1. Crosstab
  2. DataWindow
  3. PowerBuilder
how to use PDB PB19R3 file into PB9?
icons in the system tree
Responses (2)
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 30 September 2021 13:36 PM UTC
  2. PowerBuilder
  3. # 1

[Edited]

It is only possible if "Rebuild columns at Runtime" in Crosstag dialog is unchecked. In this case the columns are defined at design and fix.

Try this:

- Check that "Column Moving" is checked on General Tab in datawindow properties.

- In Preview pane: Use the mouse to move the column to the position you want. This should automatically move the column in Design pane.

 

If the number of columns is variable and should defined at runtime this, you can't uncheck the "Rebuild columns at Runtime". In this case it will not work.

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 30 September 2021 14:18 PM UTC
Hi Rene ... this procedure would work for a GRID DWO but not a CrossTab. While it does work in the preview pave of the CT, it does not affect the design pane and upon the next retrieve, the CT DWO preview pane will return to it's original display format.
  1. Helpful 1
René Ullrich
  1. René Ullrich
  2. Friday, 1 October 2021 05:01 AM UTC
Hi Chris...you are right. If "Rebuild Column at Runtime" ist checked it is not working. If it is unchecked it will work.

I will enhance my reply.
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Friday, 1 October 2021 05:51 AM UTC
We choose crosstab DW, mostly, if there is variable no. of columns. If we know the columns (or fixed columns) it will be better to choose Tabular / Grid DW rather than crosstab DW. IMO.
  1. Helpful
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Thursday, 30 September 2021 13:29 PM UTC
  2. PowerBuilder
  3. # 2

No. IMO.

If possible, it will be useful.   Let's see if any other member could come out with a way to achieve this.

Happiness Always
BKR Sivaprakash

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 30 September 2021 14:15 PM UTC
Correct
  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.