Search results for query: *

Thank you Pete!!! I followed your method and it works beautifully! As always I appreciate the help from this site and especially lbass I am a long time follower :)

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...

Hi LB, I have CR 2008 - these crosstabs were created using the wizard. I am not sure how to refer a specific cell (i.e Slot Total column in a formula).

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

Thank you so much LB you are the best!

It is Varchar2(64) - it is only true or false. I guess my headings would be fixed not dynamic. Sorry for the confusion.

The datatype is Varchar(2).

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...

I got an error with "invalid syntax" or invalid characters. I do have read/write access i was able to update the values when I hardcode them in the SQL command. I just do not know how to relate my crystal report field or my group field to the SQL command yet. Thank you.

I just tried to insert a recordset and it works: INSERT INTO "FT_PROJECT_RECOMMEND" VALUES ('P00000077706','REC000033522','T') How do I make crystal to lookup the ProjectID and Reccode from the report?

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...

Thank you LB, you are the best!

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...