英文:
SSRS Lookupset showing every item associated with the account in one cell
问题
我目前正在制作一份带有关联合同价格的明细列表,但由于表格的设置方式,我无法将所有内容都放在同一个数据集中,因此我一直在使用lookupset表达式,但我找不到将列中的项目分开成单独行的方法。我的所有价格都是正确的,但与该合同账户相关的每个项目都显示在每个价格单元格中。
项目 | 价格 |
---|---|
项目1 项目2 | 价格 |
项目3 项目4 | |
项目5 项目6 | |
项目1 项目2 | 价格 |
项目3 项目4 | |
项目5 项目6 |
我只需要一个解决方案,将项目分开到它们自己的单元格中,价格与之对齐,如果需要添加代码,那是可能的,但我找不到方法。
英文:
I am currently working on making an itemized list with the associated contract prices but because of how the tables are setup I cannot have it all in the same dataset, so I've been using the lookupset expression, but I can't find a way to separate the items in the column into individual rows. All of my prices are correct, but every item associated with that contract account shows in each price cell.
Item | Price |
---|---|
Item1 Item2 | price |
Item3 Item4 | |
Item5 Item6 | |
Item1 Item2 | price |
Item3 Item4 | |
Item5 Item6 |
I just need a solution to break up the items into their own cells with the price lining up and if I need to add code to it then that's possible but I can't find the way to go.
答案1
得分: 0
很抱歉,您将无法将连接的数据拆分为单独的行。
我认为最简单的解决方案是使用子报表。
创建一个新的报表并使用另一个数据集。创建一个包含项目(和价格?)的表格。您可以复制当前的报表并删除您不需要的项目。
然后将子报表添加到原始报表的表格中,并将CustomerCode作为参数。
比LookUpset更容易制作和运行更快。
英文:
Unfortunately, you will not be able to break up JOINed data into separate rows.
I think your easiest solution is a subreport.
Make a new report with the other dataset. Create a table with the Items (and price?). You could copy your current report and delete the items you don't need.
Then add the subreport to the table in your original report with the CustomerCode as the Parameter.
Easier to make and runs faster than the LookUpset.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论