Search results for query: *

Hello I am trying to summarize my call data based on customer ID on # of Attempt (1 time, 2 times, 3 times) I have a call table that contain the following data sample CallID CustID CallDate 1 C01 1/2/2018 2 C02 1/2/2018 3 C03 1/2/2018 4 C01...

Hello, I am trying to create a cross tab to show survey question as row, survey ID as column, and the display answer as the summary. I have a formula which assign 1 if the answer is "Yes", and 0 if the answer is "No". CountofYes formula: if ({ScoringDetail_viw.DisplayAnswer} = "Yes") then 1...

I have 3 cross tab reports that are created as follow: Total Percent SLOT 122 SCHEDULED 40 COMPLETED 29 INCOMPLETE 93 Week Ending Total Percent HOLIDAY 0 0% <- 0 / 122 LEAVETIME 10 8% <- 10 / 122 MEETING 5 4% LARGEHOME 4 3% OTHER 17 14%...

Hello all, I have a report that I want to pull last 13 months of data. The report should look at sys date (i.e. 8-10-2010), calculate the start date as the first day of last month last year (7-1-2009) and the end at the last day of last month this year (7-31-2010). How can I accomplish this in...

Hello everyone, What is the best way to make a CR DB connection for Oracle Database 10g? I currently use OLE DB (ADO) with MS OLE DB Provider for Oracle and sometimes my report runs very slow. I was talked one way and need to explore my options. Thanks, Phoebe

Hello everyone, I am working on a report, that would prompt the user to select grouping by Date or by Name. So I create two group formulas using case: if user select 1, Group1 = Date, Group2 = Name. If the user select 2, Group1 = Name, Group2 = Date. But when i run the report, i get an error...

Hello all, Is there a good book out there that can help me with managing the CMC? I want step by step procedures for setting up report bursting, publication, and how to manage the portal in general. Thank you for your time, Phoebe

Hello, I have a view table that contain 3 fields: PROJECTID DISPLAYVAL RECVALUE 1 Airsealing TRUE 1 Attic insulation TRUE 1 Clothes washer FALSE 2 Airsealing FALSE 2 Attic insulation TRUE 2 Clothes washer...

Hello all, I use Crystal Report 2008 & Oracle 10g. I have a report that pull RECCODE and RECVALUE based on ProjectID from table FT_PROJECT_RECOMMEND. My book says I can make on-demand subreport that when user click on it, it will update my source database. I try this but my SQL command is...

Hello, I have created a formula to show a static goal value based on each group in the report (if group1 = 1, my goal display as 10; if group1 = 2, my goal display as 20). I want to sum up the goal values at the reporting footer. I use the summary function and my value = 181060 which was...