Is there any way to change the type and signature type of sql type at runtime?

Question

Is there a way to change the SQL type "chart type" and "subtype" at run time?

I am working with a .rdlc report and cannot figure out how to change this at runtime. I don’t have the “Expression” option in any of these fields.

Answer 1

It looks like this might not be possible until 2008: Microsoft Link

Answer 2

Your .rdlc file contains everything that is listed in your report, including the type of report. Therefore, in cases where I want to change something in the report, I simply modify the rdlc file using my favorite xml editing method (XmlDocument, XPath, etc.). You simply change your RDLC file on the fly to change the type of report, then display or save anything.

I did this so that users can set their own report colors, for example, since they are also defined in rdlc.

Answer 3

I am trying to do the same. I have a set of measures that are shown, and then a chart below that will show only one dimension at a time, depending on user input (which measure do they want to see in chart form). However, some measures are better than columns instead of rows, so I would like to change the type of chart during rendering.

My initial idea is to overlap the two diagrams and set their visibility opposite each other and in accordance with the drop-down user input. It seems like there might be an easier way (if this idea works first?)

Thanks.

Answer 4

I use 2008, and as far as I understand, it is not solved there. There are so many options like a chart, and then even more in a subtype, I would not want to display them, and then show or hide the correct one.

I am wondering if there is a way to parse the XML .rdlc file and send it back to the report viewer without each user having their own new modified version of the actual .rdlc file.

On the other hand, MS has just released a new mapping package (from the acquisition of Dundas). Perhaps I will drop the idea of ​​a report and move on to server management mschart.

Answer 5

One possible solution would be to create both charts that you wanted, and then hide one of them based on your requirement.

Answer 6

Think of a few meanings and visibility. If all other variables are constant (i.e. Category, Series, etc.), simply add a value for each of the desired chart type and use the parameter to control the visibility of the value. Elegant and simple.