数据报告中的序列号 [英] Serial Number in Data Reports

问题描述

我正在使用Visual Basic 6.0的数据报告，任何机构都可以告诉我如何在1,2,3,4,5,6,7,8,9等数据报告上垂直打印序列号。 ....................请回复。

I am using data reports of Visual Basic 6.0, can any body tell me that how I can print serial number vertically on the data reports like 1,2,3,4,5,6,7,8,9,..................... please reply.

推荐答案

我正在使用Visual Basic 6.0的数据报告，任何机构都可以告诉我如何在数据报告上垂直打印序列号，如1,2,3,4,5,6,7,8,9，... ................... 请回复。

I am using data reports of Visual Basic 6.0, can any body tell me that how I can print serial number vertically on the data reports like 1,2,3,4,5,6,7,8,9,..................... please reply.

选择记录计数中可能有特殊字段，这将打印SLNO ...

there may be special fields in that select record count this will print SLNO...

当你说垂直你的意思是你想要显示的数字是每个数字低于前一个数字吗？我的意思是序列号12345被打印为

When you say "vertically" do you mean that you want the number shown with each digit below the previous? I mean like serial number 12345 being printed as

1

2

3

4

5

1
2
3
4
5

???

是的我想要这个结果......

Yes I want this result...

1

2

3
4

5

1
2
3
4
5

我已尽力了......但问题仍未解决..我正在使用数据报告VB 6.0通过数据环境。我正在使用SQL Builder（在数据环境中），它给了我真实的结果。但是当我尝试使用序列号进行报告时。它产生了问题，要么序列号不以实际方式打印，要么在记录之间错过....


我正在为我的组织准备设备跟踪信息系统。

各个地点和总部都有很多电子设备。我有不同的表在MS Access中相互连接（使用关系数据库）。我正在应用以下查询来提取要在报告上打印的记录。

SELECT EQUIPMENT_MSTR.EQUIPMENT_ID，CATEGORY_MSTR.EQUIPMENT_CATEGORY，SUB_CATEGORY_MSTR.EQUIPMENT_SUBCATEGORY，BRAND_MSTR.BRAND_NAME，EQUIPMENT_MSTR.MODEL ，EQUIPMENT_MSTR.QUANTITY，LOCATION_MSTR.LOCATION，EQUIPMENT_MSTR.DESCRIPTION，EQUIPMENT_MSTR.DATE_OF_COMMISSIONING （SELECT COUNT（*）FROM EQUIPMENT_MSTR AS SNO WHERE SNO.equipment_id> = EQUIPMENT_MSTR.equipment_id）AS SLNO FROM LOCATION_MSTR，EQUIPMENT_MSTR，CATEGORY_MSTR，SUB_CATEGORY_MSTR，BRAND_MSTR WHERE LOCATION_MSTR.LOCATION_ID =" &安培; mLocId& "和LOCATION_MSTR.LOCATION_ID = EQUIPMENT_MSTR.LOCATION_ID和EQUIPMENT_MSTR.DOMAIN_ID = CATEGORY_MSTR.DOMAIN_ID和EQUIPMENT_MSTR.SUB_CATEGORY_ID = SUB_CATEGORY_MSTR.sub_category_id AND EQUIPMENT_MSTR.BRAND_ID = BRAND_MSTR.BRAND_ID ORDER BY EQUIPMENT_MSTR.EQUIPMENT_ID DESC


如果你考虑这个查询，你会发现一个子查询，这个子查询从表中计算记录并放置序列号。


但如果再看一下在这个查询我正在使这个查询更加过滤，我想要设备放在特定位置的记录，我在WHERE子句 LOCATION_MSTR.LOCATION_ID ="后写了这个查询。 &安培; mLocId& "


此查询从EQUIPMENT_MSTR获取记录并提供一些特定记录，但序列号不同......即1,2,3,4，..... .23，和67,68,69,70 ...... 85，和112,113,114,115,116 ......等等。


现在我想要这个序列号一个序列即1,2,3,4,5 ...... 23,24,25 .... 67,68，............ 116。

我希望你理解我的问题。

I have tried my best.... but the problem still not solved.. I am using data reports in VB 6.0 via data environment. I am using SQL Builder(In dataenvironment) which gives me the true result. but when I try for Serial Number for reports. It is creating problem, either the serial number does not print in actual way or it miss in betweent the records....

I am preparing a Equipment Tracking Information System for my organization.
There is so many Electronic Equpiment place at various Locations as well as in Head Office. I have different tables which are joined with each other(using relational database) in MS Access. I am applying the following query to extract the records to print on report.

SELECT EQUIPMENT_MSTR.EQUIPMENT_ID, CATEGORY_MSTR.EQUIPMENT_CATEGORY, SUB_CATEGORY_MSTR.EQUIPMENT_SUBCATEGORY, BRAND_MSTR.BRAND_NAME, EQUIPMENT_MSTR.MODEL, EQUIPMENT_MSTR.QUANTITY, LOCATION_MSTR.LOCATION, EQUIPMENT_MSTR.DESCRIPTION, EQUIPMENT_MSTR.DATE_OF_COMMISSIONING (SELECT COUNT(*) FROM EQUIPMENT_MSTR AS SNO WHERE SNO.equipment_id >= EQUIPMENT_MSTR.equipment_id) AS SLNO FROM LOCATION_MSTR, EQUIPMENT_MSTR, CATEGORY_MSTR, SUB_CATEGORY_MSTR, BRAND_MSTR WHERE LOCATION_MSTR.LOCATION_ID = " & mLocId & " and LOCATION_MSTR.LOCATION_ID = EQUIPMENT_MSTR.LOCATION_ID AND EQUIPMENT_MSTR.DOMAIN_ID = CATEGORY_MSTR.DOMAIN_ID AND EQUIPMENT_MSTR.SUB_CATEGORY_ID = SUB_CATEGORY_MSTR.sub_category_id AND EQUIPMENT_MSTR.BRAND_ID = BRAND_MSTR.BRAND_ID ORDER BY EQUIPMENT_MSTR.EQUIPMENT_ID DESC

if you consider this query you will find a sub query, this sub query count the records from a table and place serial number.

but if you again look at this query I am making this query more filtered, that I want thoes records that the equipment is placed at specific location and I wrote this query after WHERE clause LOCATION_MSTR.LOCATION_ID = " & mLocId & "

this query fetch the records from a EQUIPMENT_MSTR and gives some specific records but their serial numbers vary.. i.e. 1,2,3,4,......23, and 67,68,69,70......85, and 112,113,114,115,,116.....etc.

Now I want this serial number in one sequance i.e. 1,2,3,4,5....23,24,25....67,68,............116.

I hope you understand my problem.

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