data is missing when report refresh automatically

[Anonymous]

Hello All,

I have a report where I am having 20 tables.

As per my requirement I created append table by using 5 tables

and created another append table by using 5 tables.

and one more with remaining 10 tables.

So when I scheduled my report in server I am getting empty data.

Even If I do the refresh by using refresh option I am getting empty data

But when I refresh table by table one by one , I am getting data.

like table1,table2,table....table 10 then append table1, append table 2 and append table 3.

So Every day I am doing manual refresh and publising report in server which is very hard

Could any one please help how to fix this issue

[Kishore_KVN]

Hello @Anonymous , may I know what is the datasource

[Anonymous]

Hi @Kishore_KVN ,

We are using sql server