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!

  • Congratulations strongm 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: *

  1. dadazs

    How to display formula: [Running Total] / [Count of Instances] inChart

    Hi Tek-Tips I have a little issue with display formula in chart. Formula works fine on report; however, it is not displayed in chart. Formula: {#Running TOtal}/Count ({SiteComments.account}, {CONTACT1.KEY3}) I am running Crystal Reports 11. Please advise.
  2. dadazs

    Is it possible: Parameter that selects either of 6 columsn

    In general, user should have 7 options: column1 to column6 and n/a If user selects none then column should be blank or display "n/a". Cheers
  3. dadazs

    Is it possible: Parameter that selects either of 6 columsn

    Hello Thank you for reading. I have a requirement to create a report where I need to select a value from either 6 columns. Then the selected column should appear in the report. User should be able to ignore selection too. Is it something Crystal is capable of doing? e.g. Table: Budtet1...
  4. dadazs

    Suggestion on Grouping

    Hello I have a formula that looks like: if (distinctcount({ttcalls.calltype},{ttcalls.empID}) = 2 and (count({ttcalls.calltype},{ttcalls.empID}) = 2 or count({ttcalls.calltype},{ttcalls.empID}) = 4)) and (({ttCalls.calltype}=1 and next({ttCalls.calltype})=2) ) then "n/a" else "wrong" My...
  5. dadazs

    How to convert transaction Rows into Columns on the new Table

    Please see a required sample below. I have managed to find a script online that satisfies my requirements: select pin, MAX(CASE WHEN ACTVCODE ='AP1' THEN convert(varchar,(convert(date,ONDATE,12))) END) DateAppointment1 Is it a good solution and is there a better way to do it. pin...
  6. dadazs

    How to convert transaction Rows into Columns on the new Table

    I want AP1, AP2, AP3 & HRT. I could get data for either of values. All data is based on user's input; therfore, I cannot confirm that AP1 would always exist.
  7. dadazs

    How to convert transaction Rows into Columns on the new Table

    Please see a sample below. Data is not very clean It is the best case scenario. it is possible to have "be 5 visits and you only want 3 etc." However, currently it is not the biggest issue. Major concern is convert to "wide" table so i could easily link with with other tables around the...
  8. dadazs

    How to convert transaction Rows into Columns on the new Table

    Hello I am working on transations table that logs staff appointments. There can be three appointments (AP1, AP2, AP3) and termination. Each appointment has a date. My objective is to physically convert Staff Rows into columns in the the table e.g. Staff Appointment1 Date1 Successful1...
  9. dadazs

    How to convert transaction Rows into Columns

    It worked well! Please can you advise to transform tables physically?
  10. dadazs

    How to convert transaction Rows into Columns

    Hello I am working on transations table that logs staff appointments. There can be three appointments (AP1, AP2, AP3) and termination. My objective is to convert Staff Rows into columns e.g. Staff Appointment1 Date1 Successful1 John AP1 12/01/2011 No John AP2 12/02/2011 No...
  11. dadazs

    Best Practice for Sub Report or Shared Variable

    Hello Tek-Tips'ers I am working on three tables that contain employee information. I have joined table1 (demographics, all employees table) to table2(where employees are working) via outer left join because I want a full list of employees and site if any. Also, I need to join table3...
  12. dadazs

    Convert Rows To Columns

    Unfortunately there is not another field. The only way know related two date values that they would fall under the same jobid.
  13. dadazs

    Convert Rows To Columns

    Morning LB, Thanks for you continues support. recordType holds values of calltype 1 or 2. It is recordtype column in my 1st post. I was not aware of next() and previous() function. I will google them in the meanwhile.
  14. dadazs

    Convert Rows To Columns

    The report is based on time & attendace table where staff clocks in & clocks out. Staff can work at different sites (field jobid) and staff can have multiple positions within the same same. Table in the post below shows this particular example where staff with ID 12345 worked 3 shifts at the...
  15. dadazs

    Convert Rows To Columns

    Thanks lbass, it worked well! I have discovered another challenge. What can i do to discover hour differences if single id has multiple of type 1 & 2 row recordType Time id date 1 1 1PM 12345 24/06/2011 2 2 2PM 12345 24/06/2011 3...
  16. dadazs

    Convert Rows To Columns

    Resutls: id hours action count of issues 12345 2 na 0 12347 0 fix hours 1 12348 1 retrain 1 if there is only single rectype then hours always default to 1 and action retrain if there are same 2 rectypes then fix hours and hours...
  17. dadazs

    Export Crystal report with pic to Excel in the same format and layout

    Hello, If you are happy with report struture in Excel I would just add logo manually or create a macro to add it for you when you open a workbook.
  18. dadazs

    Convert Rows To Columns

    Hello Tek-Tippers Is it possible to create a formula that would manipulate data among rows. Please see example below: row recordType Time id date 1 1 6PM 12345 24/06/2011 2 2 8PM 12345 24/06/2011 3 1 6PM 12346...
  19. dadazs

    SQL Expression Fields - how to use it

    Select Statement: SELECT "Fortnightly_Wages"."KEY3", "Fortnightly_Wages"."COMPANY", "Fortnightly_Wages"."UTOTALWBUD", "WagesSpent"."Wage Total", "WagesSpent"."payWeek", "Fortnightly_Wages"."CurrentDC", "WagesSpent"."Deep Clean", "Fortnightly_Wages"."HOliday Budget" FROM...

Part and Inventory Search

Back
Top