system
March 16, 2010, 8:09pm
1
I WANT TO CREATE YEAR TO DATE AND YEAR TO MONTH CONDITION OBJECT,
Sunil123 (BOB member since 2009-12-05)
system
March 16, 2010, 8:48pm
2
Have you tried searching - the same question has been asked an answered many times before.
Help yourself by asking intelligent questions. If you have mentioned what database you were using, that would have been useful.
Nick Daniels (BOB member since 2002-08-15)
system
March 16, 2010, 9:01pm
3
Yes I did nick,
Sunil123 (BOB member since 2009-12-05)
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)
MarkP
March 17, 2010, 10:24am
5
In addition, if you’re googling, slip busobj in as a search term and you’ll find threads from here (or site:forumtopics.com)
(BOB member since 2002-08-15)
(BOB member since 2005-03-01)