如何在Crystal Reports中获得此输出?(How can I get this output in Crystal Reports?)
我已经使用SQL大约2年了,但我最近开始使用Crystal Reports 2013。
我需要将以下SQL转换为Crystal Report:
SELECT COUNT(orders.order_no), reason_codes.reason_desc FROM orders, reason_codes WHERE orders.reason_code = reason_codes.reason_code AND orders_reason.code IS NOT NULL GROUP BY reason_codes.reason_desc
我迷失了如何完成计数。 我正在寻找一个结果如下:
COUNT(orders.order_no), reason_codes.reason_desc 500 Broken in Transit 400 Broken in Warehouse
如上所述,在SQL中直接执行它似乎很容易,但在Crystal Reports中获取所需的输出似乎很复杂,我不知道从哪里开始!
I have been using SQL for around 2 years but I have recently started using Crystal Reports 2013.
I need to convert the below SQL to a Crystal Report:
SELECT COUNT(orders.order_no), reason_codes.reason_desc FROM orders, reason_codes WHERE orders.reason_code = reason_codes.reason_code AND orders_reason.code IS NOT NULL GROUP BY reason_codes.reason_desc
I'm lost as to how I go about getting the count completed. I am looking for an end result looking like:
COUNT(orders.order_no), reason_codes.reason_desc 500 Broken in Transit 400 Broken in Warehouse
It seems so easy to do it directly in SQL, as I have done above, but getting the desired output in Crystal Reports seems complicated, and I don't know where to start!
原文:https://stackoverflow.com/questions/28173215
最满意答案
嗨,对于那些对此感兴趣的人,我使用以下天真的程序编码方式解决了它。
对于xaml:
<StackPanel x:Name="testCompList" HorizontalAlignment="Left" Height="274" Margin="10,92,0,0" VerticalAlignment="Top" Width="361"> <Canvas x:Name="comp1" Margin="0,0,8,0" Height="26"> <Label Content="Test Component 1:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp1" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp2" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 2:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp2" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp3" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 3:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp3" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp4" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 4:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp4" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp5" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 5:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp5" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp6" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 6:" HorizontalAlignment="Left" VerticalAlignment="Top" Canvas.Top="3"/> <ComboBox x:Name="testComp6" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp7" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 7:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp7" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp8" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 8:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp8" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp9" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 9:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp9" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5"/> </Canvas> </StackPanel>
对于后面的代码:
int i = 1; private void addNewRow(object sender, EventArgs e) //all will invoke this generic method to display the visibility of the next { ComboBox selectedTest = (ComboBox)sender; Canvas thisRow = (Canvas)selectedTest.Parent; int index =Int32.Parse(thisRow.Name.Substring(thisRow.Name.Length-1, 1)); if (thisRow is Canvas && index==i) //needs to ensure that only the previous canvas can invoke the next canvas once selection is done { i++; Canvas newRow = (Canvas)this.FindName("comp" + i); newRow.Visibility = Visibility.Visible; //add the test Component to a data structure like a list or something } }
Hi for those interested in this, i solved it using the follow naive way of procedural coding.
For the xaml:
<StackPanel x:Name="testCompList" HorizontalAlignment="Left" Height="274" Margin="10,92,0,0" VerticalAlignment="Top" Width="361"> <Canvas x:Name="comp1" Margin="0,0,8,0" Height="26"> <Label Content="Test Component 1:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp1" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp2" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 2:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp2" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp3" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 3:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp3" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp4" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 4:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp4" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp5" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 5:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp5" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp6" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 6:" HorizontalAlignment="Left" VerticalAlignment="Top" Canvas.Top="3"/> <ComboBox x:Name="testComp6" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp7" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 7:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp7" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp8" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 8:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp8" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5" DropDownClosed="addNewRow"/> </Canvas> <Canvas x:Name="comp9" Margin="0,0,8,0" Height="26" Visibility="Hidden"> <Label Content="Test Component 9:" HorizontalAlignment="Left" VerticalAlignment="Top"/> <ComboBox x:Name="testComp9" HorizontalAlignment="Left" VerticalAlignment="Top" Width="207" IsEditable="True" Tag="Test Component" Canvas.Left="134" Canvas.Top="5"/> </Canvas> </StackPanel>
For the code behind:
int i = 1; private void addNewRow(object sender, EventArgs e) //all will invoke this generic method to display the visibility of the next { ComboBox selectedTest = (ComboBox)sender; Canvas thisRow = (Canvas)selectedTest.Parent; int index =Int32.Parse(thisRow.Name.Substring(thisRow.Name.Length-1, 1)); if (thisRow is Canvas && index==i) //needs to ensure that only the previous canvas can invoke the next canvas once selection is done { i++; Canvas newRow = (Canvas)this.FindName("comp" + i); newRow.Visibility = Visibility.Visible; //add the test Component to a data structure like a list or something } }
相关问答
更多-
由于网格项被包装除了覆盖preparecontainerforitemoverride之外,您无法在xaml中进行更改以实现它。 一个有点棘手的黑客就是将变换应用于按钮。
Since the grid items are wrapped You cannot make changes in xa ... -
我有同样的问题,你需要设置ListView prop pageSize为与列数相同的数字,在你的情况下它是3。 顺便说一句,我做了一个gridview组件来回应本机,做这个和更多,你可能想要检查出来, https://github.com/pavlelekic/react-native-gridview I had the same problem, you need to set ListView prop pageSize to be the same number as number of colum ...
-
用户选择第一个网格后如何自动生成下一个网格(How to auto generate the next grid after user have selected for the 1st grid)[2023-08-15]
嗨,对于那些对此感兴趣的人,我使用以下天真的程序编码方式解决了它。 对于xaml:我想到了。 问题在于我在DataSource定义了我的列和其他网格属性,而不是在它之外。 现在一切正常。 I figured it out. The issue was that I was defining my columns and other properties of the grid inside the DataSource instead of outside of it. All is working fine now.试试这个对我有用 在gridBound和dataBinding事件中的网格 dataBound = function (e) { var sender = e.sender; sender.content.scrollTop(sender.options.gridTop); } dataBinding = function (e) { var sender = e.sender; sender.options.gridTop = sender.content.scrollT ...Kendo UI网格 - 自动生成文本框的程序化更新(Kendo UI grid - programmatic update to auto-generated textbox)[2023-05-18]
事实证明,我没有必要在文本框上获得“jQuery ####”属性,甚至根本不使用文本框,并且可以使用具有我需要的下拉列表的EditorTemplate替换它。 所以在“视图”下,在“共享”文件夹中,我有一个“EditorTemplates”文件夹,并创建了一个名为“StatusComboBox.cs”的View里面,里面有一个Kendo DropDown: @(Html.Kendo().ComboBox() .Name("Status") .DataValueField("Value") ...您可以通过访问选择模型来获取选择的数量: theGrid.getSelectionModel().getCount(); You can get the number of selections by accessing the selection model: theGrid.getSelectionModel().getCount();extjs从第一个网格中选择记录并将所选内容复制到第二个网格(extjs select record from first grid and copy the selected to second grid)[2022-04-24]
你可以调用[[你的第一个网格]]。getSelectionModel()。getSelections(),它将返回一个记录数组 然后你需要将这个记录数组转换为第二个数组,让我们称之为数据,可由第二个商店的读者读取。 假设您的第二个商店是Ext.data.ArrayStore var store2 = new Ext.data.ArrayStore({ fields: [ { name: 'field1' }, { name: 'field2' } ] }); ...好吧,我发现我必须继承Grid,以便我可以覆盖Measure()和Arrange()布局步骤。 我并不认为这是一个很棒的通用解决方案,但它适用于我的场景。 请特别注意我不处理列,因为在我的情况下,只有一列。 我也没有在细胞内定位元素(我将它们固定在左上角)。 如果您需要更通用的解决方案,我认为这是一个非常好的开始。 列问题与行问题相同,只是在另一个方向上。 class NoStretchGrid:Grid { //this override determines what size we ask t ...Kendo网格更新 - 任何行的更新点击显示第1行详细信息(Kendo grid update - update click of any row shows 1st row details)[2019-11-23]
我想我在这里看到了问题。 从完成更新后我可以看出,您将在更新时返回整个数据集,即6月,1月,2月等。 在更新中,您只需将已更新的项目返回到网格 因此,在您的示例中,将返回json更改为以下内容: Return json(new { IntegrationRate}.toDataSourceResult(request,modelState),jsonbehaviour.allowget); 这应该解决你的问题。 因为要返回整个数据集,所以它将第一行呈现为预期结果。 正如您所说,您在后台看到数据正确保存。 ...相关文章
更多- Hadoop的I/O
- Lua 文件 I/O 操作
- javax.imageio.IIOException: Can't create output stream!的解决方案
- Hadoop I/O系统介绍
- Groovy 文件I/O 操作详解
- I18N 国际化 简介
- Mapreduce中的RCFile输出RCFileOutputFormat实现及其应用
- Hadoop1.0.4 HDFS I/O性能测试
- Java中如何用I/O流读取一个Word文档的内容?
- Bentley.STAAD.RCDC.V8i.04.01.01.03 1CD
最新问答
更多- 您如何使用git diff文件,并将其应用于同一存储库的副本的本地分支?(How do you take a git diff file, and apply it to a local branch that is a copy of the same repository?)
- 将长浮点值剪切为2个小数点并复制到字符数组(Cut Long Float Value to 2 decimal points and copy to Character Array)
- OctoberCMS侧边栏不呈现(OctoberCMS Sidebar not rendering)
- 页面加载后对象是否有资格进行垃圾回收?(Are objects eligible for garbage collection after the page loads?)
- codeigniter中的语言不能按预期工作(language in codeigniter doesn' t work as expected)
- 在计算机拍照在哪里进入
- 使用cin.get()从c ++中的输入流中丢弃不需要的字符(Using cin.get() to discard unwanted characters from the input stream in c++)
- No for循环将在for循环中运行。(No for loop will run inside for loop. Testing for primes)
- 单页应用程序:页面重新加载(Single Page Application: page reload)
- 在循环中选择具有相似模式的列名称(Selecting Column Name With Similar Pattern in a Loop)
- System.StackOverflow错误(System.StackOverflow error)
- KnockoutJS未在嵌套模板上应用beforeRemove和afterAdd(KnockoutJS not applying beforeRemove and afterAdd on nested templates)
- 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
- android - 如何避免使用Samsung RFS文件系统延迟/冻结?(android - how to avoid lag/freezes with Samsung RFS filesystem?)
- TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
- 企业安全培训的各项内容
- 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
- C#类名中允许哪些字符?(What characters are allowed in C# class name?)
- NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
- 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
- 将多个行和可变行移动到列(moving multiple and variable rows to columns)
- 提交表单时忽略基础href,而不使用Javascript(ignore base href when submitting form, without using Javascript)
- 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
- Angular $资源不会改变方法(Angular $resource doesn't change method)
- 在Angular 5中不是一个函数(is not a function in Angular 5)
- 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
- 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
- 常见的python rpc和cli接口(Common python rpc and cli interface)
- Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
- 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)