Forum Replies Created

Viewing 15 posts - 16 through 30 (of 139 total)

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

    February 25, 2020 at 2:03 pm

    #3728588

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

    February 25, 2020 at 1:43 pm

    #3728584

  • Reply To: Add two rows to a view

    Awesome, Cross Join with Union All worked perfect.

    Thank you,

    • This reply was modified 5 years, 7 months ago by Ken at work.

    February 19, 2020 at 1:37 pm

    #3727067

  • Reply To: Adding Sum to Variables

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

    October 30, 2019 at 3:31 pm

    #3693159

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

    October 30, 2019 at 3:20 pm

    #3693154

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

    October 30, 2019 at 2:20 pm

    #3693127

  • Reply To: Adding Sum to Variables

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

    October 30, 2019 at 2:02 pm

    #3693121

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

    April 12, 2018 at 5:42 am

    #1986548

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

    April 10, 2018 at 12:51 pm

    #1986215

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

    April 10, 2018 at 12:22 pm

    #1986206

  • RE: Update Trigger

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

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

    April 6, 2018 at 10:29 am

    #1985826

  • RE: Update Trigger

    I'm not sure I'm following.  The Job and LastJob are not keys.  The primary Keys are Company and Employee
    There will always be only one Employee (it can never be...

    April 6, 2018 at 9:59 am

    #1985824

  • RE: Merging Data from two tables.

    I was wondering about the Row Number or something else being needed.  That is why I couldn't get it to work at the start.  I've started reading up on the...

    January 24, 2018 at 10:57 am

    #1977160

  • RE: Merging Data from two tables.

    Could I have used a regular join and ph.EffectiveDate <= tc.DateWorked, which I also didn't think of?

    January 24, 2018 at 10:27 am

    #1977157

  • RE: Merging Data from two tables.

    Amazing!
    I've never used Cross Apply.  I have to do some reading up on that.

    Thank you very much for your help,

    January 24, 2018 at 10:23 am

    #1977156

Viewing 15 posts - 16 through 30 (of 139 total)