Thank you EMartinez,
That would tell one when the report was run, but say for example, that one
has hundreds of Crystal reports from 4th grade that one needs to convert to
Reporting Services in 5th grade. And say, for example, that other 5th
graders are naughty and are modifying both the Crystal and SSRS reports
without telling one another. It would make version control confusing
wouldn't it. Well I was hoping to get a version number for the last time
that the report was modified in the Business Intelligence Studio. Then,
since I always deploy reports first to my computer, I would have a version
number at the bottom of the report to compare it with my version. Version
1.0001 for example; and the next time any change is made it could go to
version 1.0002 or something similar. Then one could tell the teacher to
flunk the other 5th graders and give me an A.
[quoted text, click to view] "EMartinez" wrote:
> On Jun 27, 4:38 pm, Brett <B...@discussions.microsoft.com> wrote:
> > Does anyone know a field to display the report last updated date or version
> > in a generic report footer for my 5th grade computer class? I did this in
> > 4th grade on Crystal and it was too easy. What's up with Reporting Services?
>
>
> If I'm understanding you correctly, you should be able to use:
> =Globals!ExecutionTime
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant
>
[quoted text, click to view] On Jun 28, 11:34 am, Brett <B...@discussions.microsoft.com> wrote:
> Thank you EMartinez,
> That would tell one when the report was run, but say for example, that one
> has hundreds of Crystal reports from 4th grade that one needs to convert to
> Reporting Services in 5th grade. And say, for example, that other 5th
> graders are naughty and are modifying both the Crystal and SSRS reports
> without telling one another. It would make version control confusing
> wouldn't it. Well I was hoping to get a version number for the last time
> that the report was modified in the Business Intelligence Studio. Then,
> since I always deploy reports first to my computer, I would have a version
> number at the bottom of the report to compare it with my version. Version
> 1.0001 for example; and the next time any change is made it could go to
> version 1.0002 or something similar. Then one could tell the teacher to
> flunk the other 5th graders and give me an A.
>
> "EMartinez" wrote:
> > On Jun 27, 4:38 pm, Brett <B...@discussions.microsoft.com> wrote:
> > > Does anyone know a field to display the report last updated date or version
> > > in a generic report footer for my 5th grade computer class? I did this in
> > > 4th grade on Crystal and it was too easy. What's up with Reporting Services?
>
> > If I'm understanding you correctly, you should be able to use:
> > =Globals!ExecutionTime
>
> > Regards,
>
> > Enrique Martinez
> > Sr. Software Consultant
The only thing I can think of at the moment is to create an
application in the background that basically captures changes to the
file (at the OS/filesystem level). Another option would be to use SSIS
to handle the scenario in an automated fashion [
http://www.sqlis.com/ 23.aspx] (though I'm not personally familiar w/it myself in SSIS).
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
