?
Solved

Cognos promp dates

Posted on 2014-01-01
3
Medium Priority
?
287 Views
Last Modified: 2014-01-31
Hi,

I developing a report which requires to read from balance table it gives yesterday value which is fine, but I want also to read balance one day before.

what is the expression to use? or is there any other way or shortcut?

Thank you.
0
Comment
Question by:amq10
  • 2
3 Comments
 
LVL 12

Expert Comment

by:Habib Pourfard
ID: 39750164
we need more details. please let us know about the query you are using.
0
 

Accepted Solution

by:
amq10 earned 0 total points
ID: 39751187
thank you Pourfard.

the query I want to run is like this as I drag from package data items:

customer number
customer name
account balance amount  ( I expect output to show balance as yesterday which is fine)
account balance amount  -1 Day ( not included package data items).

I hope this can help.
0
 

Author Closing Comment

by:amq10
ID: 39823520
it works with some tricks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question