Post reply

Multiple Tablixes, only some refresh

  • May 31, 2016 at 5:19 pm

    #1882307

    A couple thoughts...

    First, I believe there are refresh property settings on tablixes, double check the settings on those.

    Are you seeing this behavior in SSDT or when you deploy the report or both?

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • June 1, 2016 at 9:07 am

    #1882513

    Hello, thanks for your response 🙂 Also, I didn't mention that I'm actually on SQL Server 2008 R2

    I haven't deployed yet, I'm only seeing it in Visual Studio when previewing the report, this development is really just a test to see if any of this is possible. It seemed like it was very possible at first but now I'm just confused why the behavior began after switching to TVF's. Seems like it should be the opposite? I looked through the tablix and dataset properties but didn't see anything about refreshing the data or anything like that, I only saw options for formatting.

  • June 1, 2016 at 9:15 am

    #1882519

    I also forgot to mention that a manual refresh does work for the remaining tablixes which do not refresh with the button functionality.

    Basically the sign "button" changes a signed parameter value to 1 for the refresh. A separate Dataset checks this parameter value and executes stored procedures if it is > 0, then sets the parameter back to 0 after executing the stored procedures.

    The stored procedures "sign" the rows in the table by setting a column value to 1 for the displayed records.

    I've verified that the stored procedures are working, which is evident when I do a manual refresh and when I check the actual data in the tables through SSMS.

    Below is the pseudo code for the dataset with the stored procedures:

    if signedparameter > 0

    'exec' spSigntheserecords thisUser, thisMonth, thisYear, signedValue

    --this is repeated three times, once for each tablix basically

    'set' signedparameter = 0

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

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