I have been working on this report at work for hours and couldn't figure out my extra page. I made sure that I did not pass the borders and margin lines. I found this site that solved my issue.
http://www.bidn.com/blogs/dustinryan/ssis/492/blank-page-at-end-of-ssrs-2008-report
Helpful bits of SQL, C#, ASP.NET and related articles that we feel may be useful to the community at large. Enjoy!
Wednesday, May 23, 2012
How to SELECT NON DISTINCT COLUMNS FROM A TABLE.
SELECT [COLUMN]
FROM [TABLE] T1
WHERE (SELECT COUNT(*) FROM [TABLE2] T2 WHERE T1.[COLUMN] = T2.[COLUMN]) > 1
This returns all of the non distinct (opposite of distinct) rows.
SELECT [COLUMN], Count(*)
FROM [TABLE]
GROUP BY [COLUMN]
HAVING COUNT(*) > 1
This returns what is distinct and how many rows there are that has the value.
Wednesday, May 16, 2012
Diablo 3 Nvidia Surround (3 Monitors) Taskbar Hide.
I was playing Diablo 3 with 3 monitors using Nvidia Surround. I encountered an issue with the windows taskbar being in the way so this is what I did to fix the issue.
1) Go to Nvidia Control Panel.
2) On the Top toolbar next to "Edit" choose "Desktop" then Surround Displays and make sure that "Confine Taskbar to Center Display" is not checked.
3) Go to the normal Windows Task bar right click on it and go to Properties.
4) In the properties check "Auto-Hide Taskbar"
5) Now Launch Diablo 3 with Surround turned on.
6) Make sure Diablo 3 is being ran on Full Windowed Mode.
Enjoy
1) Go to Nvidia Control Panel.
2) On the Top toolbar next to "Edit" choose "Desktop" then Surround Displays and make sure that "Confine Taskbar to Center Display" is not checked.
3) Go to the normal Windows Task bar right click on it and go to Properties.
4) In the properties check "Auto-Hide Taskbar"
5) Now Launch Diablo 3 with Surround turned on.
6) Make sure Diablo 3 is being ran on Full Windowed Mode.
Enjoy
Subscribe to:
Posts (Atom)