Search:

why not show an MDI form to the user?

BTW,

I'm using the System tray when the user minimizes the system that I have developed.

You need to register your CRPE32.dll

1. Run command prompt
2. Make sure it is "C:\Windows\System32:" if its 32 bit and SysWow64 if its 64 bit.
3. Type "regsvr32 CRPE32.dll"
4. Press Enter

A...

I'm using windows 7, but I tried to find that cpre23.dll but I don't have that in my computer...

By the way, I'm using Crystal Report 8.5 and VB6.

Can you explain further?

Hahaha! Haven't used that Add-In too! New knowledge acquired. :rolleyes:

Sorry but its not customizable, it's either every line you will put a single quote ( ' ) at the beginning.

MS Access or any RDBMS (for now) in my experience, cannot handle that kind of auto-numbering.

You need to have that kind of formatting using a Program (mine I use VB6 or VB.Net)

I think that's not what @Sam meant about



:bigyello:

dee-u has already given the solution... :rolleyes:

what do you mean fetch? will it print a report automatically?

or you want to populate a SQL table with data in a time basis?

If you're referring to the 2nd part, Crystal Report is nothing to do...

Sample data...

L-R

Original table

Duplicate Table

Even Table

From Left to Right:

L-R

1st pic:

Original table (named TBLUSERS)

2nd pic:
Duplicate table from the Original Table with AUTO-INCREMENT (named TBLUSERSTEST)

Header sa 2nd RIGHT PIC MO,

gagawin mo din sub report yan... para sa EVEN IDs mo.

yung blue na box.

120815

yes pwede yun, susubreport mo yung details mo,

bale 3 sub reports gagawin mo... ^_^

1 - for the EVEN IDs (parang main report mo)

2 - for the details of the subreports.

Main report lang ang i-duduplicate at triplicate mo....

Duplicate is for the Main Report Fields + the Autoincrement no.

Triplicate is for the EVEN IDs...

I mean yung Main table mo, yung Details nya is yung nasa main report mo?

So mangyayari dyan, yung 1st table mo i-jojoin mo sa 2nd table mo, <main table>.AAEmpno = <2nd table>.Empno

Create ka ng new table,

yung main report mo, papasok mo yung data na andyan sa Main Table mo,

Tapos lagyan mo ng Integer na nag-au-auto increment.

yung 2nd report mo? naka-join sa main...

naka-provide na yung step by step, nasa taas na... :rolleyes:

Nope I don't have a sample project,

I just tested the database tables that I have here in the office.

About Virtual tables, if you want to use that kind of style, you need to make your SOURCE...

@Salsa I think I got what DM's what to say...

What if Salsa has 30 pts. ok...

Then of course you have a list of prizes...

e.g.
Fan = 10
Radio = 25
TV = 30

Create a new Thread so that we can address to your problem.

Requirements:

2 - tables
1 - Subreport
1 - Crystal Formula

---

1st table - (same fields from your Main Source), with additional field ID or something that MUST be AUTO INCREMENTED
2nd...

Ei @bjay_tiamsic26...

just found a solution for your INQUIRY... :bigyello:

tried and tested...

120765

Oh... finally resolved... Good job... :wave:

Dim HKEY_CLASSES_ROOT, HKEY_CURRENT_USER, HKEY_LOCAL_MACHINE, HKEY_USERS

can you give me an insight, what and when is it used?

I'm not that good when it comes to APIs.

Public Enum hiveKey
HKEY_CURRENT_USER = &H80000001
HKEY_LOCAL_MACHINE = &H80000002
End Enum


Dim HKEY_CLASSES_ROOT, HKEY_CURRENT_USER, HKEY_LOCAL_MACHINE, HKEY_USERS

You have those 2...

The hard part on the user, is when the user types numbers before putting a negative sign (-) and needs to delete the whole textbox just to type the negative sign...

But it' up to you how you will...

Don't know what you want to do or when will be shown 00##-#### or 0###-####...

Here's a sample:


String(3, "0") & Left(Hex(98906), 1) & "-" & Right(Hex(98906), Len(Hex(98906)) - 1)

The easiest solution to your problem doesn't lie on the Crystal Report, but in the query you are using for the source of your report.

Try to remove the duplicates from there first before going to...

Update:

Di pala pwede gamitin yung FORMULA (SHARED VARIABLES) sa Subreports, hahaha! sakit din pala sa ulo pinapagawa ng client mo... :P

I haven't tried it yet actually, parang pure logic pa lang yan, kasi di pa naman pinapagawa sa akin ang ganyang project. try ko minsan.

Kaya 2 sub reports gagamitin mo, kasi may GLOBAL variable ka, which contains your "Auto-number" ID. (starts from 1 to number of records)

bawat galaw ng Sub Report, nag uupdate yung Variable na...

Unti untiin natin, gawin mo muna yung sa Virtual table before tayo punta sa next step, mahirap magmadali. masmaganda kung pulido ang ginagawa saka tayo punta sa next.

Tutorials:...

Ganito gawin mo 2 subreports (pero same format):

Dapat yang data mo naka virtual table yung isa.

I guess yung 1st column mo dyan e yung Employee number (key mo yan sa inner join mo).

Sa...

It means you have 2 tables?

Am I correct?

You can still use 2 subreports then. :ehh:

---

I think we are the only two who talks in this thread, so we can use our native language then... ...

updated code


Dim number As Integer
number = Val(Me.Text1.Text)
Select Case number

Case Default 'none of the above
strreply = "You typed in number zero"

So did you finished working on it? :)

Your Virtual Table will be like your Payslip Table

You will just add 1 column for your tracing number 1 to Number of records.

That will be your guide in printing your payslip. and tell the CR...

Another tip:

Use GLOBAL VARIABLE, because you will use it in both of your SUBREPORTS... (UPDATE IT PER SUBREPORT)

Can't elaborate it yet, but I know it will work.

---

To answer your...

You can do it actually, now I know,

You need to put your records to be printed inside a VIRTUAL TABLE in your SQL, with a TRACE NO. (1-# of records in your virtual table)

With that you can put...

That's true... man that's the hard part.... :(

Is it requested by the client?