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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » How to create dashboard...

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

Rate Topic

Display Mode

Topic Options

Author

Message

kpsr_kpsr 63487

Posted Saturday, June 05, 2010 5:20 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 18, 2012 12:27 AM
Points: 83, Visits: 473

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

thank you

Post Attachments

Variance of Main labordashboard without s with graphp.xls (137 views, 32.30 KB)

Post #933140

checkai

Posted Wednesday, June 09, 2010 7:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:27 AM
Points: 170, Visits: 398

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.

Post #934579

kpsr_kpsr 63487

Posted Wednesday, June 09, 2010 8:49 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 18, 2012 12:27 AM
Points: 83, Visits: 473

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

Post #934651

« Prev Topic | Next Topic »

Permissions