请问Reporting Service 如何从地址栏获取参数？

Question

请教各位大能了，谢谢

我的SQL Server是2012

我创建一个报表参数，参数名叫pickID

我在访问该报表的URL上添加了一个参数，希望报表参数pickId能够自动获取到这个参数，结果是没有获取到，请教可能是哪里的问题？

我的url是这样写的：

/Reports/Pages/Report.aspx?ItemPath=%2fEIP%2fQnp_Packing_List&pickId=55577

谢谢您们的不吝赐教！

Answer 1

你的SQL语句中确认有pickId这个参数吗？

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Found any spamming-senders? Please report at: Spam Report

Answer 2

确定有啊，我用微软教程里的钻取功能，是可以的

即我创建另外一个报表，比如叫myreport，在里面的任意一个text上添加导航按钮，导航到我本来的报表，并传一个参数pickId

结果，是可以获取到这个pickID的

但是，用Report.aspx?ItemPath=%2fEIP%2fQnp_Packing_List&pickId=55577 却获取不到

我也研究的导航时的url，但它是加密的，不知道传的什么东东

导航报表传递的url：

Report.aspx?ItemPath=%2fEIP%2fQnp_Packing_List&ExecId=ktn1b255ylilkmqu1k0zsv3d&PingId=kp2k2erltfwlunjwtqqfwm55

Answer 3

PingId=kp2k2erltfwlunjwtqqfwm55

你是PingId还是PinkId？

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Found any spamming-senders? Please report at: Spam Report

Answer 4

是pickId，PingId是导航报表自己生成的

研究了半天，终于找到答案了，用下述方法才可以传参

/ReportServer?%2fEIP%2fQnp_Packing_List&rc:Parameters=false&pickId=5

谢谢您的无私帮助！

Answer 5

我已经把你标记为答案了，请取消我的标记答案，谢谢！我没有实质性帮助到你，只是提醒你而已。

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Found any spamming-senders? Please report at: Spam Report