Renders with missing data

Anyone seen a situation where a report displays fine using VS.net, but when
you go to render via HTML -- the data shows up incomplete, it has blank cells
in the table'
Any ideas?
Confused as all heck --
JimHello, Jim.
I would assume that your HTML is correct and that there is blank data.
In VS.Net when you use Preview it actually grabs a copy of the data and
caches it for all subsequent previews. So your preview may be working
off older data while your HTML view is going to be working off live
data.
To test this you can delete your cache file. In the directory where
your report.rdl file is there should be another file called
report.rdl.data. Delete this file and the Report Designer will be
forced to rerun the queries.
Regards,
Shane
Jim_OLAP wrote:
> Anyone seen a situation where a report displays fine using VS.net, but when
> you go to render via HTML -- the data shows up incomplete, it has blank cells
> in the table'
> Any ideas?
> Confused as all heck --
> Jim|||Shane,
It actually had to do with security on the cubes, once I opened the
securityfor the cubes -- the data magically popped showed up!!
Thanks,
Jim
"ShaneC" wrote:
> Hello, Jim.
> I would assume that your HTML is correct and that there is blank data.
> In VS.Net when you use Preview it actually grabs a copy of the data and
> caches it for all subsequent previews. So your preview may be working
> off older data while your HTML view is going to be working off live
> data.
> To test this you can delete your cache file. In the directory where
> your report.rdl file is there should be another file called
> report.rdl.data. Delete this file and the Report Designer will be
> forced to rerun the queries.
> Regards,
> Shane
> Jim_OLAP wrote:
> > Anyone seen a situation where a report displays fine using VS.net, but when
> > you go to render via HTML -- the data shows up incomplete, it has blank cells
> > in the table'
> >
> > Any ideas?
> >
> > Confused as all heck --
> >
> > Jim
>