MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Custom caml reports

  Asked By: Harshad    Date: Sep 01    Category: MOSS    Views: 1014

I had a request from a dept here and I was wondering just how to implement this.

In a MOSS installation, a document library has versioning turned on. One column
of data freqeuntly changes between versions, but not always. What this dept
would like, is to enter in a value for this field and then have a "report"
generated that shows all of the documents that share that value. The issue with
this is that it should show the correct version of the document that shows that
value also, not just the latest version. They will not need to be able to
access this file, they just need to be able to print a list of the files. Is
there a way to do this using CAML?

If not is there another way to generate this information?

(Right now they are having to enter this information into SharePoint and also
into an access database that will generate those reports for them. They want to
do away with the Access database and do it all from SharePoint.)



5 Answers Found

Answer #1    Answered By: Dominic Davis     Answered On: Sep 01

I don't know if this can easily be done with CAML.

If this report needs to be run by the users, I would write a custom
web part. You can access  the SharePoint API, open the list  and
examine each list item.

Each spListItem has a versions  collection and you can access the
field values for each version  as well as the version number.

I can provide more info if you need it.

If this is a one-off report, you could do the same thing with
PowerShell, but it seems like the users would want to run this as
part of their work process.

Answer #2    Answered By: Indu Raj     Answered On: Sep 01

It would need to be run by the users on a fairly regular basis. I would very
much appreciate more input on how to accomplish this. If you need more details
of what I am specifically looking for (after re-reading my post, I'm not quite
sure I was clear enough), just ask. I had thought about trying to integrate
something using crystal reports  also, but that seems like I would run into the
same versioning  issue.

Answer #3    Answered By: Khushi Srivastava     Answered On: Sep 01

I think I understand what you are trying to do but I need to
understand where you are coming from.

Do you have a programming background and do you have Visual Studio?

Answer #4    Answered By: Arti Patel     Answered On: Sep 01

No programming background, but I do understand a little of asp.net and xsl/xml.
I don't have VS, so it will have to be with SPD if at all possible.

Answer #5    Answered By: Claire May     Answered On: Sep 01

From sharepoint  Designer (SPD), you can't get to the version
collection from the list  datasource. You could create a web service
datasource and get the version  collection for 1 list item at a
time . . . but that would be clunky.

The thing with SPD is that you can't run "code behind".

Maybe someone else has another idea. I usually write custom  code to
do this sort of thing and I haven't really exploited all of SPD's
nooks and crannies, so maybe it is possible.

Didn't find what you were looking for? Find more on Custom caml reports Or get search suggestion and latest updates.