jetlounge.net - technews

Great example site for Microsoft Azure : score.ly

2010-10-02T19:59:00Z

Check it out, all MS Azure / SQL Azure : http://score.ly

Reporting Services Execution Log Reports

2009-11-22T12:35:00Z

Need to scrub those RS 2008 Execution logs to determine who, what and when those reports ran? A platform for deeper optimization analysis?

There's a codeplex project with the DB Schema, SSIS Package and a set of reports:

Community Edition : http://scrubs.codeplex.com

Premium Edition (offers 15+ more optimization reports and traffic path analysis):

http://www.summitcloud.com/solutions/scrubs

SharePoint and SQL Server 2008 Administration - Free eBook!

2009-11-10T01:25:00Z

Microsoft has released a free ebook for administration and performance management of SharePoint on SQL Server 2008.

http://bit.ly/2RpALX

Forms Based Authentication on SharePoint 2010 and WSS 3.0

2009-11-03T13:44:00Z

Two great series of articles on FBA and SharePoint:

FBA & SharePoint 2010

FBA & SharePoint Services 3.0

PDF is blank in IE 8 (Internet Explorer)

2009-10-26T03:11:00Z

An Adobe Acrobat PDF may display as a blank page in IE 8. Additionally, you may see an error popup that is also blank. This appears to be due to a compatibility issue with the plug in for IE. To fix, force the PDF to open in Adobe Acrobat Reader instead of IE.

1. Open Adobe Acrobat
2. Click Edit, Preferences.
3. Click Internet option in the right pane.
4. Uncheck “Display PDF in browser” check box.Click OK to Save.

FIX: IE ESC Won't Turn Off (Internet Explorer Enhanced Security)

2009-10-26T03:03:00Z

In Terminal Services, if you cannot get IE ESC to disable, even when you have turned the setting off in Server Manager - try the following:

Option 1: Modify Internet Explorer settings for administrator accounts

loadTOCNode(2, 'resolution'); For administrator accounts, you can run the following command to turn off Internet Explorer Enhanced Security Configuration:

rundll32.exe setupapi.dll,InstallHinfSection IESoftenAdmin 128 %windir%\inf\IEHARDEN.INF

Note You must run this command by using an account that has administrative credentials. Additionally, for the changes to take effect, you must restart the computer after you run this command.

Option 2: Modify User Settings

To turn off Internet Explorer Enhanced Security Configuration for a few user accounts, you can remove the IEHarden registry entry from each standard user account profile. To do this, follow these steps:

Log on to the terminal server by using the credentials of the standard user account.
Click Start, click Search, and then search for the Regedit.exe file.
Right-click regedit.exe, and then click Run as.
Click The following user, type an account name that has administrative credentials, and then click OK.
Locate and then click the following registry subkey:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zonemap
In the details pane, right-click IEHarden, click Modify, type 0 (zero) in the Value data box, and then click OK.

Note You can also remove this registry entry.
Locate and then click the following registry subkey:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings
In the details pane, right-click IEHardenIENoWarn, click Modify, type 0 (zero) in the Value data box, and then click OK.

Note You can also remove this registry entry.
Exit Registry Editor, and then start Internet Explorer.
On the Tools menu, click Internet Options.
Click the Advanced tab, click Restore Defaults, and then click OK.
Close and restart the browser

SharePoint FBA Setup on IIS 7

2009-10-22T20:00:00Z

Forms based authentication setup on SharePoint 3.0 is so much easier on IIS 7, and a ton easier with this series of tutorials.

Yeah, No more web.config hacks for Forms Based Authentication setup!

Blog post here.

String Building and Advanced Expressions in SharePoint Workflows? YES!

2009-10-09T04:49:00Z

YES! It is possible:

http://blog.summitcloud.com/2009/10/advanced-string-functions-in-sharepoint-workflows-yes-we-can/

FTP Task Blocked When Run in SQL Server Agent

2009-09-24T23:52:00Z

Got the connectionstring and credentials down pat, and no error message when executing a SQL Server Agent Job that included an FTP task. It just sat there, and sat there.

Looked and smelled like a firewall issue. And it was. Didn't occur in Visual Studio, just when running in automated mode.

To fix (on Windows Server 2008), follw instructions for:

Using Windows Firewall with non-secure FTP traffic

Open a command prompt: click Start, then All Programs, then Accessories, then Command Prompt.

To open port 21 on the firewall, type the following syntax then hit enter:
netsh advfirewall firewall add rule name="FTP (non-SSL)" action=allow protocol=TCP dir=in localport=21
To enable stateful FTP filtering that will dynamically open ports for data connections, type the following syntax then hit enter:
netsh advfirewall set global StatefulFtp enable

FIX: Report Builder 2.0 ClickOnce Deployment Fails From SharePoint

2009-09-09T21:10:00Z

SQL Reporting Services Report Builder 2.0 ClickOnce broke in the CU2 of Service Pack 1.

So, if you are on Service Pack 1, get Cumulative Update 3. Be sure to install all of the files if you are running Reporting Services in SharePoint integrated mode.

The Best Point of Sales Reporting Metrics Platform

2009-09-06T21:45:00Z

Great point solution for analytics that combines EDI 852, EDIFACT, Partners Online, RetailLink, retail spreadsheets and popular ERPs (to name a few) into easily digested actionable metrics to manage reorder velocity, inventory turn and manage best and worst sellers around the globe.

CloudMetrix by SummitCloud.

Gantt Charting With SQL Reporting Services 2008

2009-08-20T23:50:00Z

Update: So SQL Server 2008 is here, and still no Gantt Chart. So this free native workaround will still get you through on SQL Server Reporting Services 2008.

I've got an article over at SQL Server Central that describes how to get Gantt charts in SSRS using native controls, not third party. And it has a holiday spin.

This is the abstact:

Gantt charts in SSRS aren’t included in the 2005 release. You can purchase a third-party add-on, or, if you can wait, these powerful project tools might make it in the 2008 release. Or Alternatively, you can do this now with the native RS Chart control by using the methods David Leibowitz provides with the native RS Chart control.

This is the URL: http://www.sqlservercentral.com/articles/Reporting+Services/Santa+gets+an+RDL+present/61782/

The RDL example file is found in the Attachment link below.

FIX: Me.Value Does Not Work in Reporting Services 2008 (SSRS)

2009-07-11T04:49:00Z

Me.Value will not work in SQL Server Reporting Services 2008 (SSRS 2008) if you have some complex code behind. This is regardless whether you use that code in your expression.

For example, your Tooltip might simply be =Me.Value .

Not only will that not work, but the combination might leave you without a visbile value in the cell. What??

I use quite a bit of code behind the form, and references to assemblies. This did not hinder the usage of the Me.Value property in RS 2005, but it now breaks in 2008. If you need your code behind, the only way around this is to explicity reference the report item.

Example:
To dynamically change the color property, of a cell in a Tablix refrenced as Textbox2...

instead of =IIF(Me.Value<0, "Red", "Black")
try

=IIF(ReportItems!Textbox2.Value<0,"Red","Black")

Reporting Services 2008 URL Parameters for SharePoint Integrated Mode

2009-07-09T15:30:00Z

Passing URL report parameters directly to a report in a SharePoint Document Library is enabled in the SQL Server Reporting Services 2008 Integration with SharePoint Add-in.

When a report is rendered in full-page view in SharePoint, the URL is displayed in the following format: http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<SharePoint_Document_Library>/<Report_Name>.rdl.
In SSRS 2008, you specify a report parameter name and value pair by explicitly specifying the prefix "rp:". Here is an example to add-on a parameter with name "Month" that accepts a string value: http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<SharePoint_Document_Library>/<Report_Name>.rdl&rp:Month=January
You can also specify a fixed set of ReportViewer parameters to alter full-page rendering experience. These ReportViewer parameters need to be explicitly prefixed by "rv:". Here is an example of rendering the report with the parameters area collapsed: http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<SharePoint_Document_Library>/<Report_Name>.rdl&rv:ParamMode=Collapsed&rp:Month=January

Examples: Here are examples using the Adventureworks sample reports assumed to be stored in SharePoint document library: http://<SharePoint_site>/Reports/ReportsLibrary· Render the AdventureWorks "Employee Sales Summary" report for 'Syed Abbas' for 'January' / '2004' with ReportViewer Toolbar showing pagination only: http://<SharePoint_site>/Reports/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/ReportsLibrary/Employee%20Sales%20Summary.rdl&rv:ToolBar=Navigation&rp:EmpID=288&rp:ReportMonth=1&rp:ReportYear=2004· Render the AdventureWorks 'Product Catalog' report with the Document Map Area collapsed and no Header Area: http://<SharePoint_site>/Reports/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/ReportsLibrary/Product%20Catalog.rdl&rv:HeaderArea=None&rv:DocMapMode=Collapsed

ReportViewer parameters for controlling full-page report rendering

ReportViewer Parameter	Description	Values
rv:HeaderArea	Control how the ReportViewer web part’s header is displayed in full-page view.	Full, None. Default: Full
rv:ToolBar	Control how the ReportViewer web part’s toolbar is displayed in full-page view.	Full, Navigation, None. Default: Full
rv:ParamMode	Control how the ReportViewer web part’s header is displayed in full-page view.	Full, Collapsed, Hidden.Default: Full
rv:AsyncRender	Control whether the report is rendered asynchronously or synchronously.	true, false. Default: true
rv:DocMapAreaWidth	Control the display width in pixels of the ReportViewer web part’s Document Map area.	Non-negative integer
rv:DocMapMode	Control the display of the Document Map area of a report.	Displayed, Collapsed, Hidden. Default: Dislayed

Report Builder Report Fails with The item 'ModeName.smdl' cannot be found. (rsItemNotFound)

2009-07-09T15:26:00Z

In a SharePoint integrated SQL Server Reporting Services environment, you find you can access a model, open Report Builder, drag an drop a few items. But when you attempt to actually run the report you're told the model cannot be found. What? But you were just using it!

The error looks like:

An error has occurred during report processing. (rsProcessingAborted)

The item 'Folder/ModelName.smdl' cannot be found.

To Fix:

In SQL Server Reporting Services Configuration, check the Unattended Execution Account.

Provide this account access to the SharePoint library hosting your Model.