InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:07:54 GMT20http://www.sqlservercentral.com/Forums/Topic933140-1063-1.aspxThanks 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 waywhen 2010report Header:--------------------------------------------reportdata :--------------------------------------------when 2009reportHeader:--------------------------------------------reportdat :-------------------------------so how can i fix this problem. even i tried through Canshink-true and cangrow-truethank u very much.regardskpsrWed, 09 Jun 2010 08:49:34 GMTkpsr_kpsr 63487http://www.sqlservercentral.com/Forums/Topic933140-1063-1.aspxWe 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.Wed, 09 Jun 2010 07:06:07 GMTcheckaihttp://www.sqlservercentral.com/Forums/Topic933140-1063-1.aspxHi could u plz help me how to create attachement report in ssrs 2005thank youSat, 05 Jun 2010 05:20:38 GMTkpsr_kpsr 63487