Dynamic Columns For HTML5 Report

1 posts, 0 answers
  1. Shahid
    Shahid avatar
    3 posts
    Member since:
    May 2016

    Posted 05 Apr 2018 Link to this post

    Hi,

    I am using HTML5 Telerik Report Viewer for my MVC 5 Project and using Stored Procedures to fetch the data. Its pretty awesome.

    The only issue I am facing is, I cannot use the column names exactly returned by my stored procedure. The pattern is following:
    If a user select February from the options, report should show:
    Sr. No         February         Name

      1                  15                  xyz

      2                  30                 abc

    but if user select December, it should show the following:

    Sr. No         December         Name
      1                  15                  xyz
      2                  30                 abc

     

    I cannot make the columns dynamic. My stored procedure can return dynamic column name (using pivot). Can you please help me out? I am unable to find such a solution on your forums and/or stackoverflow. Please keep in mind that I am using MVC 5 HTML 5 Report Viewer with stored procedures.

     

    Thanks alot

     

Back to Top