What is the easiest way to generate source for a Crosstab DataWindow based on query user provide at runtime?
Does PB 2019 or later allow SyntaxFromSQL() with "style(type=crosstab)" ?
Who want to share code if have done crosstab generation at r...
We have migrated from 10.2 to 2019 R2 and We have added a new '.XLSX' extension in our existing SaveAs option.
We are able to export the all datawindows with this extension expect the reports that has designed using crosstab datawindow.
is it possible to conditionally format headers in crosstab (dynamic)?
We have a crosstab, in rows there are accomodation units, in columns there are days. In value is the information, if that unit is empty or occupied.
In the header is number...
i have a few crosstab Datawindow with a store procedure as data source
in PB2017 the column specification button and menu entry is disable so i can not change the store procedure or add any new parameters if the store procedure has chang...
I have a Crossatab DW
running in PowerServer when the width of the dW use only one page it works with no problem
when it use more than 1 page of width it dysplay only the information in the first page.
any idea on how to get column indices in a crosstab DW?
Say you have a crosstab showing products on the rows and delivery dates on the columns, with whatever values on the cells.
How would you set the cell backcolor to e.g. RED if ...
When I try to export my crosstab - the column description are not exported instead I get for example year_1 year_2 year_3 - instead of 2016 2017 2018
It is a very simple cross tab - account as the row - year (invoice_date) as the column - no sub ...
this is my first time working on datawindow crosstab. I encountered that the datawindow will lost all the formatting after editing on the data source.
Is there anyway, i can prevent the format getting reset after inserting ad...