Report Tables In SharePoint

#11

"Patrick Finucane" <patrickfinucanetx (AT) gmail (DOT) com> wrote

On Apr 30, 9:00 pm, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:

Quote:

"Patrick Finucane" <patrickfinucan... (AT) gmail (DOT) com> wrote in message

news:919dbcde-cad0-4feb-b508-8476e981423b (AT) t16g2000yqt (DOT) googlegroups.com...
On Apr 27, 9:24 pm, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:

In Access I build reports using temporary tables in the front end. But
when
putting my Access on SharePoint I can't do that. Any tips for how to
compile
report data using SharePoint? Thanks!

Are your temp tables finite in count and are the field names the same
for a specific report? If so, can you create a blank "holding" table
that mimics each temp table and link all the temp tables together via
a Tempvars!ID value?

===========================

Yes, I could do that. I was thinking of doing something along those lines.
Was thinking, though, of using a table with an autonumber field, adding a
record to it, and then using the ID value to link the tables. Is that
basically what you're saying, but to assign the ID value to tempvar and
use
it that way?

Also, at what point would I clear the temp data? With my temp tables I'm
just clearing the temp data before the report is run. But with multiple
users using the same table, obviously I wouldn't be able to delete the
entire table. So when would I delete the data associate with the
tempvars!ID
value?

Thanks!

Yes. I was thinking initialize a Tempvars!Vars variable is set for a
current "ID" to symbolize the records processed. Then when you
complete run delete queries that delete the data for that set just
processed. I don't have experience with Sharepoint yet. I understand
your limitations tho. It's clunky but should work.

==================================

Problem is that the report (actually a form) will be based on the temp data.
So if I delete it after the form is opened, won't I run into problems?

I suppose I could put the date into the table that gives me the autonumber
ID for each report, and then, when the form is opened, delete all temp data
from previous days. Thus, the cleanup would occur for past days, but not the
current day.

#12

On May 1, 11:09*am, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:

Quote:

"Patrick Finucane" <patrickfinucan... (AT) gmail (DOT) com> wrote in message

news:78b2833e-4898-4052-baa7-e78a16164125 (AT) v1g2000yqm (DOT) googlegroups.com...
On Apr 30, 9:00 pm, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:

"Patrick Finucane" <patrickfinucan... (AT) gmail (DOT) com> wrote in message

news:919dbcde-cad0-4feb-b508-8476e981423b (AT) t16g2000yqt (DOT) googlegroups.com....
On Apr 27, 9:24 pm, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:

In Access I build reports using temporary tables in the front end. But
when
putting my Access on SharePoint I can't do that. Any tips for how to
compile
report data using SharePoint? Thanks!

Are your temp tables finite in count and are the field names the same
for a specific report? If so, can you create a blank "holding" table
that mimics each temp table and link all the temp tables together via
a Tempvars!ID value?

===========================

Yes, I could do that. I was thinking of doing something along those lines.
Was thinking, though, of using a table with an autonumber field, addinga
record to it, and then using the ID value to link the tables. Is that
basically what you're saying, but to assign the ID value to tempvar and
use
it that way?

Also, at what point would I clear the temp data? With my temp tables I'm
just clearing the temp data before the report is run. But with multiple
users using the same table, obviously I wouldn't be able to delete the
entire table. So when would I delete the data associate with the
tempvars!ID
value?

Thanks!

Yes. *I was thinking initialize a Tempvars!Vars variable is set for a
current "ID" to symbolize the records processed. *Then when you
complete run delete queries that delete the data for that set just
processed. *I don't have experience with Sharepoint yet. *I understand
your limitations tho. *It's clunky but should work.

==================================

Problem is that the report (actually a form) will be based on the temp data.
So if I delete it after the form is opened, won't I run into problems?

I suppose I could put the date into the table that gives me the autonumber
ID for each report, and then, when the form is opened, delete all temp data
from previous days. Thus, the cleanup would occur for past days, but not the
current day.- Hide quoted text -

- Show quoted text -

That works for me. But then, I don't have your problem

. Good
luck.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Report Tables In SharePoint

comp.databases.ms-access comp.databases.ms-access

Re: Report Tables In SharePoint - 05-01-2012 , 11:09 AM

Re: Report Tables In SharePoint - 05-01-2012 , 12:12 PM