I've a requirement to display crosstab with everyday data (displayed based on "Date value")...
This I'll lookup from a Data table, but this table might not have every day date value (which means record might be missing for a day or two)..
I need to show Default value as zero for that missing date record...
appreciate any sagesions and advices
Have you taken a look at the second option in this article:
Another option is to use a LOOKUP() function similar to the article here:
Hopefully this helps!