Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > Database and Reporting > Problem generating a number in Crystal Report 9


Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2003, 10:29 PM
mikechan8888 mikechan8888 is offline
Contributor
 
Join Date: Jul 2003
Location: HK
Posts: 436
Angry Problem generating a number in Crystal Report 9


Hi all,

I've a Crystal Report 9 report. It is going to print a sales order with many service orders in it. The only parameter it takes is the sales order number. I will assign a number to each service order just for easy viewing:

Quote:
Sales Order No.: 123
----------------------
1...SO583022...
2...SO573890...
3...SO783920...
The numbers (1, 2, 3, and so on...) can be generated by using the built-in field RecordNumber in CR. However, now my report needs to modify so that it will take the shop number as parameter and print all the sales orders belong to that shop.

It is OK to break each sales order into different pages by using the Grouping features in CR. But I don't know how to reset the number so that the first item for each sales order will start from 1. If I use RecordNumber, the number will just keep on increasing without reset.

Thanks in advance.

Mike
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Report 9 and VB Problem anotherDove Database and Reporting 7 10-24-2003 10:37 AM
VB -> Crystal Report problem tanminaik Database and Reporting 1 06-15-2003 12:14 PM
Crystal Report Sort Problem ashish908 Database and Reporting 3 05-13-2003 05:35 AM
pacman ghost AI VB6Newbie Game Programming 23 10-10-2002 07:32 PM
Crystal Report Problem Infoshare General 0 06-08-2001 03:12 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->