Entry นี้ไม่ได้แปล word by word แต่เขียน ให้พอเข้าใจเท่านั้น (แถมยังแปลไม่หมดอีก แสรด)
Logging On To Your Database
User# and Password#
Crystal Reports Web Component Server allows the user to enter the username
and password for the report's data sources directly through the URL line.
Crystal Reports 8 will allow the user to give login credentials for the main report
and for any and all subreports.
crystal report webcomponent server สามารถรับค่า username กับ password
ให้กับ report ได้ จาก url โดยสามารถกำหนดให้ได้ทั้ง main และ sub report
User#
This command specifies user IDs for logging on to SQL, ODBC, or password
protected databases used by the report.
ตัวแปร user# เอาไว้ใส่ username สำหรับ login
PASSWORD# is normally used in conjunction with USER# command.
ตัวแปร password# เอาไว้ใส่ password สำหรับ user ข้างบน
For example:
user0=SmithJ&password0=secret&user1=JohnS&password1=mystery
Make sure passwords appear in the URL in the same order that the password
protected databases appear in the report. If passwords are not passed using the
URL address, the user will be prompted for logon information at runtime.
ตัวอย่าง http://nowhere.in.th/report.rpt?user0=USERNAME&password0=PASSWORD
...เอ่อ ที่เหลือ ขี้เกียจแปลละ - -!!
User#@subreportname
For subreports, you will need to explicitly log on to subreports if the subreports,
data sources are password protected. The correct format for logging on to
subreports is the following:
user0@subreportname=SmithJ
The subreportname portion of this parameter must be identical to how it appears
in the Crystal Reports Designer. For instance, if the subreport is shown in the
Designer as subreport1.rpt, then you will want to log on as follows:
user0@subreport1.rpt=SmithJ
However if the subreport is shown in the Designer as subreport1, then you will
want to log on as follows:
user0@subreport1=SmithJ
The command user0@subreport is mostly used in conjunction with the
command password0@subreportname to specify the username and password for
a particular subreport. This is described further in the next section.
Password#@subreportname
This command is used to pass a password value to a subreport for a specified
user. The syntax for this command is:
password0@subreportname=value
Also, the subreportname portion of this parameter must be identical to how it
appears in the Crystal Reports Designer. For instance, if the subreport is shown
in the Designer as subreport1.rpt, then you will want to log on as follows:
password0@subreport1.rpt=secret
However if the subreport is shown in the Designer as subreport1, then you will
want to log on as follows:
password0@subreport1=secret
Password0@subreportname and user0@subreportname are mostly used in
tandem to specify the username and password for the particular subreport.
An example of this code is:
http://myserver/test.rpt?user0@subrpt1=SmithJ&password0@subrpt1=secret
~เฮๆ
Edited :
more link : http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/302fbd6c-663f-2b10-85a6-8b7ab90b0acb&overridelayout=true
edit @ 8 Oct 2009 13:52:10 by Ree
edit @ 8 Oct 2009 13:53:02 by Ree
Edited 2 :
more link : http://www.poojam.info/scr8_urlcmds.pdf
edit @ 13 Oct 2009 10:49:40 by Ree
