| Using CURRENT_DATE in Reports [message #358435] |
Tue, 11 November 2008 05:37  |
pauljjhenderson
Messages: 2
Registered: November 2008
Location: Donegal / Sheffield
|
Junior Member |
|
|
Hi All,
Im very new to Siebel so please excuse any "silly" questions.
I am trying to create a report that will be run every month, its a simple report which shows name, activity description and date.
I have tried to run the report using:
Date."Fiscal Month" = "CURRENT_MONTH" as a filter but this returns an error.
Is there some syntax that I am missing, it returns an error:
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "CURRENT_MONTH". (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT Contact."Contact Last Name" saw_0, Contact."Contact First Name" saw_1, Activity.Description saw_2, Date."Fiscal Month" saw_3 FROM "Activity Analysis" WHERE Date."Fiscal Month" = "CURRENT_MONTH"')}
|
|
|
|
| Re: Using CURRENT_DATE in Reports [message #358462 is a reply to message #358435] |
Tue, 11 November 2008 08:12  |
pauljjhenderson
Messages: 2
Registered: November 2008
Location: Donegal / Sheffield
|
Junior Member |
|
|
I managed to find the solution after a bit of digging, here is what i needed to do:
When creating the reports, I chose the Filter for the Month, then:
Add -> Variable -> Session
Then I simply typed in CURRENT_MONTH
And it worked. Hope this helps someone else.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
