Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to create dashboard reports(Format-Attached0) in 2005 ssrs Expand / Collapse
Author
Message
Posted Saturday, June 5, 2010 5:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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 (147 views, 32.30 KB)
Post #933140
Posted Wednesday, June 9, 2010 7:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 10:36 AM
Points: 171, Visits: 405
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
Posted Wednesday, June 9, 2010 8:49 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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 »

Add to briefcase

Permissions Expand / Collapse