Post reply

Identifying changes to original values in Reporting Services

  • May 22, 2007 at 1:31 pm

    #174357

    Hello,

    I have an InfoPath form that is tied to a db within SQL Server 2005.  This form lets users enter certain milestone dates (format "MM/dd/yyyy").  My issue is that when I use Reporting Services to develop reports based on the inputs to this form, I need to be able to visually demonstrate that the original milestone date entered has changed.  I.e. On the report I generate, I'd like to have whatever 'original' milestone date the user enters in black ink, but if the user changes that date, I'd like to have the new milestone date show up in red ink.  Is this possible within Reporting Services?

    thanks,

    mark

  • May 22, 2007 at 2:42 pm

    #708191

    What does the table structure look like? Do you have a query that already returns this data for your report?

    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

  • May 22, 2007 at 2:51 pm

    #708194

    Yes, I do have a query that returns the data for the report.  The db table that my report is referencing is basically made up of 4 columns: Project_Key (int), Project_Name (varchar(50)), Milestone_Date (datetime).  Sorry if that's not exactly what you are looking for, I'm very new to this.

  • May 23, 2007 at 12:09 am

    #708249

    I'm guessing from the schema you've supplied that you don't actually keep the original of the subsequently changed record(s)?  If you've  not kept the original, what test would you use to determine that it had changed?  Ie normally you'd keep the original and maybe version each instance of that record, or even take a 'slowly changing dimension' approach (type 1 or 2) but again these would let you see what is current, or what was current at a point in time(depending on which approach was taken).

    If you have no way of running a sql query to flag/identify which records have been changed since creation then i'm not sure how you'd make this work.  Each executon of the RS report either re-executes the underlying query or hits the cache, either was, there's no real way to use the data 'seen' in a prior report execution in a formula to test for changes in the new;y retrieved data set.

     

    Steve.

  • May 23, 2007 at 7:02 am

    #708304

    Thanks.  So really I need to add another column to my table to track the changed date?  That makes sense, I can adjust the infopath form that is used as well to reflect this change in the table. 

    thanks for the insight.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply