Search results for query: *

Hello all. I thought I was able to find my AUTOSAVE files in the past. I even created a shortcut to my temp folder called CRYSTAL AUTOSAVES. But nothing is writing there. I search my whole C drive and nothing named with the partial name *autosave.rpt comes up. I do have CR (V XI) set to...

Hello all. I started a question on the IBM servers forum. Since I am trying to access via Crystal Reports I figured I'd start a topic here with the link to it. http://www.tek-tips.com/viewthread.cfm?qid=1479558&page=1 Thanks Regards, Mark H. Edwards http://www.datareportconsulting.com

Hello. I have often connected Crystal Reports to AS400 tables using the Client Access ODBC driver. But now for the first time I am trying to access an AS400 Stored Procedure. And we keep getting errors (depending how we tweak the Driver settings). The initial error being: Database Connector...

:-) Regards, Mark H. Edwards http://www.datareportconsulting.com

OK, thanks. So I'm not crazy. There was a change from the older versions. Regards, Mark H. Edwards http://www.datareportconsulting.com

Hello all I have often copied parameters from one report into another. Parameters that are not tied into a table. But I find that in Version XI, I can't. It allows me to "paste" it into the new report but the parameter doesn't appear where I pasted it, nor does it appear in the Field Explorer...

OK To be clear, the module is inside an Access Query. I am trying to use the Access Query in Crystal. Regards, Mark H. Edwards http://www.datareportconsulting.com

There's alot going on in the query. Access has to use the date parameters to choose the records before rolling them up into YYYYMM buckets. By the time the data is fed to Crystal, true dates are gone. Only YYYYMM buckets remain. And sometimes the YYYYMM buckets are only supposed to be a...

Hello all. I have a question that was brought up here: http://www.tek-tips.com/viewthread.cfm?qid=1276962 But the workaround was not actually posted by SOUTHWESTNUT. I have an Access module named EndDate (Function name End_Date) to identify one of four date options from a parameter. I put...

Hi everyone. Does anyone have any ideas about the UNDEFINED FUNCTION error I get in Crystal? should better post this in the Crystal forum now, since its probably more a Crystal issue. Regards, Mark H. Edwards http://www.datareportconsulting.com

Hi everyone I have had sucess with using the module approach. I use the module in the WHERE critertia and the query gives me what i want. Thanks Howevever now when I try and use the Query in a Crystal Report, Crystal won't let me add the query to the report. I get the following error: Query...

EndingDate is a string parameter. I made it a string for a reason but now as I think of it I could probably change to a date type. But for now it is a string. The code makes it into a date field (Dateserial) PeriodEnding is an number. Perhaps Integer is the wrong number format? Is there...

Yeah I realized that after I posted. Its because at te time i had put the module back to AS STRING temporarily. So then I went back and put the mocudule back to AS DATE, saved it, and went into BUILD and when I chose the function the quotes were gone <=WhichDate(«PeriodEnding»,«EndingDate»)...

Didnt help. I then tried choosing the function from within the BUILD window in Design View, which gave me this code: <=WhichDate("«PeriodEnding»","«EndingDate»") But when I go to run it I get a DATA TYPE MISMATCH IN CRITERIA EXPRESSION Regards, Mark H. Edwards...

OK sounds ike its a good idea...I'll try it Regards, Mark H. Edwards http://www.datareportconsulting.com

Tried recplacing the exclamation points with periods. Didn't help. Still getting the same message Regards, Mark H. Edwards http://www.datareportconsulting.com

Alex Thanks Those run fine when the date code isn't present. But I'll try it. Regards, Mark H. Edwards http://www.datareportconsulting.com

Yes the Date field is a Date. I changed the DIM to AS DATE, still getting the same error. Here is the WhichDate Function: -------------------------------------------- Function WhichDate(PeriodEnding As Integer, EndingDate As String) Dim out As Date Select Case PeriodEnding Case 3...

OK I renamed the Module I also modified Alex's code to remove the spaces in the parameters since the module didnt have spaces and also added the >= sign: >=WhichDate([PeriodEnding],[EndingDate]) Now when I run it the error message is: THE EXPRESSION IS TYPED INCORRECTLY, OR IT IS TOO COMPLEX...

Thanks! I'll try that first thing Friday if not sooner Les Paul...the man, the guitar, the programmer named Leslie! Regards, Mark H. Edwards http://www.datareportconsulting.com