Search results for query: *

I copied this incredible crosstab procedure, but for some reason, I get bunch of errors trying to create. I am sure I am doing something wrong. Thanks. Osher Here are the errors received: Server: Msg 170, Level 15, State 1, Procedure spCrossTabRun, Line 50 Line 50: Incorrect syntax near ','...

donutman, I copied your incredible crosstab procedure, but for some reason, I get bunch of errors trying to create. I am sure I am doing something wrong. Thanks. Osher Server: Msg 170, Level 15, State 1, Procedure spCrossTabRun, Line 50 Line 50: Incorrect syntax near ','. Server: Msg 156...

Tried earlier and it didn't work. I also tried set location and I could see the new column, but once I tried to save, CR will crash. Osher

I have a crystal report based on a stored procedure and everything works well. Now I added a column in the procedure, but I have a problem to make show in the current report. Is there a way without recreating the whole report? Thanks, Osher

I am using Access to query FoxPro database. I am trying to have multiple distinct counts. The query works with one distinct count but not with multiples. Here is the query, any ideas? Osher SELECT trnsdate, count(distinct(ordernbr)) as ord_count, count(distinct(ticketnbr)) as employee...

Here what I use for listing macros. just replace "scripts" by "reports" and you should be good to go. Sub Form_Open(Cancel As Integer) On Error GoTo Err_OF Dim db As DATABASE Dim I% Dim contr As Container Dim strReportList$ Dim StrReportName$ Dim...

I have 3 generic users setup on NT box. A large number of users connect at the same time using these generic users. Is there a way to terminate inactive sessions (let's say after 15min) without terminating all other sessions connected as the same users? Thanks, Osher

I use *.qry file in Enterprise reports and they work fine. Does your report work in regular CR? What version of Crystal Report you have? There are some diff. between 8 and 8.5 and some CR8 reports will not work in Enterprise. My problem is using date parameters with oracle sql. With string I...

Hi, I have a crosstab query that runs well in Access, brings some of data when run in ASP, but not all the data. The query: SELECT TBLE, ADJ_CODE, SUM(DECODE(DAY, '01-MAY-01', ext_val)) "01-MAY-01&quot...