Showing columns with empty rows in tables

[#1]

Hi everybody,

I have a standard report with tables showing 6 months of data. For some clients, there is no enough data yet, So I would need to have a table like:

	Dec 2013	Jan 2014	Feb 2014	Mar 2014	Apr 2014
First visit	100	110
Daily	95	85
Weekly	47	57
Monthly	44	39
Less than once a month	9	7

My data is loaded from SQL and I can only show existing data

	Dec 2013	Jan 2014
First visit	100	110
Daily	95	85
Weekly	47	57
Monthly	44	39
Less than once a month	9	7

I tried to INLINE load months with no data, but no success.

Could you please help me to solve this?

Thank you very much!,

ILIA

[#2]

Try to disable in presentation tab of the table:

Suppress Zero Values

Suppress Null

[maxgro]

in the attachment

[#4]

Thank you guys,

The visit counts are calculated from a separate table containing record ID and visit frequency value

Respondent ID is connected to MYear variable in a date format. I cannot INLINE load aggregated visit values like it was shown in the example, but thank you anyway.