SSRS report builder generate dynamics headers depending on the

• ReportBuilderRookie

  Grasshopper

  Points: 13

  More actions

  February 21, 2022 at 9:48 am

  #3986294

  Hi there,

  I am creating a report. First part is normal SQL extract data with 3 columns (Date, reccount, and Type) and second part is to build a pivot table with X axis "Type", Y axis Date, and the data inside is the reccount.

  Not everyday has data so the number of columns varies depending on whether that date has data or not. If that date no data, the column of that date won't exist. (* and that's why the dynamic columns)

  My question is which control shall I use to build the report. Thanks.

• ReportBuilderRookie

  Grasshopper

  Points: 13

  More actions

  February 21, 2022 at 10:01 am

  #3986300

  hi pls ignore just got it sorted by matrix table and remove the code of pivot table and using ssrs function for the pivot part. thanks all