Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

URL Parameter for Access / .mdb data

Status
Not open for further replies.

clanm

Programmer
Dec 26, 2005
237
US
Posted - 04/10/2006 : 15:46:50
--------------------------------------------------------------------------------

I'm using an .mdb file in the meantime (before we upsize the data), and I've got to pass two parameters in a querystring.....for now I'm just using one in my testing. The other will be a date value. Since it's an OLEDB datasource, the parameters have to be unnamed....at least that's what reporting services is telling me.

In my querystring, I pass the parameter value like:


...but the report doesn't pull any data.

I can run it in the data tab of the report desginer, put in 2003, and the data does come back.

Any suggestions?

Thanks!
 
Here's what I had to do for report to use a record selection formula via an URL querystring:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
Dim strPCRNo As String = Request.QueryString("PCRNo")
Dim strVD As String = "DateTime('" & Request.QueryString("VerDate") & "')"
Dim strBDateTime As String = "DateTime("
Dim strEDateTime As String = ")"
crv.SelectionFormula = "{PCR_1.PCR_NO} = '" & strPCRNo & "' and {PCR_1.Version_DT} = " & strVD & ""
End Sub

crv is the report viewer, and I had two URL parameters, one was a string, and the other was a DateTime.

I had to test this with a label in order to show the SelectionFormula, take that and paste it in the record selection in Crystal XI, and see what did / didn't work.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top