stacked columns in a report table?

  • Is there a way to "stack" columns in a table on a report?

    My example would be getting some info out of [msdb].[dbo].[sysjobhistory]. I'd like to see the name of the job (and _id), the step_id, step_name, run_date, run_time and run_duration on one "row", with the message on the next (see attached).

    I can't create different datasets as there would be multiple rows per job_id and I'd like them to "meld".

    select

    j.name

    ,j.job_id

    ,jh.step_id

    ,jh.step_name

    ,jh.run_date

    ,jh.run_time

    ,jh.run_duration

    ,jh.message

    from

    sysjobs j inner join sysjobhistory jh on j.job_id = jh.job_id

    where

    jh.job_id = '<some job id>'

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • Hi

    Maybe you can create 2 new detail lines

    Then join the text box on the first detail line to put the static text "Message"

    and then do the same with the second detail line and put the field Message on it

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply