March 23, 2009 at 1:48 pm
scotta_miller (3/23/2009)
Both, it is blank locally and on the report server.
I will run the Supp Material code later today and see if I can reproduce the issue. Will send out an update later.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 23, 2009 at 1:50 pm
Ok, Thank you for your help.... 🙂
March 23, 2009 at 1:53 pm
scotta_miller (3/23/2009)
The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result.I double checked the DB and there are two table with no data:
ExecRequests
TempdbSpaceUsage_Mean_StdDev
No problem, we will get to the bottom of this one way or another... 🙂
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 23, 2009 at 2:53 pm
Figured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. I guess I am used to seeing data populate when the report is ran. I changed the default Flag value to 1 so when the report runs, data is always populated for the default server and then subsequent servers as you click through them.
Thanks for your help, you may consider outlining this or defaulting the Flag to 1.
March 23, 2009 at 5:15 pm
scotta_miller (3/23/2009)
Figured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. I guess I am used to seeing data populate when the report is ran. I changed the default Flag value to 1 so when the report runs, data is always populated for the default server and then subsequent servers as you click through them.Thanks for your help, you may consider outlining this or defaulting the Flag to 1.
Yes, thank you for pointing this out. In fact, come to think of it, I should have designed the report so that it opens up for the default server to save the user from doing additional clicks. Glad it is now working for you.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 6, 2012 at 1:59 pm
General question on this really old post. Has anyone updated this to use 2012 yet? I have it on my 2005 system, but we just upgraded to 2012. Being blunt, I am lazy and wanted to ask before spending time trying to figure everything out.
Fraggle
September 9, 2012 at 7:33 am
Fraggle-805517 (9/6/2012)
General question on this really old post. Has anyone updated this to use 2012 yet? I have it on my 2005 system, but we just upgraded to 2012. Being blunt, I am lazy and wanted to ask before spending time trying to figure everything out.Fraggle
Hi,
I have a SQL-2008 version, if you are interested.
Haven't updated to 2012 yet.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply