How to fix the coulumn of a cross tab

[system]

Hi!
Can you tell me how can i fix the columns of crosstab?
For example. I have a section Production line and inside the section i have a crosstab products/days of the month. I want to appear always de 31 days with values or not. I don’t want the crosss tab for each section with diferente sizes. i want always the 31 days even if there are no values for some days.
I will send you a printscreen.

thanks

Sofia Carneiro

---

asantos (BOB member since 2011-09-12)

[system]

Hi,

Unfortunately, there is no solution to your problem. If you had not used sections then a solution is described in the Reporter’s FAQ here:

FAQ: Reporter

How can I include data for all months in a crosstab, even if a particular month has no data? One way to do this is to create a second data provider using only the months. Then link (or “merge”) the second data provider (query) with the first data provider. Use the month column from the second data provider in the cross tab. This should bring in all months even if there were no data for that month. However this technique does not work if you have sections in your report. Dave Rathb…

However, the above solution does not work when sections are used

---

Marek Chladny (BOB member since 2003-11-27)