2. ASPRunnerPro General questions
  3. Transfer Owner ID
This topic is locked

Transfer Owner ID

 		12/3/2007 11:48:51 AM
ASPRunnerPro General questions
M
 MikeGinMN author

I use Win2PDf to help produce reports from an MS Access database. So that the user only see their parts of the reports I need to transfer the Owner ID to the program that directs win2pdf to the desired report.
In that program I have
Cell1 = """"& SESSION("OwnerID")& """"

Cell2 = "WHERE Facility = "

Cell3 = "WHERE Delegation = "

Holder = Cell2 & Cell1

Holder1 = Cell3 & Cell1
which is suppose to generate either WHERE Facility ="xyz" or WHERE Delegation ="xyz"
I've used this before with just writing asp code, but not with ASPRunner Pro. What do I need to do to transfer the Owner ID to that program
Thanks
Sergey Kornilov admin 12/3/2007

SESSION("OwnerID") is correct variable.
You need to elaborate where and how you use this piece of code, what errors you getting etc.
M
 		MikeGinMN author 12/4/2007

I have eight different sports that I'm doing on-line registration for. I have 7 done and have reports created in the Access database. The funny thing is that on 3 of them they work correctly. When a user signs on I check the information that is related to their delegation so they only see their athletes, coaches,etc. The same applys to the reports. The ones that work give only the info relating to their delegations, the ones that don't work prduce a pdf with no records in it. So I;m not sure what is happening?
M
 		MikeGinMN author 12/5/2007

I was able to get the function to work. I had to assign security to the reports menu to see everyones data but only edit your own. Then it would send the owner's delegation id. Thanks for the help