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!

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

Recent content by AFK

  1. AFK

    Syntax error

    Here is my brackets Select t4.Company, t1.Order# , t1.CREATEDATE , (Convert varchar(20),t1.SHIPDATE ,20 )), (Convert(varchar(8),t1.REQUIREDATE ,1)) + ' ' + (Convert(varchar(8),t1.REQUIREDTIME ,108))), (Convert(varchar(20),t3.DELIVERYDATE,20)), DATEDIFF( hh ...
  2. AFK

    Syntax error

    I have a sql query that looks like Select t4.Company, t1.Order# , t1.CREATEDATE , (Convert(varchar20),t1.SHIPDATE ,20 )), Convert(varchar(8),t1.REQUIREDATE ,1) + ' ' + Convert(varchar(8),t1.REQUIREDTIME ,108), (Convert(varchar(20),t3.DELIVERYDATE,20)), DATEDIFF( hh ...
  3. AFK

    Cross Tab

    I added crosstab to my report but it seems like my report doesn't like the cross tab. Everytime I run it it errors out. It won't open the report. If I remove the crosstab tehn it will work. I have cr 8.5,SQL server 2000 and vb 6.0. Any idea.
  4. AFK

    Print Job fails

    I have a report. Everything looks fine but when my process go to the point where it has to 'Start the Print Job', it fails. It won't opent the report. It errors out. Any idea?I have CR 8.5v. I am using Vb 6.0 and SqlServer 2000 in conjunction with CR 8.5.
  5. AFK

    Group options missing

    Thanks synapsevampire.
  6. AFK

    Group options missing

    I am trying to group my weekdays on Weekly basis. SO I highlight the date and then click on group options but the dropdown where it says ->print for each week is missing. I can only see drop down where it says 'The report will be sorted by --Asending--desending-- I have CR 8.5 version.
  7. AFK

    Crystal Report loading

    The error message I am getting is when my program gets to the point where it has to open and print the report.Here is where I get the error... ' Start the Print Job Return value = Startprintjob(Printjobnumber,waitsforprintjobcompletion) If Return value <> ReturnValueokconstants Then...
  8. AFK

    Components

    What references and components do I need to include in VB for a report, if I have a crosstab and formula in report.
  9. AFK

    Crystal Report loading

    Still not working..I compare my crpe32.dll to all others. Everything is same. Still gives Error#5.
  10. AFK

    Crystal Report loading

    The CR software we use is Seagate Software v(8.5).Crystal Print Engine method is API.Print Engine DLL (Professional). Every workstation has the DSN I am using. Every user have the right over the Storedprocedure I am using to load data for CR. Now I can't catch the error as it works on my...
  11. AFK

    Crystal Report loading

    The error message says that "An undefined error has occured, please contact your system admin.
  12. AFK

    Crystal Report loading

    Crystal report version is 8.5.Database is SQL.I am calling this report through VB 6.0.I have a subroutine that calls the report, then print job opens it.The application I use is our company's own sotware.
  13. AFK

    Crystal Report loading

    I have a reoprt.That works just fine. when I click on print it will open and I can see it. But all other members of my company can not open it. It will error out to the point at which it is ready to open. Any ideas..Please...
  14. AFK

    Weekly reports based on dates

    Thank you very very much...It worked.I am sorry about that, but I was anxious about my report. This is my first report, and I am learning how to do it. But you helped me a lot..Thanks
  15. AFK

    Weekly reports based on dates

    But how do I use this function. I don't have help installed.
See more

Part and Inventory Search

Back
Top