如何使报表中的列动态化 [英] How to make columns Dynamic in a Report

问题描述

我正在使用Microsoft SQL Server 2008作为数据库，同时还提供报表服务.我正在使用Microsoft SQL Server BI Development Studio2008.下面重新说明一下我的情况:我有一个包含以下列的报告:
销售国家/地区，10月底销售，11月底销售在这种情况下是固定的，但10月末销售和11月底销售已更改，以便允许用户输入根据其条件进行操作.假设用户想要一个基于1月底和2月底的销售报告，在这种情况下就无法实现，因为仅固定了11月末销售和10月末销售的列.我希望这些列是动态的，因为销售报告必须根据两个月的时间来完成，当然这两个月会有所变化.我该怎么办?

I''m using Microsoft SQL Server 2008 as my database, as for reporting services I’m using Microsoft SQL Server BI Development Studio 2008. Let me rephrase my situation: I have a report with the following Columns:
Sales Country, End October Sales, End November Sales in this case Sales Country is fixed but End October Sales and End November Sales changes so as to allow user input to manipulate it according to their condition. Let say a user wants a sales report based on End January and End February, in this case it not possible to achieve that because columns are fixed for End November Sales and End October Sales only. I want these columns to be dynamic because sales report must be done based on the two months which of course changes. What can I do to achieve this?

推荐答案

选中此

如何动态添加新 [

Check this

How to dynamically add new columns to report created with Reporting Services?[^]

这篇关于如何使报表中的列动态化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！