Hi! I've a similar Thing to do. I've figured an XDP file, with some Dynamic Data Fields, which is populated by connecting an MS Access Database. The file work, for now, correctly in localhost. I want to make it working via HTTP. The client , after log in , with his Username and Pwd , should open the file just by clicking on a HTTP Link with the variables attached, like as :
http://www.mydomain/AUTO_Renderingtheform.pdf?Username='MM_UserSession'+Pwd='MM_PWDSession'
at this point the PDF should be populated automatically by reading the MS Access Data present on the Server. The things which I would like to do are:
1. Connecting the *.xdp form on the Server by changing the Connection String (probabily my Provider can help me...)
2. Filtering through the SQL string like as, finally:
WHERE Username = 'User_Session' AND Pwd = 'Pwd_User' to obtain the right binding. Do I Should use File>Properties>Variables Tool or writing directly this filter into the SQL statement ? Thanks in advance to Someone can help me (I'm newbie)