2nd POST-How to change color for a visited field?

Hello All,
I have a parameterized report (Report1), which has a field (say
'Control#')that has 'Jump to Report' navigation property setup. When the
user selects their parameters, Report1 displays, say 10 records displayed on
the Report, and when the user clicks on Control# of Report1, it Jumps to
Report2, which displays the details of that Control#. say from 10 records
displayed on Report1 the user cliked on the 5th record to get Report2. after
reviewing that Report, the user would like to go back to Report1. Here, I
want to change the font color of the 5th record Control#, as I have already
viewed it. By doing this, I would be able to make out, which records I
reviewed and which ones I did not. Is there any built in functionality in the
RS to do? Could please someone help me'
Greatly appreciated!There is no built-in feature in RS to magically display the visited field.
Instead, I would log the user visited fields history in the database using
the User!UserId. So, when the user navigates from Report1 to Report 2
(assuming that you pass Control# as parameter) I would base Report 2 on a
stored procedure which will log an entry for that user. Then, the user goes
back to Report 1 you will just need to link the dataset with the visited
history table using User!UserId. Of course, you need at some point to clear
the history, e.g by scheduling a job with the SQL Agent.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"amma" <amma@.discussions.microsoft.com> wrote in message
news:EDBB4673-4C72-4609-A6EE-106E785653AD@.microsoft.com...
> Hello All,
> I have a parameterized report (Report1), which has a field (say
> 'Control#')that has 'Jump to Report' navigation property setup. When the
> user selects their parameters, Report1 displays, say 10 records displayed
on
> the Report, and when the user clicks on Control# of Report1, it Jumps to
> Report2, which displays the details of that Control#. say from 10 records
> displayed on Report1 the user cliked on the 5th record to get Report2.
after
> reviewing that Report, the user would like to go back to Report1. Here, I
> want to change the font color of the 5th record Control#, as I have
already
> viewed it. By doing this, I would be able to make out, which records I
> reviewed and which ones I did not. Is there any built in functionality in
the
> RS to do? Could please someone help me'
> Greatly appreciated!
>
>