Geek asks and answers

Excel export: text objects in the header group or headheader group get their own separate columns

I need to export QuickReport to XLS files. The problem is that I get empty columns between my data objects. This is because, while the stream is being created, the columns are set according to the position of the objects from top to bottom, so that if the objects are left not set to exactly the same position as the part objects below it, this object will be its separate column, which will then lead to empty cells under it that could otherwise be occupied by detailed objects.

An example would be: if the heading was “Customer List” and the two columns of the part were “Customer Nr” and “Customer Name”, the heading would be placed in the letter B1, then the two part objects would receive A2 and C2. I want, however, that they get A2 and B2:

~~~~~~~~~|Customer List|~~~~~~~~~~~

CustNr~~~|(Empty Cell)~~|~CustName~~ ->Not good (This is what I'm getting now) :(

~~~~~~~~~|Customer List|~~~~~~~~~~~~~

CustNr~~~~|CustName~~|~~(empty Cell)} ->Good (This is the wanted result) :)

I thought theoretically what needs to be done is not to be taken into account when determining the maximum number of columns, but I have no idea how to achieve this.

+3
source share
1 answer

easier.

create two column headings.

The heading of the first column will be ~~~~~~~~~ Clients List ~~~~~~~~~~~~~~

header of the second column CustNr ~~~~ CustName ~~~~ (empty cell)}

each will be exported as a new line.

the problem is resolved.

0
source

More articles:


All Articles