Hey,
This program i've been working on is still being a pain. What i hate most is how the SQL syntax is different for VB and CR.
How would I go about setting a recordset in VB and passing that recordset to CR4.0? Thus making the report generated display only the information in the recordset...
Blast. I just realised that I need the SQL code for the selection formula to run it through Crystal Reports. The syntax that's been suggest, as well as what I've been doing, are wrong.
So...I need the Crystal Reports SQL syntax.
More work for me,
cpch
Omega: i'm still working on implementing yours, its a little more involved than I hoped it would be.
Menon: sorry, but it didn't work. You can't use an aggregate function in the WHERE clause of an SQL statement.
Still working' away, thanks!
cpch
Hello everyone,
Got my third, and hopefully final question and I'll be done this program.
Everytime someone shows up late, a record is made in the database with the Time, Date and Employee number. I've been using crystal reports 4.0 I think. I can report lates for each employee, as well as...
Oh, the program also seems to be taking the variable strGlobalEmpID at face value. It's actually comparing {Employee.ID} with "strGlobalEmpID"
The exact result was:
{Employee.ID} = '" & strGlobalEmpID & "'
I've been trying different syntax since yesterday, but it hasn't really be working out.
I've also tried splitting the SelectionFormula into two parts; the table {Employee.ID} and the variable, strGlobalEmpID. That's...
Hi again,
After sorting out the problem w/ the parameters and crystal reports, I've got another one.
Originally I had intended to have only one report in my program. I stored the report name, description and the filename in a table. I can call the filename and such from the table and...
You could try using the Packaging & Deployment wizard in VB. It'd be under the add-in menu, then select the "Add-In Manager...", it'll be in there.
When you run the P&D thing it'll search through your program and list all the .dll and .ocx files that your .exe uses. It can create a...
Hey,
I'm still working away on that dB program I had questions about before. We need to use some sort of Report function, and we decided that Crystal Reports (v4.5) would probably be the easiest way to do it. Boy, were we in for a surprise.
There's very little documentation about how to...
Hi,
I've been tasked with making a system to track the lates/absent records of the people around here. After a a few months, I finished a working beta version.
So, when I go and install it on the computer it needs to run from, boom. Error time.
Run-time error '429'
ActiveX component can't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.