Sunday, February 19, 2012

How to browse *.data file?

We know that when we execute RS report,
it would be generated a *.data file.
Can we browse *.data file?
Using Notepad? Office?
Thanks for any advice!
AngiI haven't looked on the server but I am pretty sure that this .data file is
a cache of data used for when you are developing. It is just the latest data
so while developing. You can delete it at any time and it will be recreated
the next time you are previewing the report. What is your reason/concern
about this file?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Angi" <enchiw@.msn.com> wrote in message
news:%232PR2uAEGHA.2300@.TK2MSFTNGP15.phx.gbl...
> We know that when we execute RS report,
> it would be generated a *.data file.
> Can we browse *.data file?
> Using Notepad? Office?
> Thanks for any advice!
> Angi
>|||Thanks Bruce!
The *.data file that I mentioned is on the client generate by Report
Designer.
Your description just as I think.
Cause the customer found her data on report designer and report manager
dosen't synchronize.
Report designer less 1, so she thought can browse the *.data to see what's
going on and why less 1.
I have the same problem on Reporting Service first version or SP1 version, I
forgot.
If I browse the parameter 2005/11 and generate 10 records then continue to
browse the 2005/12 and generate records.
If 2005/12 has 12 records, but cause first browse 2005/11 then 2005/12 just
present 10 records not 12 records!
Did you ever met this situation on earlier reporting services version?
After upgrade to SP1 or SP2 the problem be solved.
So, I think my customer has not upgrade to SP2 and called her to upgrade.
Angi
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:ONPAcuBEGHA.532@.TK2MSFTNGP15.phx.gbl...
>I haven't looked on the server but I am pretty sure that this .data file is
>a cache of data used for when you are developing. It is just the latest
>data so while developing. You can delete it at any time and it will be
>recreated the next time you are previewing the report. What is your
>reason/concern about this file?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Angi" <enchiw@.msn.com> wrote in message
> news:%232PR2uAEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>> We know that when we execute RS report,
>> it would be generated a *.data file.
>> Can we browse *.data file?
>> Using Notepad? Office?
>> Thanks for any advice!
>> Angi
>|||The way it works is if no parameter changes then the designer continues to
use the data file. So if you have a report with no parameters, after the
first time previewing it, it will not hit the database again. You can always
manually delete the .data file which will cause the database to be hit. If
you have a parameter, then just change one of the parameters and a new .data
file will be generated. I am not aware of anything changing in this area
with the service packs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Angi" <enchiw@.msn.com> wrote in message
news:%23n1f%239DEGHA.3892@.TK2MSFTNGP10.phx.gbl...
> Thanks Bruce!
> The *.data file that I mentioned is on the client generate by Report
> Designer.
> Your description just as I think.
> Cause the customer found her data on report designer and report manager
> dosen't synchronize.
> Report designer less 1, so she thought can browse the *.data to see what's
> going on and why less 1.
> I have the same problem on Reporting Service first version or SP1 version,
> I forgot.
> If I browse the parameter 2005/11 and generate 10 records then continue to
> browse the 2005/12 and generate records.
> If 2005/12 has 12 records, but cause first browse 2005/11 then 2005/12
> just present 10 records not 12 records!
> Did you ever met this situation on earlier reporting services version?
> After upgrade to SP1 or SP2 the problem be solved.
> So, I think my customer has not upgrade to SP2 and called her to upgrade.
> Angi
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com>
> ¼¶¼g©ó¶l¥ó·s»D:ONPAcuBEGHA.532@.TK2MSFTNGP15.phx.gbl...
>>I haven't looked on the server but I am pretty sure that this .data file
>>is a cache of data used for when you are developing. It is just the latest
>>data so while developing. You can delete it at any time and it will be
>>recreated the next time you are previewing the report. What is your
>>reason/concern about this file?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Angi" <enchiw@.msn.com> wrote in message
>> news:%232PR2uAEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>> We know that when we execute RS report,
>> it would be generated a *.data file.
>> Can we browse *.data file?
>> Using Notepad? Office?
>> Thanks for any advice!
>> Angi
>>
>

No comments:

Post a Comment