C#

Kwagga wrote:

The bold part is where the problem is!! As you can see there is a double assign to an Alias and I can't run the SUM without assigning it to an Alias!!

inSql = @" Select DISTINCT TSProjectCodeID, EmployeeID, SUM(HoursWorked) FROM tblTimesheetDetails WHERE TimeSheetDate >= '" + startdate + "' AND TimeSheetDate <= '" + todate + "' AND TSProjectCodeID = '" + cmbprojects.Text.ToString() + "'ORDER BY TSProjectCodeID, EmployeeID, HoursWorked";

I are Troll

TimesheetDetailID	EmployeeID	TimesheetID	TSProjectCodeID	TaskCode	TimeSheetDate	HoursWorked
100	F3309134	14	MT101	Test Execution (INT)	2010/07/09	4.00
56	F3309134	14	MT101	Test Support	2010/07/26	2.00
62	F3309134	14	MT101	Project Management	2010/07/27	3.00
66	F3309134	14	MT101	Meeting Project	2010/07/27	0.50
67	F3309134	14	MT101	Meeting Project	2010/07/28	0.50
69	F3309134	14	MT101	Project Management	2010/07/28	2.00
70	F3309134	14	MT101	Meeting Project	2010/07/29	1.00
61	F3309134	13	MT900/910	CR	2010/07/26	0.50

Kwagga wrote:

When I run the code I am expecting it to group all the MT101 stuff together and give me as single row with a total sum depending on the date range I select as inout. However, it lists thwm all with the individual timea.

Kwagga wrote:

this is my first attempt at Crystal Reporting and I am hoping to publish this once I get it all to work 100%.

I are Troll

Kwagga wrote:

AS 'TOTAL_HOURS AS COLUMN3

Kwagga wrote:

Access DB which is not that friendly with stored procedures

if (picturebox1.Image == Properties.Resource.Pic1)
   {
   ... Move to picture two
   }

using System;
using System.Runtime.InteropServices;
internal class DynamicLoad {
  [DllImport("kernel32.dll", SetLastError = true)]
  private static extern IntPtr LoadLibrary(String dllToLoad);

  [DllImport("kernel32", CharSet = CharSet.Ansi, ExactSpelling = true, SetLastError = true)]
  private static extern IntPtr GetProcAddress(IntPtr hModule, string procName);

  [DllImport("kernel32.dll", SetLastError = true)]
  private static extern bool FreeLibrary(IntPtr hModule);
  
  // Assuming CharSet.Ansi, you may be Unicode.
  [UnmanagedFunctionPointer(CallingConvention.StdCall, SetLastError = false, CharSet = CharSet.Ansi)]
  internal delegate int SomeFunction(string Param1);

  private IntPtr dllPtr;
  internal SomeFunction someFunction;

  internal Boolean Load(String dllPath) {
    dllPtr = LoadLibrary(dllPath);
    // Int32 code = Marshal.GetLastWin32Error();
    // TODO: error handling
    if (dllPtr != IntPtr.Zero) {
      try {
        someFunction = (SomeFunction)Marshal.GetDelegateForFunctionPointer(
          GetProcAddress(dllPtr, "SomeFunction"),
          typeof(SomeFunction));
      } catch (ArgumentNullException) {
        // SomeFunction was not found
        Unload();
      }
    }
    return (dllPtr != IntPtr.Zero);
  }

  internal void Unload() {
    bool result = FreeLibrary(dllPtr);
    // TODO: error handling
    dllPtr = IntPtr.Zero;
  }
}