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!

Register Log in
  • 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!

using different fields for prompts and filter report

Status
Not open for further replies.
rajmns

rajmns

Programmer
Nov 29, 2007
8
0
0
US
Hi All,

I have a field Model_Date in the format Mar 1, 2007 12:00:00 AM etc. I have another field Calendar_month in the format YYYY-MM. I have to use Calendar_month field in a date prompt(value prompt) and when the users select a value like 2008-01, the report should be filtered such that the Model_Date be 3 months prior. In another words, the report should return data based on model date being 2007-10 and earlier. Can anyone suggest me ways to achieve this?

Thanks everyone
 
Status
Not open for further replies.

Similar threads

deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
90
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
87
wwconslt
wwconslt
Magnus_03
  • Locked
  • Question
Cognos 10.2.2 Workspace Advanced Errors (Failed...request, the report server..., and annotation...)
Replies
0
Views
108
Magnus_03
Magnus_03
Emperatriz Stredel
  • Locked
  • Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
104
Emperatriz Stredel
Emperatriz Stredel
donape
  • Locked
  • Question
TM1 Cafe - Copy Report, but change CUBE data source.
Replies
0
Views
88
donape
donape

Part and Inventory Search

Sponsor

Back
Top