Get value of Session in Record Selection

[Alison Givens]

Hi,

I want two Session values in my record selection query. The come out of an
other webform.
When I do it hardcoded, it works.
How dow I do this with the Session values?

Hardcoded:
Dim strSQL As String
strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFil ialen.Periode})

= '200409'"

strSQL = strSQL & " AND
ToText({AlleProductieveProjectUrenVerdeeldOverFili alen.Periode}) <= '200510'
myReport.RecordSelectionFormula = strSQL

What I want:
the values '200409' should be the Session.Item("BeginPeriode")
the value '200510' should be the Session.Item("EindPeriode")

Kind regards,
Alison

[S.M. Altaf [MVP]]

--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com
"Alison Givens" <in**@cross-it.nl> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi,

I want two Session values in my record selection query. The come out of an
other webform.
When I do it hardcoded, it works.
How dow I do this with the Session values?

Hardcoded:
Dim strSQL As String
strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFil ialen.Periode})

= '200409'"

strSQL = strSQL & " AND
ToText({AlleProductieveProjectUrenVerdeeldOverFili alen.Periode}) <=
'200510'
myReport.RecordSelectionFormula = strSQL

What I want:
the values '200409' should be the Session.Item("BeginPeriode")
the value '200510' should be the Session.Item("EindPeriode")

Kind regards,
Alison

[S.M. Altaf [MVP]]

strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFil ialen.Periode})

= '" & Convert.ToString(Session.Item("BeginPeriode")) & "'"
--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com
"Alison Givens" <in**@cross-it.nl> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... Hi,

I want two Session values in my record selection query. The come out of an
other webform.
When I do it hardcoded, it works.
How dow I do this with the Session values?

Hardcoded:
Dim strSQL As String
strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFil ialen.Periode})

= '200409'"

strSQL = strSQL & " AND
ToText({AlleProductieveProjectUrenVerdeeldOverFili alen.Periode}) <=
'200510'
myReport.RecordSelectionFormula = strSQL

What I want:
the values '200409' should be the Session.Item("BeginPeriode")
the value '200510' should be the Session.Item("EindPeriode")

Kind regards,
Alison

[Alison Givens]

Thanks very much. That did the trick.

"S.M. Altaf [MVP]" <sm*****@PLEASEDONTSPAMMEmsn.com> wrote in message
news:u5**************@TK2MSFTNGP12.phx.gbl...

strSQL = "ToText({AlleProductieveProjectUrenVerdeeldOverFil ialen.Periode})

= '" & Convert.ToString(Session.Item("BeginPeriode")) & "'"

--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com
"Alison Givens" <in**@cross-it.nl> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi,

I want two Session values in my record selection query. The come out of
an other webform.
When I do it hardcoded, it works.
How dow I do this with the Session values?

Hardcoded:
Dim strSQL As String
strSQL =
"ToText({AlleProductieveProjectUrenVerdeeldOverFil ialen.Periode})

>= '200409'"

strSQL = strSQL & " AND
ToText({AlleProductieveProjectUrenVerdeeldOverFili alen.Periode}) <=
'200510'
myReport.RecordSelectionFormula = strSQL

What I want:
the values '200409' should be the Session.Item("BeginPeriode")
the value '200510' should be the Session.Item("EindPeriode")

Kind regards,
Alison