Tablix shows only the first entry when several entries exists with the same time

• Magkro

  SSC Enthusiast

  Points: 187

  More actions

  March 7, 2024 at 4:16 pm

  #4391372

  Hi @all,

  I'm using a tablix in SQL Server 2019 Reporting Service to show some entries from a SQL database.

  It works fine and query is very simple.

  Select

  [TimeStamp],

  [Data1],

  [Data2],

  [Data3]

  From Table

  Where [TimeStamp] between @Start and @End

   

  But there is an issue when the TimeStamp value is identical for some entries in the table.

  If I perform the query in the SQL Management Studio I got all entries.

  If I run my report with these tablix I got most of all entries.

  The report shows only the first item of the entries with a identical TimeStamp.

  E.g. If there are two entries with the same TimeStamp only the first entry is shown in the report the second one isn't shown.

  There are no sorting or filtering settings in the tablix element.

  Could it be that there are some other setting whicj generates that behavior?

  I'm usind the build 15.0.7545.48.10

  Thanks for all helpfull feedbacks

  • This topic was modified 1 month, 3 weeks ago by  Magkro.

• Jo Pattyn

  SSC-Dedicated

  Points: 32070

  More actions

  March 8, 2024 at 10:03 am

  #4391775

  Have you defined some grouping? That could cause it

  Is the detail of the tablix ungrouped?

  What if you use it within a new tablix?