Tablix & Variables

Diego Morelli 1 Reputation point
2022-02-12T16:06:39.71+00:00

Hello,

i'm beginner with SSRS. I have a report with a tablix linked to a dataset that contain users information. I'm grouping this tablix by user. I would like to update some fields outside of this tablix with the value of this one.
So make simple, it's like an order. On the top you will have name and adress and in the tablix all the order info. I would like that when i go from page to page and user in the tablix change that also user information outside change as well.

Thanks for your help

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,940 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Diego Morelli 1 Reputation point
    2022-02-17T20:14:11.373+00:00

    @IsabellaZhangMSFT-7746 any idea how i can solve my problem?
    Thanks for your help

    0 comments No comments

  2. Isabellaz-1451 3,616 Reputation points
    2022-02-18T09:36:52.94+00:00

    Hi @Diego Morelli
    Sorry for my late.I see your reply just now .
    You mean your two dataset data changed when the USER changed ? I think you can add a parameter which contain all the users,and then use the parameter on your datasets.

    Best Regards,
    Isabella


    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.