Report Rapport in MOSS 2007

SharePointKicks.com — Thu, 16 Nov 2006 21:37:53 GMT

You've been kicked (a good thing) - Trackback from SharePointKicks.com

re: Report Rapport in MOSS 2007

George Karkalis — Tue, 05 Dec 2006 02:08:01 GMT

Hi,

Is there a web part or another way to include a report's result in any page. I just want to get the "My Tasks" report on the home page for any user because the "User Tasks" web part only displays tasks assigned to the user and not to groups the user has membership.

thanx

How to get a view of all documents and pages that are checked out to me, and more...

Renee Hulsman on MOSS 2007 — Wed, 20 Dec 2006 14:05:17 GMT

Use Report Rapport in MOSS 2007 Standard reports are: Checked Out To Me Last Modified By Me Pending Approval My Tasks All Draft Documents Going Live Within Next Seven Days Expiring Within Next Seven Days

re: Report Rapport in MOSS 2007

Jane Brassington — Thu, 11 Jan 2007 13:17:17 GMT

Hi,

I am having trouble getting these reports to look any further into the site than the first level. My site structure is very similar to yours with site collections and sites, but the reports do not seem to gather data from any of the collections or sites within them.

Am I missing something?

Thanks

re: Report Rapport in MOSS 2007

ecmblog — Tue, 16 Jan 2007 00:52:53 GMT

George -

You can use a Content Query web part to display the results of any CAML query if you so choose. To do this, we have to bypass the standard UI for customizing this Web Part, export a .webpart file for the web part, insert our query in the appropriate location, and import our customized .webpart file. Here are the specific steps you need to take to do this:

1. Insert a Content Query Web Part into a web part zone on your page.

2. Export the web part (in the web part pane, click edit -> Export, and pick a location to save the file).

3. Get the CAML markup for the query you want to display. You mentioned you want to display the results of the out of the box "My Tasks" report, so go into the Content and Structure Reports List in Site Manager and find the query (Site Actions -> Manage Site Content and Structure -> Content and Structure Reports, and copy the contents of the CAML Query column for the desired report).

4. Open the .webpart file you exported in step 2, and find the <property name="QueryOverride" type="string"> tag.

5. Paste the query you copied in step 3 into this tag, for example:

IMPORTANT: Don't forget the <![CDATA[ ]]> tags, and make sure the CAML markup doesn't have any extraneous spaces between tags.

6. Repeat steps 2 - 5, only this time, copy the contents of the "CAML List Type" column, and paste them inside the <property name="ListsOverride" type="string" /> tag in the .webpart file. This property will then look like this:

7. Import the .webpart file back into your page: click "Add a Web Part" in the web part zone, click "Advanced web part gallery and options", then "Browse", "Import", and finally select your modified .webpart file.

8. An icon for the web part you just uploaded appears - drag it into your web part zone.

You can see this SDK article for more information on customizing Content Query Web Part properties:

http://msdn2.microsoft.com/en-us/library/aa981241.aspx

Lincoln

re: Report Rapport in MOSS 2007

mkelly — Mon, 29 Jan 2007 23:56:40 GMT

Hi,

Is there an issue with the "User Tasks" web part? It only displays tasks assigned to the user on the current site. I thought this web part is supposed to show tasks assigned to the user across the portal.

Thanks,

Mindy

re: Report Rapport in MOSS 2007

Alex — Fri, 23 Feb 2007 20:43:13 GMT

Argh! Why did I not find this post earlier?

I was so frustrated at having only three filter criteria available and not being able to nest my queries that I ended up building complex xsl:if and xsl:choose scenarios in my Itemstyles.

Thank you for pointing out the QueryOverride feature. That makes much more sense!!!

Thank you again. that msdn article is grrreat. Shame it was not around 8 Months ago.

re: Report Rapport in MOSS 2007

... — Mon, 26 Feb 2007 10:48:10 GMT

The information I found here was rather helpful. Thank you for this.

re: Report Rapport in MOSS 2007

scholar — Wed, 14 Mar 2007 10:41:55 GMT

Hi,

This is really a great feature of MOSS. Can you help me with the report rapport feature as I cannot see it on my application? Is there still a need to setup on the sharepoint administration page or on the created top level site to be able to have this feature? Is this feature available for standard or enterprise edition of moss 2007?

Thanks,

Scholar

re: Report Rapport in MOSS 2007

Sharepoint Slave — Wed, 04 Apr 2007 18:28:24 GMT

Thank god you guys published this article.

and thanks for the links to the toosl that will make it easier for the non-porgramming types like me.

re: Report Rapport in MOSS 2007

Alex de cph — Fri, 22 Jun 2007 15:27:44 GMT

When I click to any element of the list reports it redirects to the same page. Any solution to this problem??

WSS 3.0 & MOSS: Recopilación de enlaces interesantes (IV)

Blog del CIIN — Tue, 24 Jul 2007 15:17:59 GMT

Siguiendo con la recopilación periódica de recursos sobre WSS 3.0 & MOSS, esta semana en el número

re: Report Rapport in MOSS 2007

dattard — Thu, 31 Jan 2008 18:51:24 GMT

This looks like a nice way to quickly and easily query ad hoc list information.

re: Report Rapport in MOSS 2007

aditya — Wed, 20 Feb 2008 07:26:35 GMT

Hi i want to generate reports like ,loggedin user,logintime,logouttime,site usage number,ie;how many times the site was used.

With the concept of CAML Query can i design them.

I don't have any knowledge of how to develop reports.I am a beginner,learning self.

Please help me.

re: Report Rapport in MOSS 2007

Rajesh — Mon, 05 May 2008 01:57:42 GMT

Hi,

This article help me a lot for creating content reports for the administrator. I am having couple of question.

1) Is it possible I can call this in my custom webpart? If yes Please guide me how to.

2) How I pass dynamic PARAMETER to the query? For example instead of ARTICLE PAGE choice I want to pass some other value which User will give as input.

Thanks and Regards

Rajesh

re: Report Rapport in MOSS 2007

kathie — Thu, 08 May 2008 07:38:51 GMT

The information here was VERY helpful - thank you!

One question - the links to tasks in meeting workspaces from the modified CQWB are broken and do not work. When the task is listed using the default Sharepoint "My Tasks" report, the links do work.

Is there a way to get the CQWB to use the same links as the default Sharepoint "My Tasks" report?

Thanks!

re: Report Rapport in MOSS 2007

amitnkshirsagar — Tue, 20 May 2008 07:48:50 GMT

Hi everybody,

I am developing one business application using MOSS.

I am having two options for storing business data:

1) MOSS custom list

2) SQL server 2005 tables

If I use MOSS custom list,it will break data integrity of business data tables as I can not use Primary key and foreign key relationship on custom list.

If I use SQL server 2005 tables for storing business data,I can not use in build MOSS functionality like Work flows,custom list etc.

Is there any other better way of doig this?

Thanks in advance.

re: Report Rapport in MOSS 2007

amitnkshirsagar — Fri, 27 Jun 2008 09:29:41 GMT

Has anyone implemented Multi Tenant architecture in MOSS 2007 ?

re: Report Rapport in MOSS 2007

Shashi — Thu, 24 Jul 2008 23:13:48 GMT

This article is great, but it queries only at the location where you are.

I am trying to generate a report which can actually query and all checked out pages from top level and sub sites in a published site. But for some reason when I applied the "All Items Checked out" query, it retrieves only from one site which I have selected. Any response to get this query to loop over all the sites and subsites to retrieve the results would be appreciated.

Thanks,

Shashi

re: Report Rapport in MOSS 2007

Owen — Fri, 22 Aug 2008 19:24:28 GMT

I, too, am trying to get a report to see items in lists that belong to sub-sites in the site collection. I am the sole approver of content on a site collection, so I need to see all items that have an Approval Status of 'Pending'. When I write the query, it only pulls content that is on the site selected, and not the sub-site lists like it ought to.

I have a partial workaround, but it falls apart easily. I can edit the CAML list type to include several list type integers, but that only allows me to add three types. It does look into the subsites, however. Why does the report feature not work as shown in the screenshots? Is there a wildcard operator I can put in the List Type line?

Reporting on all checked out pages within a SharePoint WCM Site Collection

Confluence: SharePoint Development Wiki — Wed, 13 May 2009 06:38:01 GMT

Picture this scenario...you have put the new Internet into Production for authors to go and enter their content. And it's close to golive and you notice that pages are not showing up in the navigation....