T-SQL Tip : Finding Running Total Value
Hi Guys, In one of my SSRS Reporting needs, I need to display RunningTotal in some funny colors. Here is the script that I have used. I hope it may help you somewhere too 🙂 Thanks, Khilit
Continue reading →Tag Archives: Tip
View is not showing newly added column in table
Hi all, This is for the people who still use “Select * From Table” in their SQL Views. I don’t know what is the reason that you are using this way to create your views, but you could be the victim of this scenario (see… what title says). Let me show you how you can solve this issue… in-case you come across one. When this happens?? You make changes in table which is the source of your view. Changes like modifying existing column definition, adding new columns or removing existing columns from table could cause this issue. Where can I … Continue reading →
SSRS Report is asking for Username and Password while executing
Hi all, I want to bring to your focus a very minor detail which could eat-up your time when it happens. This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need to provide Username and Password if you have access to the Report. And everything works fine up to this point. After some days, if you notice that your SSRS Report is not working as expected and it has started asking for Username and Password while … Continue reading →
GodMode in Windows 7
Hi All, If you have a Windows 7, then you can enable so-called “GodMode” to get access to most of the controls of operating system & other components. You simply have to create a folder name with following words. “GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}” (Please exclude ” – double quotes while naming it). Ta-Da. The folder icon will change to control panel icon and you will see the big list of items where you can easily search many controlling options just grouping by “Application” in details view. You can also collapse or expand all groups by right-click & selecting appropriate options. Though it seems … Continue reading →