Recent content by elaineva

Thanks WarrenRoss..... dgillz....we are using Crystal 7 - which compiles reports. I was told by Crystal helpdesk (yrs ago when Crystal 7 was still supported) that you could not compile a report using 2 different logins.....

Recommendations please.....has anyone had experience with Data Direct software? I write Crystal reports using an ODBC driver to connect to an Oracle database. I also write reports using a different ODBC driver to connect to a Sequel database. I can create a report using both databases with...

Thanks....I'll give it a try.

I'm using Cry 7

Can you sort on a calculated field in a grp footer? I have a calculated percent field based on 2 tot fields created in the grp footer and want to sort on the new percent field. The field does not show up as a sort field.

I am having a problem with a linked table (Oracle 73.ver2.5) and Access 2002. All other linked tables are coming across great except for 1 table – and the only difference I can see is that there is a memo field. When I look at this table in Access – all fields show as #Name?. When I do a...

No one is in the table while I'm trying to view it. I've never had a problem with Access 97 either - I don't have the option of staying with 97 - I have to move to 2002. Help - anyone???

I am having a problem with a linked table (Oracle 73.ver2.5) and Access 2002. All other linked tables are coming across great except for 1 table – and the only difference I can see is that there is a memo field. When I look at this table in Access – all fields show as #Name?. When I do a...

Database was converted from Access 97 to Access 2002. Users preview a report in Access (looks great) and then click on “W” at top of menu (Publish it with Microsoft Word) and report is shown in Word as a .rtf document. The problem is the Word document does not look like the Access report...

date shows as 07/01/2004 - typo...

Sorry.... Rejectdate = 01/01/2004

I have a problem comparing dates in a query. I’m using Access 2002 and the “date” fields I’m comparing were text fields. I’ve converted them to date fields using CDATE. Example: IIF ([Acceptdate]>=[RejectStart],[Acceptdate],[Rejectdate]) Example of Acceptdates: 06/01/2003, 06/12/2004...

Thanks dhookom.... That worked great. You really got me out of a jam...thanks again.

The detail section is set to Can Shrink. I think I know what the problem is - but I don't know how to fix it. As long as the subreports have matching vendors - it's OK - but if the subreports have no data for that vendor (all 4 subreports) then the "blank page" has the vendor nr/name from the...

Yes - the subreports are set to Can Shrink. I do have a ForceNewPage property set in the Ven_Number Footer to After Section.