Search results for query: *

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.

lbass and synapsevampire I need quick help please. I am almost finished with this report. Please advise how do I set up to start from monday through friday, instead of Sun through Sunday, based on dates. Everything works fine.But the report prints data from One sunday to other and I need from...

Thank you very much all of you. It did work for me.But.. the only one item is when I send a date my report picks each week's sunday instead of starting from Monday. I want this to start from monday to friday. How do I do that?

Yes the Cross-tab is good idea, but the problems is that my report consists data for 10-15 centers and Cross-tab shows each center seperately, I can not make it one whole creoss tab(or may be I don't know how to make it one with multiple columns).Now instead od one I have as many cross-tabs as...

How are you getting your weeks? Is it something you want to do, or are you aready doing it. Here is the problem, I don't know weather the dates that user will provide is for a week or two weeks or just couple of days.User can select any two dates (From @DateEnter to @DateResolve)...

I am trying to get a report based on the dates that I will send as parameter. I can select any date range lets say sdt_dateentered = '08/01/04' and sdt_dateend = '09/03/04'.So when I enter this date the report should be in formatt of multiple weeks(for each week from Aug to Sept.), and each week...