Recent content by AFK

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

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

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.

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.

Thanks synapsevampire.

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.

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

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

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

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

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

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.

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

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

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