yes it is setup in admin. i also checked in the tsnames.ora file and it appears to be fine as well. in the mean time i have reverted back to my old machine till we can figure out this issue. thanks for the reply i do appreciate it.
We just upgraded to a Win2000 under NT machine using access97. When we used to use a regular NT machine with access97 i used a module with the transferdatabase method to import data from an oracle table. This worked just fine till we got the upgrade to Win2000. Now it tell me that "ODBC...
i have created a report that uses subreports. i compiled and ran the distribution export with no problems. i installed on desired machine and upon open i encountered a print engine error "cannot open sql server". just to make sure i could hit the datasource i ran a test from...
I am trying to select the most recent room number based on the maximum row identifier.
Table1 contains these fields:
UID,Date,Room,PatientID
Data in Table1:
1,7/1/02,456B,Amy74
2,7/1/02,234C,Amy74
3,7/1/02,457D,Amy74
Data I would like to see based on query:
3,7/1/02,457D,Amy74
Code I wrote...
does anyone know how to return a field name from a table? for example table1 had field1, field2, and field3. i have created a function that returns the maximum value of the three fields. what i want it to do now is to tell me the field name of that field with the maximum value.
I can do this however then i will need to create a user group to access the area on the lan where the query will be stored. i did not want to have maintain that if it can all be done in crystal. do you know how to do that?
i have two tables one is a decode table and the other uses a variation of the unique identifer along with other information. however i am unable to figure out how to link them in crystal. it is easy to do in access as i can create a function to delete the irrelevant numbers. for example table...
i figured out how to distribute many reports at once. click the add button. duh, on my part. now i am looking to figure out how to add reports to that distribution list. lets say that i have those 130 on the LAN and want to add one more to that group of distributed reports. do i have to...
i am new to crystal reports and was wondering if there was a way to create a set of distributed reports at once. i have only found it to work for one report at a time. we are converting from msaccess to crystal and have 130 reports to convert. any ideas? i read about the subreports...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.