SSRS 2016 Report - Populate table from string parameter

Question

Let's assume I have the following C# object:

 public class BusinessDetails
    {
        public string Name { get; set; }

        public string Address1 { get; set; }

        public string Address2 { get; set; }
    }

Long story short my solution [A] sends a serialised (JSON) List<BusinessDetails> to another external solution [B] that in turn feeds the RDL in question with this and other provided parameters (strings); therefore, on the RDL level I am limited to strings and strings only.

This is all good for simple, one value string parameters but I am interested in dynamically populating table from (JSON 'flattened'/string) List<BusinessDetails> in the mentioned RDL.

I see the available parameter types are:

• Text
• Boolean
• Date/Time
• Integer
• Float

I guess my question is - can I use the Text/string param to dynamically populate a table in RDL?

Thanks.

Answer 1

short anser NO! long answer: you dont need that, using the report viewer control you can use the list directly as datasource, when using rdlc instead of rdl you can even consume the class in the reportdesigner, you dont have to come up with ways to align your data source mapping with the data you are recieving read this for further info: Creating a PDF from a RDLC Report in the Background