system
March 17, 2010, 8:45am
4
Here’s a few:
I have to design a new report as follows: It runs daily, monthly and yearly.
Group1:
Item 1 MTDSalesRevenue YTDSalesRevenue PreviousYearSales
Item 2 MTDSalesRevenue YTDSalesRevenue PreviousYearSales
…
…
Item N MTDSalesRevenue YTDSalesRevenue PreviousYearSales
Sub-Total Sub-Total Sub-Total
Group2:
Sub-Total Sub-Total Sub-Total
Gra…
Hi Experts,
I am having some reports, In which I need to display Day, Week, Month, Week to Date, Month to Date, Year to Date.
I am using BOXiR2, Oracle 9i as back end.
I have searched entire forum, But I did not the proper solution to my requirement. Please let me know the logic.
NOTE:
I don’t have these columns in the DB, I need to create it in the Universe level.
Table Name: CUSTOMER
Coulumn Name: DATE
Based on the user selection in the report level, I need to display the report in Cr…
Hi all,
i am trying to automate my reports,but my condition is as follows (Oppurtinity Date Between 04/01/2009 and 03/31/2010) at report level, instead of manually entering the dates i to want create date objects at universe level.My Universe does’t contain any calender table and the backend for my universe is oracle.
vvemula (BOB member since 2008-07-02)
Hi ,
I did enough search on the BOB for this but none of those could resolve my problem.
I want to create YTD sales object. My user enters only month and year , I have to get the Period begin and end dates from accounting calender .But when I am trying create YTD sales it is giving data for the entered month and year not the year to date.
YTD sales:
Select table.sales
Where order_date between @select(sales\year of current) and @select(sales\period end date)
Period end date :
Select table…
At least one of which is SQL Server. But there are 4 pages of threads I found by searching on “MTD”. As Nick says, this has been discussed many many times. Also, if you search on google, you can find pages of this - I found code for a complete set of SQL Server date objects with a very quick search a whiel back.
Debbie
Debbie
Debbie (BOB member since 2005-03-01)
(BOB member since 2005-03-01)