Crystal报告有帮助 [英] Crystal reports help

问题描述

我想为JobOrder制作水晶报告..

1.第一部分将是工作订单的详细信息 - 我可以做什么

2.详细信息它应该显示此工作订单的服务 - 我也可以这样做

3.它应该显示每项服务使用的项目 - 这是我需要你帮助的地方



每项服务的项目都是动态的，有些服务可能不会使用任何项目。物品的数量，它们的数量，它们的单位都来自数据库。下面是db模式..



http://www.vbforums.com/showthread.php?723479-Crystal-reports-help&p=4426593#post4426593 [ ^ ]







service_id包含sitem_id



第三部分应该是这样的：

服务1：item1 = 25cm，item2 = 40cm

服务2：

服务3：item6 = 90mm



如果有人需要任何更多的说明，请告诉我。



如果任何人都可以提供至少这是可能的水晶报告，因为我在vb开发Windows应用程序.net 2008，mssql 2005.

如果some1告诉我从哪里开始然后我将搜索那个也有帮助..我不知道这种类型的要求是什么意思



提前感谢

解决方案

首先，您需要选择要显示的字段报告中使用联接报告，如果需要放一些你需要的条件（item1 = 25cm，item2 = 40cm）



步骤1：你需要创建CrystalReport1.rpt

step2：创建数据集，选择要在报告中显示的字段和

添加项目列表的条件

步骤3：将数据集连接到CrystalReport1.rpt报告并设置条件

步骤4：在该文本框中为报告添加文本框和按钮，为动态提供动态值

项目1像25厘米，40厘米，然后单击按钮，它将生成您的CrystalReport

您给出的解决方案是针对normall cyrstal报告，我知道如上所述，但我的问题是不同的PLZ准备问题小心。

I want to make a crystal report for JobOrder..
1. the first part will be details of job order - which I can do
2. in details section it should show the services for this job order - this too i can do
3. it should show items used for each service --this is where I need ur help

items for each service is dynamic and some service may not use any items . the no.of items, their qty , their unit all coming from database. below is db schema..

http://www.vbforums.com/showthread.php?723479-Crystal-reports-help&p=4426593#post4426593[^]



service_id contains sitem_id

the third part should be like :
Service1 : item1=25cm, item2=40cm
Service 2:
Service 3: item6= 90mm

If anyone needs any more clarification let me know.

Please if anyone can give atleast is this possible in crystal reports as Im developing windows app in vb.net 2008, mssql 2005.
It would be also helpful if some1 tells me from where to start then I will search on that..I dont know what this type of requirement is said

thanks in advance

解决方案

For your crystal report first you need to pick the fields that want to show in reports using joins in query if need put some conditions that what you need(item1=25cm, item2=40cm)

Step1: you need to create the CrystalReport1.rpt
step2: create the data set in that select your fields that want to show in reports and
add where conditions for list of items
Step3: connect the data set to your CrystalReport1.rpt report and set the condition
Step4: Add text box and button to your Report in that text box you give the values in dynamic for
items1 like 25cm,40cm then click the button it will generate your CrystalReport

the solution you gave is for normall cyrstal reports and I know this as mentioned above but my problem is different plz ready question carefully.

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