Forum Replies Created

Viewing 15 posts - 1 through 15 (of 127 total)

  • Reply To: Average in a Matrix

    The code in the report worked awesome. Thanks. But I did run into a problem since it had more that one group. My fault, I left it out. I like...

  • Reply To: Average in a Matrix

    The TSQL didn't work.  The report can't do a double aggregate like Sum(Last()).

    You're code is awesome for testing. I should have thought of this. My fingers are crossed and I'm...

  • Reply To: Average in a Matrix

    You're right, and I do apologize. I'm a little confused as to how to ask what I need.  I'll see if I can get some data, but first how about...

  • Reply To: Average in a Matrix

    The example I get is horrible, I should redo the thread.  Sorry about that. Let me try this.

    Screenshot

    This is closer to what I want. In yellow I...

  • Reply To: Two tables per page

    If I include it as a sub report it only shows the first employee because the parameter expression is =First(Fields!Employee.Value, "Employee").  If I take out the first I get an...

  • Reply To: Two tables per page

    I'm not sure how to combine two different types of tables into one. How do I force a page break on employee? Since they are two separate tables the results...

  • Reply To: Add two rows to a view

    Awesome, Cross Join with Union All worked perfect.

    Thank you,

    • This reply was modified 5 months, 3 weeks ago by  Ken at work.
  • Reply To: Adding Sum to Variables

    Thanks but I can do the T-SQL. I'll just do that.

  • Reply To: Maps - What is the best way to add location maps to SSRS

    I'm fairly sure we haven't add anything to our SQL Server yet.  I'll look this over, but I think I need to do that first. Oops, wrong forum.

  • Reply To: Adding Sum to Variables

    Here is an example. The last six digits of the GL Account number represent Region/Division. The first matrix totals the 5 series GL Accounts. The second matrix actually has a...

  • Reply To: Adding Sum to Variables

    I posted and now I don't see it???

  • RE: Update Trigger

    ScottPletcher - Monday, April 9, 2018 3:39 PM


    SET ANSI_NULLS ON;
    SET QUOTED_IDENTIFIER ON;
    GO
    CREATE TRIGGER udLaborTracking__TRG_UPD_Set_LastJob
    ON dbo.udLaborTracking
    AFTER UPDATE
    AS
    SET NOCOUNT ON;
    IF UPDATE(Job)
    BEGIN
      UPDATE...

  • RE: Update Trigger

    sgmunson - Monday, April 9, 2018 6:27 AM

    Unfortunately, you missed his point entirely.   The structure you have only allows for the...

  • RE: Update Trigger

    Thank you, I think I'm going to give this a try.
    I was curious, not being as familiar with the coding, why does the update need to address the alias...

  • RE: Update Trigger

    Grant Fritchey - Friday, April 6, 2018 10:10 AM

    Ken at work - Friday, April 6, 2018 9:59...

Viewing 15 posts - 1 through 15 (of 127 total)