困难的案例 [英] Difficult Case
问题描述
你好,
我正在编写一份报告,我遇到了一个我需要一些建议的街区。在附图中,我显示了人员ID和他们获得奖励的日期。在后端有一个(每个奖励类型的奖励金额列)。我将它们添加到报告后面的SQL
中以获得累积值。我设置了日期参数,无论用户输入的日期如何,它都会呈现客户已经实现的报告。至少一个奖励。现在我想在选定的时间段内添加
客户赚取的金额。据我所知,至少根据我的专业水平,这是不可能的。如果我创建一个单独的数据集,即使那时我也无法将其添加到报表中。有办法吗?
I am developing a report and i came across a block where i need some advice. In the attached image i am showing the person id and the dates they were rewarded. In the back end there is a (reward amount column per each reward type). I added them in the SQL behind the report to get the cumulative. I have date parameters set in such a way where irrespective of the dates entered by the user it will render report where the customer has achieved at least one reward. Now i want to add the amount earned by the customer within the period selected. This according to me is not possible at-least according to my level of expertise. If i create a separate dataset even then i cannot add that to the report. Is there a way ?
谢谢
SV
推荐答案
您好saivenkat77
Hi saivenkat77
根据你的描述,仍然对你的要求感到困惑。
According to your description , still confused about your requirement .
似乎你想得到总和
金额 客户在一个日期时间内赚取。
Seems you want to get the sum amount of customer earn in one date time.
喜欢从6/7/2018到7/4/2018对吗?
如果是这样,你可以尝试添加两个参数作为开始日期和结束日期,并在数据集查询中使用该参数。
不清楚您的报告结构和要求。
如果可能,您可以提供详细的rdl文件,数据样本和所需的预览屏幕截图给我们进行更多的研究。
(你可以在云盘上发布一个驱动器)
希望得到你的回复。
最好的问候,
Eric Liu
这篇关于困难的案例的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!