Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chrispchenry

    Passing Record sets to Crystal Reports 4.0

    thanks! this looks like it'll work!
  2. chrispchenry

    Passing Recordset to CR

    hi ken, how do I create a report using the Active Data Driver? I'm pretty new with CR. Thanks again, cph
  3. chrispchenry

    Passing Recordset to CR

    Hi, How do I pass a recordset to a Report? thanks.
  4. chrispchenry

    Passing Record sets to Crystal Reports 4.0

    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...
  5. chrispchenry

    SQL Query to find records with a certain number of recurrances

    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
  6. chrispchenry

    SQL Query to find records with a certain number of recurrances

    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
  7. chrispchenry

    SQL Query to find records with a certain number of recurrances

    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...
  8. chrispchenry

    Getting Crystal Report SelectionFormula from dB

    nah, that doesn't work. i'm using CR 4.5
  9. chrispchenry

    Getting Crystal Report SelectionFormula from dB

    Oh, the program also seems to be taking the variable strGlobalEmpID at face value. It's actually comparing {Employee.ID} with "strGlobalEmpID"
  10. chrispchenry

    Getting Crystal Report SelectionFormula from dB

    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...
  11. chrispchenry

    Getting Crystal Report SelectionFormula from dB

    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...
  12. chrispchenry

    Crystal Reports Integration Problems

    nevermind, i figured it out
  13. chrispchenry

    Error 429 ActiveX Component can't create object

    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...
  14. chrispchenry

    Crystal Reports Integration Problems

    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...
  15. chrispchenry

    run-time error '429'

    Thanks!
  16. chrispchenry

    run-time error '429'

    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...

Part and Inventory Search

Back
Top