Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ker0k3n0
  • Content: Threads
  • Order by date
  1. ker0k3n0

    Count Customer with Number of Calls Attempt 1 time, 2 time, 3 times

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

    Cross Tab try to calculate percent of "Yes" from my survey.

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

    Cross Tab - custom column

    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%...
  4. ker0k3n0

    How to query last 13 months (completed month) of data

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

    Database connection for Oracle Database 10g

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

    Dynamic grouping by formula

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

    Central Management Console

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

    Dynamic Reporting

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

    Using Subreport to write-back to a source database

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

    How to sum values together in custom field

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

Part and Inventory Search

Back
Top