Conectare
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Current day in reports

Întrebare Current day in reports

  • 29 august 2012 08:19
     
     
    Sign in pentru a vota
    0
    I set the schedule duration of one day. I need to make reports using PowerPivot. A simple tables that will contain the current day and the information related to this day. It is particularly important to do so when users open a report, all reports is active in the current date.
    Maybe someone knows which table can take days on the schedule or email a link to an example of how to do this?
     

Toate mesajele

  • 30 august 2012 11:27
     
     
    Sign in pentru a vota
    0

    Hi,

    Can you be more specific on query/issue as from your post not able to understand your exact problem.

    Thanks !!!

    Sachin Vashishth MCTS

     
  • 5 septembrie 2012 07:20
    Moderator
     
     
    Sign in pentru a vota
    0

    Any task related information be it duration or name or anything else is available in Reporting DB under task views(there are couple of them which would give values depends upon requirement) however for duration you can refer to MSP_EPMTask_Userview to get the same, as far as todays date is concerned you can use fucntion Today of power Pivot Date & Time function

    Let us know if this helps or provide some more information on what you are trying to achieve specifically & would be glad to help

    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com