Newbie Questions

Re: Info Path and sum

fastie81 — Tue, 18 Sep 2007 15:13:33 GMT

Hi Clay

It was a filter issue.. I have change the default filter to not just show 100 but as many as it can then it worked.. Thanks for that heads up.. Saved my job.. lol..

Thanks again for your help..

Chris

Re: Info Path and sum

Clay Fox — Tue, 18 Sep 2007 15:03:29 GMT

I would try a test and see if you can see the whole unflitered list, all 600. Maybe have the affected user try. This way you know they are seeing all the data and not just a subset. If they can see everything then it must be a filter issue where maybe the data is not consistent or something.

Re: Info Path and sum

fastie81 — Tue, 18 Sep 2007 14:59:19 GMT

Hi..

Yes I am standing on about 600 now and yes every one has permission to view it.. It is hidden so they cant get access but they can view it if they know how to find it..

Chris

Re: Info Path and sum

Clay Fox — Tue, 18 Sep 2007 14:44:59 GMT

Hey Chris.

Do you have more than 100 forms in the library? SharePoint only displays and only returns 100 at a time. Also does everyone have permission to the view you are using?

Info Path and sum

fastie81 — Tue, 18 Sep 2007 10:43:24 GMT

I got and infopath form where users enter there Holidays in. Everything works great, it has a column that spesify the amount of working days taken.

This then get submited to a form liabrary where all the from is kept.. I pull the user detail from AD so the user has minimal entry.
My question is now. when a user open a form it does a sum from the liabrary based on the user's name then show the sum in a box, saying how many days the user has taken.

My problem is that this works fine for some users and not for others.. I had a look at spelling and just about everything but nothing works.. Now it was working for one user and today it stop working..
I basically select the sum of the column on the library with a filter that say where the name is = to the name of the library name..

Is there anything ells I can do to get this total, or is there something I need to know that sum has a limit or something..

Any Idea will be great.

Thanks

Chris