Neven Draskovic

Neven Draskovic

  • NA
  • 117
  • 138.1k

Creating a rdlc report with a variable number of columns

Jan 22 2013 4:47 AM
Hey

I have a problem with creating an .rdlc report. The point of this report is to show the number of passengers on a bus routes (it has the number of passengers for each station on that route). The DataSet is filled with a stored procedure (that I can't change). Data for each route is consisted of 2 parts - the first part has the names of the stations on the specific route (there are columns that represent the number of passengers, but their values are null), and the second part contains the number of passengers for each station. Both this parts are a result of the same stored procedure, and they are displayed in the same table.
The problem I'm having is that each route has a different number of stations.
So my question is - how can I make a report (or subreport) that would adapt to the number of stations on a specific route. It is important to mention that routes with different number of stations should be displayed on the same report (the number of columns should be the same as the number of stations on the route).
I'm using VS 2010 and C# to create the application that generates this reports.
Can you help me with this problem?
Thanks