Showing selective data

[#1]

I have 3 QVD's all with a "Day" "Month" "Year" key linking them.

One of the QVD's only gets updated every 2 days, so it's constantly 2 days behind in data.

I have 3 Chart Pivot Tables to display the data from the 3 QVD's. I was wondering, is there any way to surpress the one that doesn't get updated daily so that the last 2 days (which shows 0 for no data) only shows the data captured?

I'm thinking maybe to break the link (as I'm not doing any listbox filters or giving them the ability TO filter per day)

[tresesco]

Hello,

you can do whatever you want based on the condition of qvd creation time.

QvdCreateTime('MyFile.qvd')

QvdCreateTime('C:\MyDir\MyFile.qvd')

I guess this would help you.

Regards,

tresesco

[#3]

Thanks, I'll keep that in mind, the problem though is the QVD is generated every day whereas the XLS source isn't updated everyday, and if they do update the XLS source, its for the past 2 days.

So 31st they'll capture 28th data, 1st of Sept they'll capture 29th data etc...

[#4]

Instead of limiting the number of days that pull through from the data, is it possible to manipulate the display to only show the last 7 days but still account for the entire month? (otherwise my sums and averages only show for the last 7 days)

[tresesco]

That you can always achieve by choosing available option in presentation tab of chart property.

Regards,

tresesco

[#6]

Any insights as to how? Because all that I can see is I can make the text show left/right/center. Choose to wrap text, where my labels are and a bunch of allow/disallow stuff. Nowhere where I can add "show only 7 days from the month's worth of data you have"

[tresesco]

instead of table box use chart - straight table.

Regards,

tresesco

[#8]

If I do that I lose my pivots. Might as well then just use SSRS with some fancy SQL at the backend