SharePoint - SQL query to find SSRS reports

Use database_name
SELECT [DirName],[LeafName]    
 FROM [dbo].[AllDocs] (nolock) where Extension='rdl'
GO

Note: You can replace file type from rdl to doc,docx, xlsx etc.. to find different documents with file types. You can modify query to count for total etc..

Create and build power shell commands for SharePoint
Powershell Command builder:

http://www.microsoft.com/resources/TechNet/en-us/Office/media/WindowsPowerShell/WindowsPowerShellCommandBuilder.html

SSRS Cascading reports using sharepoint 2007 list data

SSRS Cascading reports using Office sharepoint 2007 lists

Tools used: Report Builder 3.0

I'll Update this shortly..

Customize your sharepoint site using Sample master pages

Source
************

http://office.microsoft.com/en-us/sharepointdesigner/HA102223711033.aspx

Download the sample master pages from the below location ,

http://www.microsoft.com/downloads/details.aspx?FamilyID=7C05CA44-869A-463B-84D7-57B053711A96&displaylang=en

Instructions
***************************
To install this download:

***************************

1. Run MasterPage.exe to unpack the master page package to a location on your computer.
2. Right click on the extracted file, MasterPageExamples.zip and select "Extract All..."
3. Complete the Extraction Wizard.
4. Open your Windows SharePoint Service 3.0 site in Microsoft Office SharePoint Designer 2007.
1. Open SharePoint Designer.
2. On the File menu, click Open Site.
3. In the Open Site dialog box, type the URL of the site that you want to open in the Site name box, and then click Open.
5. Import the master page files into your site.
1. On the File menu, select Import > File...
2. In the Import dialog box, select Add Folder...
3. Browse to location of the extracted master page files, and then browse to a specific master page set.
4. Select the "_catalogs" folder and click Open.
5. Repeat steps 2-4 for the "images" folder and the "styles" folder.
6. Click Ok to finish importing the files.

Instructions for use:
***********************************

To set the imported master page as the default master page:

1. Open the Folder List. On the Task Panes menu, select Folder List.
2. On the Folder List, within the _catalogs folder, open the masterpage folder.
3. In the master page folder, find the master page style and color you want to apply, right-click on the file and then click "Set as Default Master Page" on the shortcut menu.

Please refer to the Microsoft Office SharePoint Designer Master Pages site for additional help and how-to articles that cover the use of master pages.

To remove this download:
*********************************

* Delete the package and uncompressed files from your computer.

Reporting Services GUI Configuration

Reporting Services GUI Configuration with WSS 3.0 / MOSS
****************************************************************


http://blogs.msdn.com/sharepointbi/archive/2009/05/29/ssrs-integrated-mode-with-sharepoint-and-report-builder-2-0.aspx

http://www.helloitsliam.com/archive/2007/10/23/moss2007-%E2%80%93-reporting-services-general-ui-configuration.aspx



Key words
------------

SSRS with sharepoint ,