Search results for query: *

Hi All cr 9.0 ms sql i have a cross tab i created a group base on trade_class and order by S and R and i need to get grand total at bottom of report footer i have a formula that breaks it down by trade_class here is my formula --------------------------- @RorS if...

Hi folks ms sql cr 9.0 I have these date and would like to pass them to my variable ------------------------------------------------------- New Year's Day Monday, January 1 this does not change ------------------------------------------------ Martin Luther King, Jr. Day Monday, January 15...

Hi All Cr 9.0 ms sql I have a formula that calculated the average here are my formula -------------------------------- @Daily_Red if {TRANSACTION_HISTORY.POSTING_DATE} <={?End_Date} and {TRANSACTION_HISTORY.TRADE_CLASS} = "R" then round({TRANSACTION_HISTORY.GROSS_AMOUNT}) else 0...

Hi All. cr 9.0 ms sql I used Ken formula for the Holiday here is what it looks like BeforeReadingRecords; DateVar Array Holidays := [ Date (2007,1,1), Date (2007,1,15), Date (2007,2,19), Date (2007,4,6), //changing Date (2007,5,28), //changing Date (2007,7,4), Date (2007,9,3), //changing Date...

Hi Folks ms sql cr 9.0 i have a report that has a {?End-date} that i used as my parameter. i need some help on how to calculated Sales Daily YTD Avg keeping in mind they want working days with are monday to friday and holidays. my date field is {Transaction_History.Posting_Date} to calculated...

hi All cr 9.0 ms sql i have this report that contains 2 subreports 1. i have these amount sub report 1YTD sub report 2 Rep_Count 1062875/5294 1019197/4397 556346/4080 1123620/3837 409887/2801 3211420/1916 523793/2512 410306/2956 264899/2051 395437/3988 70871/1790 68954/2511 i'm dividing YTD by...

hi folks I'm stump on how to het this done cr 9.0 ms sql i have a main report and a sub report in my sub report i have a running total that gives me a count of branch ex: header BRANCH_ID----------------Count branch1-------------------5 branch2-------------------7 branch3-------------------5 in...

Hi All cr 9.0 ms sql i have a report that has main and 2 subreport my main report shows subtotal in report group footer territory and i have 2 sub report that displays ranks ex: heading territory|branch|WEEKSSLS|MTD_SLS|YTDSLS|WEEKRNK|YTDRNK|YTD_SLS_PER_REP_RNK gr1 is territory and gr2 branch my...

Hello All cr 9.0 ms sql i have this report and has 3 rank my main report has this gr1 call {terri.definition} and have 2 sub report i used to rank the YTD and TYD PER REP RANK to get the last part i created this formula ---------------------------------------- @YTD_SLS_PER_REP if...

hi All Cr 9.0 ms sql I've been ask if possible to assign a default value to a null i check the box in my report option to default value to null. my boss ask me if it's possible that i could assign a value to it ex; i have a channel and there are null in it i have a parameter call {?Channel} he...

Hello cr 9.0 ms sql i have a cross tab and i suppress the total collumn row and i cant get the empty box to be remove here is what my cross tab looks like ex: Column #1 name column#2 name| total row#1| row#2| @Amount| @sum_Amount |Total_suppress |...

Hi Folks cr 9.0 ms sql i have this report i need to rank base on YTD sales i have 1 group call territory here is what it look like ------------------------------------------------------- gr1 Territory--Week_SLS--MTD_SLS--YTD_SLS--WEEK RNK--YTD_RNK PFS-01*******900*****10000******5000******1...

Hi All cr 9.0 ms sql i have a report that used an {?End_Date} parameter. i need to report for 5 days base on the {?End_Date} they enter here is the problem if they enter let say 02/15/2007 witch is monday i need to report from monday 15 to monday 15 only if the select 02/23/2007 this would be...

Hi All cr 9.0 ms sql i have this report and table link to = i'm not getting the right data if i used MS SQL to get the data i get the right one. my sql is this ------------------------------------- select a.terr1, uni_user from (select distinct th.terr1 from transaction_history th where...

Hi All cr 9.0 ms qsl i created a cross tab and it has parameter start date and end date my cross report by month base on my posting_date i have something like this here is a sample of my report layout ****************** Jan 2006 Feb 2006...

Hi All cr 9 ms sql I have a report that is giving some problem i have 2 parameter call {?Start_Date} and {?End_Date} and is link like this {transaction.posting_date} in [{?Start_Date}to {?End_Date}] my report design looks like this it has boxes ****************** Jan 2006 Feb...

Hi Folks cr 9.0 ms sql i have a report that contains a gr call contact_id here is a sample of colums contact id 529 sma total jim 5 2 7 i create a formula for each of the 529,sma,total something like this -------------------------------------------- @529_S //529 if...

Hi all CR 9.0 ms sql i have a field that contains a null value when i run the report it works fine my problem i would like to cast the null value to my selected paramter value parameter my parameter is channel and if i select PC i get pc but i need to see the null is there a way to cast the...

Hi folks cr 9.0 ms sql i had a previous post but i did not get the right info to solve my problem i have a report that has 2 group gr1 is channel gr2 id uni_user here is what it looks like these are my collumns Channel:PC assigned to |lunch|dinner|fax|phone|email gr1 jim 20 6 1...

Hello cr 9 ms sql i have a report that has 2 group gr 1 contact_id gr 2 channel i created a running total for each collumn i got the number right for the first group base on a distinct count now i need to add the rsult of this running total to the gr 2 section ex: name conference...