Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CR 9..how to report last modification date of data source
- Thread starter pvirsf
- Start date
- Thread starter
- #3
Thks for the reply. Sorry for my ignorance, but I am not sure I understand your question. The data source I am using is defined on my local pc under System DSN in the ODBC data source administrator, under Control panel, Administrative Tools. I am just trying to provide the report viewer the date that ODBC data source was last modified. Does that help you see an answer?
- Thread starter
- #4
Hi,
Yes..And I am not sure that information is available to CR - I think it is only recorded in the PC's registry, which cannot be read by CR.
Why would anyone need to have this info in a report?
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
Yes..And I am not sure that information is available to CR - I think it is only recorded in the PC's registry, which cannot be read by CR.
Why would anyone need to have this info in a report?
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Thread starter
- #6
Understand. I think I'll have to advise it is not readily reportable. We have a situation where an intermediate process is run periodically to extract certain data from the live master data base to create the ODBC data source from which the reports run. We will likely need to add this data item to the ODBC data source and refresh it with the date the update extraction is run. Then it would be easily reportable. Thks for your help. rsf
Hi,
Then you are refering to the Data not the ODBC DSN..In that case, some table/field in the Data itself would need to have the date or DateTime entered when it was created - this can, of course, be used in any subsequent report on that data
To Paraphrase:"The Help you get is proportional to the Help you give.."
Then you are refering to the Data not the ODBC DSN..In that case, some table/field in the Data itself would need to have the date or DateTime entered when it was created - this can, of course, be used in any subsequent report on that data
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Status
Similar threads
- Locked
- Question
- Locked
- Question