Post reply

complex report - pivot function?

  • January 12, 2006 at 12:58 pm

    #113066

    I've been asked to create a complex report for a new application we are rolling out.  I planned on using Reporting Services (2005), but may be I'll have to use a Visual Studio form instead.

    Here's what they want the report to look like:

    bid summary report

    I have the following working in reporting services:

    bid summary reporting services

    What I want is for the middle section with customer and gross mbf to be repeated to the right for each customer who bid on the current species.

    (Eventually, I'll end up putting the netMBF next to the grossMBF. And I'd like to put a 1st, 2nd, etc header, but that will come if I get the other stuff working.)

    Any ideas or suggestions are greatly appreciated.

    Should I try using the pivot function?

    I'm new at this so sorry if I'm totally off track.

    Thanks!

  • January 12, 2006 at 3:11 pm

    #614501

    You may want to try using a matrix instead of a table.  I'm new to matrixs, but they will pivot the data based on any column(s)? in the data set.

    Mike

     

  • January 14, 2006 at 2:11 am

    #614785

    Try to create a view in SQL and from that view you can easily pull out your report.

    Or else write trigger in the tables where the source of data is stored and keep collecting the data and store in a convenient table. Run your report on that final table which may be easier to handle. Hope I am clear to you

    V.Kadal Amutham

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

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