-
1
- #1
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Detail - How to Pull 2
- Thread starter sigstad
- Start date
-
1
- #2
CharlesCook
Programmer
If I understand your question, you want to turn off effective dating and pull all of the records not just the most current or as of a date asked user etc.
To do this go to Tools menu and Tables Sub Menu. Click on the effective dated table (The Job Table). Then click on the Effective Date button. This will take you to the window that is used to create the effective date key. Close to the bottom you will see a large button (I can't remember how it is labeled). Click it, you will go to a window that lets you select how your report is effective dated. Select No Effective Dating. You will get a warning telling you that you can not undo this. Click ok etc.
ALT WAY TO DO THIS:
Go to Tools menu and Selections Menu. Remove all selections for effective dating.
Click Done.
If you have a box that asks for a effective date go to the Tools menu and the Report Variables menu. Remove the EffectiveDate Report Variable.
Hope this helps... CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining
To do this go to Tools menu and Tables Sub Menu. Click on the effective dated table (The Job Table). Then click on the Effective Date button. This will take you to the window that is used to create the effective date key. Close to the bottom you will see a large button (I can't remember how it is labeled). Click it, you will go to a window that lets you select how your report is effective dated. Select No Effective Dating. You will get a warning telling you that you can not undo this. Click ok etc.
ALT WAY TO DO THIS:
Go to Tools menu and Selections Menu. Remove all selections for effective dating.
Click Done.
If you have a box that asks for a effective date go to the Tools menu and the Report Variables menu. Remove the EffectiveDate Report Variable.
Hope this helps... CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question