Search results for query: *

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.

I have a master report with 4 subreports. They are linked to the master report by Vendor nr. The Master report uses the Vendor Master table which has all vendor nrs. Everything looks good and data is accurate for any of the subreports that have vendors with data. The problem occurs when...

I have 4 reports from different tables that I want to merge into one report using 3 subreports. I link 3 subreports to the master report using either cont # or vendor # - works great – no problem. The problem comes in when I want to add a date pulldown “>=[date_field]” The master report pulls...

I have 4 reports from different tables that I want to merge into one report using 3 subreports. I link 3 subreports to the master report using either cont # or vendor # - works great – no problem. The problem comes in when I want to add a date pulldown “>=[date_field]” The master report pulls...

I'm using the Lookup Wizard in one table to lookup a field in another table. Works like a charm for a TEXT field - but does not work with a MEMO field. Is there any way to do a lookup on a MEMO field?

Thanks so much.....works great!!