如何以Win形式执行此模型RDLC报告? [英] How to do This Model RDLC Report in Win-form?

问题描述

我的RDLC报告中有一个问题.我正在使用Win-form，后端是MySQL.
这是我的桌子.列名Student no和Student name被错误地更改.抱歉

我的数据表

我的客户以其他格式询问.喜欢

I have One Problem In My RDLC report. I am using Win-form And Back-end is MySQL.
This is my table. Column Name Student no and Student name are mistakenly changed. Sorry for that.

My datatable

My Client Asking In Other Format. Like

  Student Name | Tamil | English | Maths |

jagadeeswaran | 50.00 | 20.0   |
Kalpana       | 90.00 | 30.00  | 10.00 |

我的问题是我没有每年多少科目.所以我做不到.
有没有可能做这种格式?帮帮我.
在此先谢谢您.

My problem is I don''t how much subject is in Each year. So I can''t able to do this.
Is any Possible to do this Format?. Help me.
Thanks in advance.

推荐答案

您可以使用PIVOT& UNPIVOT.
PIVOT-UNPIVOT [

You may use PIVOT & UNPIVOT.
PIVOT - UNPIVOT[^]

Then you can use Temp tables too.

这篇关于如何以Win形式执行此模型RDLC报告?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！