Post reply

How to create dashboard reports(Format-Attached0) in 2005 ssrs

  • June 5, 2010 at 5:20 am

    #223384

    Hi

    could u plz help me how to create attachement report in ssrs 2005

    thank you

  • June 9, 2010 at 7:06 am

    #1177951

    We have done something like this that we basically used the power of stored procedures. Basically, you know how many months you'll be dealing w/ so that setup could be static, then within the stored proc, bring back each row as a calculation as it looks like there is no raw data on the dashboard. Not the prettiest way of doing things, but you have complete control within the SP and can then add a metric whenever.

    You will need to incorporate some logic for grouping/sorting.

  • June 9, 2010 at 8:49 am

    #1178007

    Thanks for u r reply man. any way i got the dashboard.But i have one problem year. The problem was Headr settings. In perameter of @Fisical Year=2010. then i will get the headr properlly along with body layout, right when the FiscalYear=2009. i don't have any forecast data in my client table. at the time i m getting actual data which is (October-January) then my report header is not setting up with report. it was appearing more then report like following way

    when 2010

    report Header:--------------------------------------------

    reportdata :--------------------------------------------

    when 2009

    reportHeader:--------------------------------------------

    reportdat :-------------------------------

    so how can i fix this problem. even i tried through Canshink-true and cangrow-true

    thank u very much.

    regards

    kpsr

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

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