Crystal报告问题 [英] Crystal reports problem

问题描述

大家好，

我只是想出了一个小问题。我在报告时使用了水晶报告。

我用了五张桌子来报告。我我使用SQL语句来选择我想要的记录。

但是水晶报告会在不同的页面上显示每条记录（由sql选择），这使得它变得笨重。

I只是希望所有相关记录都显示在页面上。我该怎么办？



这是我用过的sql。

<预LANG = VB> <跨度类= 代码串> <跨度类= 代码串> SELECT * FROM [项目]，[WORK_ITEM]，[work_item_material_cost]，[work_item_labour_cost] ，& _
[work_item_equipment_cost] WHERE [project]。[project number] = [work_item_material_cost]。[项目编号]和& _
[project]。[project number] = [work_item_labour_cost]。[项目编号] AND [项目]。[项目编号] = [work_item_equipment_cost]。[项目编号]和& _
[project]。[project number] ='& str& <跨度类= 代码串> <跨度类= 代码串 >' SELECT * FROM [项目]，[WORK_ITEM]，[work_item_material_cost]，[work_item_labour_cost]，& _
[work_item_equipment_cost] WHERE [project]。[project number] = [work_item_material_cost]。[项目编号]和& _
[project]。[project number] = [work_item_labour_cost]。[项目编号] AND [项目]。[项目编号] = [work_item_equipment_cost]。[项目编号]和& _
[project]。[project number] ='& str& '

解决方案

只要在详细信息部分中保持分页控制尽可能接近......

Hi all,
I just came up with a little problem.I used crystal reports for my reporting.
And i used five tables for the report.I've used SQL statement to select the records that i want.
But crystal reports displays each record (selected by the sql) on a different page which makes it bulky.
I just wanted all the related records to be displayed on a page.What should i do?

Here's my sql that i used.

"SELECT * FROM [project],[work_item],[work_item_material_cost],[work_item_labour_cost]," & _
                                         "[work_item_equipment_cost] WHERE [project].[project number]=[work_item_material_cost].[project number] AND" & _
                                        "[project].[project number]=[work_item_labour_cost].[project number] AND [project].[project number]=[work_item_equipment_cost].[project number] AND" & _
                                        "[project].[project number]='" & str & "'""SELECT * FROM [project],[work_item],[work_item_material_cost],[work_item_labour_cost]," & _
                                         "[work_item_equipment_cost] WHERE [project].[project number]=[work_item_material_cost].[project number] AND" & _
                                        "[project].[project number]=[work_item_labour_cost].[project number] AND [project].[project number]=[work_item_equipment_cost].[project number] AND" & _
                                        "[project].[project number]='" & str & "'"

解决方案

Hi,
Just keep the page break control as much as closer in the details section...

这篇关于Crystal报告问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！