水晶报告打印问题 [英] Crystal report Printing Problem

问题描述

i am Stuck on Crystal报道..我的问题是我需要使用两张桌子打印采购详情



1。客户表

2.Menu表..

客户表只有一行，但菜单表有更多然后一行和每个表的QNo相同.. 。

i写下面的查询

mysql> SELECT a。*，b。* FROM tb_customer INNER JOIN tb_Menu b ON a.id = b.Qno WHERE Id = 1/1 AND a.id = b.qno GROUP BY menuname



在Crystal报表查看器中显示但是，菜单详细信息只打印一条记录每页，下一页打印第二个记录为什么？同时我使用菜单的子报告，它将打印出我预期的很好，但问题是如果菜单有5记录menas整个报告将打印5次？帮帮我..



我想打印那样

客户详情

Qno：100

姓名：用户名

地址：xxxx

菜单详情

早餐

1.Apple Juice

2.Orange Juice

3。汉堡

午餐

1.Bread Omelet

2.Milo

Hi ,
i am Stuck on Crystal report .. my problem is i need to Print Purchasing Details using Two tables

1.Customer table
2.Menu Table..
customer table has only one Row, but menu table has More then One Rows and "QNo" is Same for each table ...
i write that below Query
mysql>SELECT a.*,b.* FROM tb_customer a INNER JOIN tb_Menu b ON a.id=b.Qno WHERE Id= 1/1 AND a.id=b.qno GROUP BY menuname

In Crystal report viewer it display but , menu details print only one record per page, next page it print second Record why ? at the same time i used sub report for Menu ,, it will print nicely as what i expected , but the probles is if a Menu has "5" Records menas the whole report will print 5 times ? help me..

I want to Print Like that
Customer Details
Qno: 100
Name :UserName
Address : xxxx
Menu Details
Breakfast
1.Apple Juice
2.Orange Juice
3.Burger
Lunch
1.Bread Omelet
2.Milo

推荐答案

Hai

水晶报告有以下部分



Crystal Reports默认提供五个主要部分：

报表页眉 - 此部分中的字段在报告开头打印一次

页眉 - 此部分中的字段打印在每个新页面的开头

详细信息 - 此部分中的字段随每条新记录一起打印

报表页脚 - 此部分中的字段在报告结尾打印一次

页脚 - 放置在此页面中的字段在每个新页面的底部打印





在详细信息或报告页脚部分，您需要检查，尝试减小尺寸，我认为在详细信息部分记录之间有很多空间，所以只能在一个页面中打印一行。



尝试减少所有部分高度，如点击和拖动up

Hai
Crystal report have followin sections

Crystal Reports by default provides five main sections:
Report Header – fields placed in this section are printed once, at the beginning of the report
Page Header - fields placed in this section are printed at the beginning of each new page
Details – fields in this section are printed with each new record
Report Footer - fields placed in this section are printed once, at the end of the report
Page Footer - fields placed in this section are printed at the bottom of each new page


In Details or Report Footer section u need to check,try to reduce the size,i think in Details section have lot of space in between records,so only print one row in one page.

Try to reduce all section height,like click and drag up

两种方式



使用群组

在ASP.NET中创建包含多个表的Crystal报表 [ ^ ]

或

使用子报告

C＃Crystal Reports - 子报告 [ ^ ]

C＃Crystal Reports - 按需子报告 [ ^ ]



自定义

Two ways

Using Groups
Creating Crystal Report with Multiple Tables in ASP.NET[^]
OR
Using Subreports
C# Crystal Reports - sub reports[^]
C# Crystal Reports - on demand sub reports[^]

Customize it

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