scbdpm
asked on
Creating a printed report (without Report Designer or Crystal)
I have an app and one of the main forms has a fairly large number of controls to display data.
The form is populate via a number of SQL queries (ADODB recordset, etc).
Now I would like to be able to print out a report.
The way the app flows: The end-user selects from Form1 their choice. Form2 (with the large # of controls) displays the information. Now I would like to make that my report....
Without using DataReport (as I am not currently using a DataEnvironment to fetch my data nor using Crystal (too $$$), how can I do this without the painful method of: printer.print for each of my fields.....
Am looking for some options. Would appreciate low cost but am willing to spend some $$.....
The form is populate via a number of SQL queries (ADODB recordset, etc).
Now I would like to be able to print out a report.
The way the app flows: The end-user selects from Form1 their choice. Form2 (with the large # of controls) displays the information. Now I would like to make that my report....
Without using DataReport (as I am not currently using a DataEnvironment to fetch my data nor using Crystal (too $$$), how can I do this without the painful method of: printer.print for each of my fields.....
Am looking for some options. Would appreciate low cost but am willing to spend some $$.....
If you only have VB 6, it has an old versioin of Crystal. It is a separate install.
mlmcc
mlmcc
ASKER
I am using VB6.
Could you tell me how I can use the older version of Crystal?
This is new to me, this is the first I've heard of it....
Could you tell me how I can use the older version of Crystal?
This is new to me, this is the first I've heard of it....
You need to install from the VB6 CD.
I forget where it is. I think if you use Windows Explorer and look on the CD for Crystal or CRW.* you will find the folder. It has a setup. simply install and run it.
mlmcc
I forget where it is. I think if you use Windows Explorer and look on the CD for Crystal or CRW.* you will find the folder. It has a setup. simply install and run it.
mlmcc
ASKER
I just looked over the install CD.
Search for CRW and crystal.. no luck.
Tried to 're-install', didn't see Crystal as an option.
This is VB^ pro I am using....
Search for CRW and crystal.. no luck.
Tried to 're-install', didn't see Crystal as an option.
This is VB^ pro I am using....
It is not available from the VB installatiion. It is a separate install and MS did a good job in hiding it. I believe it is there in VB Pro.
Look in
\COMMON\TOOLS\VB\CRYSREPT
The file is
CRYSTL32.EXE
mlmcc
Look in
\COMMON\TOOLS\VB\CRYSREPT
The file is
CRYSTL32.EXE
mlmcc
ASKER
Alternatives?
I have only one install CD for Visual Studio (?^) and the file/folder you mention are nowhere on that cd...
I also checked on my HDD and don't find it there either....
I have only one install CD for Visual Studio (?^) and the file/folder you mention are nowhere on that cd...
I also checked on my HDD and don't find it there either....
Do you have Visual Studio or Visual Basic?
If you have Visual Studio 6 then there should be more than one CD. As I recall Crystal is on CD 2 or 3.
mlmcc
If you have Visual Studio 6 then there should be more than one CD. As I recall Crystal is on CD 2 or 3.
mlmcc
ASKER
I have three total CD's to install. One for VB and the other two are MSDN......
It is there on mine and according to the MS link above it is there.
Are you sure it is VB Pro?
mlmcc
Are you sure it is VB Pro?
mlmcc
ASKER
I thought so.
Everytime the splash screen shows, it was Visual Basic 6.0 Pro....
Everytime the splash screen shows, it was Visual Basic 6.0 Pro....
Sounds like VB Pro but are the CDs just VB or are they VS?
mlmcc
mlmcc
ASKER
I'm not working from the originals....... but have only one that is labeled VS
You may have VS Enterprise, in which case it is on disk 2.
mlmcc
mlmcc
ASKER
But I only have one CD..........
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What database? SQL Server includes SRS a reporting tool.
mlmcc