Jump to content

Ssrs Help Urgent - How To Assign Value To Parameter

rapchik

By rapchik
in Old Discussions

 Share

Recommended Posts

rapchik LEGEND

rapchik

Posted
  • Author
Posted

[quote name='Nissan' timestamp='1380145753' post='1304306288']
are u using this voilationcode in any expressions?
[/quote]
ledhu dude ....just dataset properties lo filters aneye dhantlo vaduthuna.....

dotnetrockz LEGEND

dotnetrockz

Posted
Posted

idhi chudu

0 down vote accepted

I think I figured out the problem. Using a multi-value parameters requires that each such parameter have its own dataset. I only had one dataset, and I was trying to point the MVP at it [i]and[/i] run the report off of the same set. I don't know why that doesn't work, but I added a dataset for the MVP, and the error went away.


nuvvu idhe dataset ni vere parameters ki use cheyyalevu or use chesthunte ee erro vasthudnhi anukunta....are u using the same datset for multiple parameters or operatiosn?


link:[url="http://stackoverflow.com/questions/17657050/ssrs-2008-forward-dependencies-error-references-only-one-parameter"]http://stackoverflow.com/questions/17657050/ssrs-2008-forward-dependencies-error-references-only-one-parameter[/url]

pandugadu999 Celebrity

pandugadu999

Posted
Posted

[quote name='ReddyGaru_' timestamp='1380144616' post='1304306074']
adhe ella ba...i have a dataset

and trying to get the values --- The report parameter ‘[color=#ff0000]ViolationCode[/color]’ has a DefaultValue or a ValidValue that depends on the report parameter “[color=#ff0000]ViolationCode[/color]”. Forward dependencies are not valid.


this is the error we r getting...
[/quote]

nuvu assign chesina dataset lo same parameter use chestunnav...adi matter anduke forward dependency error antundi...
check ur dataset

Chakram12 LEGEND

Chakram12

Posted
Posted

[img]http://www.desigifs.com/sites/default/files/tQkMo.gif?1374884028[/img]

rapchik LEGEND

rapchik

Posted
  • Author
Posted

[quote name='Nissan' timestamp='1380146403' post='1304306361']
idhi chudu

0 down vote accepted

I think I figured out the problem. Using a multi-value parameters requires that each such parameter have its own dataset. I only had one dataset, and I was trying to point the MVP at it [i]and[/i] run the report off of the same set. I don't know why that doesn't work, but I added a dataset for the MVP, and the error went away.


nuvvu idhe dataset ni vere parameters ki use cheyyalevu or use chesthunte ee erro vasthudnhi anukunta....are u using the same datset for multiple parameters or operatiosn?


link:[url="http://stackoverflow.com/questions/17657050/ssrs-2008-forward-dependencies-error-references-only-one-parameter"]http://stackoverflow...y-one-parameter[/url]
[/quote]
[quote name='pandugadu999' timestamp='1380148436' post='1304306520']

nuvu assign chesina dataset lo same parameter use chestunnav...adi matter anduke forward dependency error antundi...
check ur dataset
[/quote]
[quote name='pandugadu999' timestamp='1380148521' post='1304306534']
nee dataset and parameter ikkada post chey.....
[/quote]


this is my dataset




SELECT
R.ARRRECORDID,ARRRECSTATUS,ARRCITATIONNO,
ARRDEFLNAME,
ARRDEFFNAME,ARRDEFMI,ARRDEFDOB,
ARRAGENTID,
ARRDEFSEX,
ARRJUVENILE,
ARRDEFCITY,
ARRDEFSTATE,
ARRDEFZIP,
ARRDEFRESIDENCE,
ARRDEFRACE,
ARRDEFSTRADDRESS,
ARRDEFWEIGHT,
ARRDEFHGTFT,
ARRDEFHGTINCH,
ARRDEFHAIR,
ARRDEFEYES,
ARRDEFOCCUPATION,ARRDEFEMPLOYER, ARRNARRATIVE,
VIOLCODE,
ARRVIOLDESCRIPTION,
ARRDATE,ARRDAY,ARRTIME,ARRVIOLTYPE,
RULE3CSR10,
STATUTE, CHARGECODE,
PATROLDESC, ARRCOUNTY,ARRREGION,
ARRORI, APLPLACEDESC,ARRLOCDESC,VIOLPOINTS,
RULING, RULINGBY, ARRTRIALDATE,
ARRCOURT,ARRJUDGE,
ARRCOURTCOUNTY, ARRCOURTCOST,
ARRAMTFINE, ARRAMTSUSPENDED,
ARRDAYSSENTENCED,
ARRNOOFPROBMONTH,ARRPROBATIONDATE, ARRCOMMSERVHRS,
PRVRVKDESC,ARRPRIVOTHER,
ARRPRVRVKSTARTDATE, ARRPRVRVKENDDATE,ARRREMARK,
SZRDESC,SZRTAGNO,SZRDISPOSITION, AGTLNAME,AGTFNAME,
SZRDATE,ARRAGENTFNAME, ARRAGENTLNAME
FROM
(MOPAR.TBLARRESTRECORD R
LEFT OUTER JOIN
MOPAR.TBLSEIZURES S
ON (R.ARRRECORDID = S.ARRRECORDID))

where ARRAGENTLNAME = :AgentLastName and ARRCITATIONNO = :CitationNo And

[b]VIOLCODE = :ViolationCode[/b] and ARRRECSTATUS = :RecordStatus And ARRCOUNTY = :County

and ARRREGION = :Region and ARRDEFLNAME = :DefendantLastName and

ARRDEFFNAME = :DefendantFirstName and ARRDEFDOB = :DefendantDOB and ARRDATE >= :ArrestAfterDate and ARRDATE <= :ArrestBeforeDate


epudu nenu veli aa violationCode parameter ki default value ee dataset nudi assign chetshuna....

...meeru verey dataset only for voilcode tesukoni cheyi manatara.....chesthe aa dataset values ki ee datset ki ella link kaluputham....??

dotnetrockz LEGEND

dotnetrockz

Posted
Posted

[quote name='ReddyGaru_' timestamp='1380148945' post='1304306597']
this is my dataset




SELECT
R.ARRRECORDID,ARRRECSTATUS,ARRCITATIONNO,
ARRDEFLNAME,
ARRDEFFNAME,ARRDEFMI,ARRDEFDOB,
ARRAGENTID,
ARRDEFSEX,
ARRJUVENILE,
ARRDEFCITY,
ARRDEFSTATE,
ARRDEFZIP,
ARRDEFRESIDENCE,
ARRDEFRACE,
ARRDEFSTRADDRESS,
ARRDEFWEIGHT,
ARRDEFHGTFT,
ARRDEFHGTINCH,
ARRDEFHAIR,
ARRDEFEYES,
ARRDEFOCCUPATION,ARRDEFEMPLOYER, ARRNARRATIVE,
VIOLCODE,
ARRVIOLDESCRIPTION,
ARRDATE,ARRDAY,ARRTIME,ARRVIOLTYPE,
RULE3CSR10,
STATUTE, CHARGECODE,
PATROLDESC, ARRCOUNTY,ARRREGION,
ARRORI, APLPLACEDESC,ARRLOCDESC,VIOLPOINTS,
RULING, RULINGBY, ARRTRIALDATE,
ARRCOURT,ARRJUDGE,
ARRCOURTCOUNTY, ARRCOURTCOST,
ARRAMTFINE, ARRAMTSUSPENDED,
ARRDAYSSENTENCED,
ARRNOOFPROBMONTH,ARRPROBATIONDATE, ARRCOMMSERVHRS,
PRVRVKDESC,ARRPRIVOTHER,
ARRPRVRVKSTARTDATE, ARRPRVRVKENDDATE,ARRREMARK,
SZRDESC,SZRTAGNO,SZRDISPOSITION, AGTLNAME,AGTFNAME,
SZRDATE,ARRAGENTFNAME, ARRAGENTLNAME
FROM
(MOPAR.TBLARRESTRECORD R
LEFT OUTER JOIN
MOPAR.TBLSEIZURES S
ON (R.ARRRECORDID = S.ARRRECORDID))

where ARRAGENTLNAME = :AgentLastName and ARRCITATIONNO = :CitationNo And

[b]VIOLCODE = :ViolationCode[/b] and ARRRECSTATUS = :RecordStatus And ARRCOUNTY = :County

and ARRREGION = :Region and ARRDEFLNAME = :DefendantLastName and

ARRDEFFNAME = :DefendantFirstName and ARRDEFDOB = :DefendantDOB and ARRDATE >= :ArrestAfterDate and ARRDATE <= :ArrestBeforeDate


epudu nenu veli aa violationCode parameter ki default value ee dataset nudi assign chetshuna....

...meeru verey dataset only for voilcode tesukoni cheyi manatara.....chesthe [color=#ff0000]aa dataset values ki ee datset ki ella link kaluputham....[/color]??
[/quote]

ardham kaledhu? just inko dataset ...create chesi read only voilation code in that datset and asign that to voilation code parameter

rapchik LEGEND

rapchik

Posted
  • Author
Posted

i think i got it guys.....nenu mundhu oke dataset use chesthunde....payana chepinatu 2 datasets use chesthuna epudu ...1 for regular query..... another just for voilation codes.....i can see those values coming up now.....but should see whether i can call this voilation code valus from dataset2 from dataset 1

dotnetrockz LEGEND

dotnetrockz

Posted
Posted

[quote name='ReddyGaru_' timestamp='1380149103' post='1304306619']
i think i got it guys.....nenu mundhu oke dataset use chesthunde....payana chepinatu 2 datasets use chesthuna epudu ...1 for regular query..... another just for voilation codes.....i can see those values coming up now.....but should see whether i can call this voilation code valus from dataset2 from dataset 1
[/quote]

i think shared dataset ani oka option untundhi emo...chudu

rapchik LEGEND

rapchik

Posted
  • Author
Posted

[quote name='Nissan' timestamp='1380149190' post='1304306624']
i think shared dataset ani oka option untundhi emo...chudu
[/quote]
chustha kani...i think u can call a selected parameter from a diff dataset if you assign it in ur query

rapchik LEGEND

rapchik

Posted
  • Author
Posted

Thanks Q guys...intiki veli migathi solve chesi doubts adgutha....thanks everyone.... CITI_$D#[size=4] [/size][size=4] CITI_$D#[/size]

pandugadu999 Celebrity

pandugadu999

Posted
Posted

[quote name='ReddyGaru_' timestamp='1380148945' post='1304306597']
this is my dataset




SELECT
R.ARRRECORDID,ARRRECSTATUS,ARRCITATIONNO,
ARRDEFLNAME,
ARRDEFFNAME,ARRDEFMI,ARRDEFDOB,
ARRAGENTID,
ARRDEFSEX,
ARRJUVENILE,
ARRDEFCITY,
ARRDEFSTATE,
ARRDEFZIP,
ARRDEFRESIDENCE,
ARRDEFRACE,
ARRDEFSTRADDRESS,
ARRDEFWEIGHT,
ARRDEFHGTFT,
ARRDEFHGTINCH,
ARRDEFHAIR,
ARRDEFEYES,
ARRDEFOCCUPATION,ARRDEFEMPLOYER, ARRNARRATIVE,
VIOLCODE,
ARRVIOLDESCRIPTION,
ARRDATE,ARRDAY,ARRTIME,ARRVIOLTYPE,
RULE3CSR10,
STATUTE, CHARGECODE,
PATROLDESC, ARRCOUNTY,ARRREGION,
ARRORI, APLPLACEDESC,ARRLOCDESC,VIOLPOINTS,
RULING, RULINGBY, ARRTRIALDATE,
ARRCOURT,ARRJUDGE,
ARRCOURTCOUNTY, ARRCOURTCOST,
ARRAMTFINE, ARRAMTSUSPENDED,
ARRDAYSSENTENCED,
ARRNOOFPROBMONTH,ARRPROBATIONDATE, ARRCOMMSERVHRS,
PRVRVKDESC,ARRPRIVOTHER,
ARRPRVRVKSTARTDATE, ARRPRVRVKENDDATE,ARRREMARK,
SZRDESC,SZRTAGNO,SZRDISPOSITION, AGTLNAME,AGTFNAME,
SZRDATE,ARRAGENTFNAME, ARRAGENTLNAME
FROM
(MOPAR.TBLARRESTRECORD R
LEFT OUTER JOIN
MOPAR.TBLSEIZURES S
ON (R.ARRRECORDID = S.ARRRECORDID))

where ARRAGENTLNAME = :AgentLastName and ARRCITATIONNO = :CitationNo And

[b]VIOLCODE = :ViolationCode[/b] and ARRRECSTATUS = :RecordStatus And ARRCOUNTY = :County

and ARRREGION = :Region and ARRDEFLNAME = :DefendantLastName and

ARRDEFFNAME = :DefendantFirstName and ARRDEFDOB = :DefendantDOB and ARRDATE >= :ArrestAfterDate and ARRDATE <= :ArrestBeforeDate


epudu nenu veli aa violationCode parameter ki default value ee dataset nudi assign chetshuna....

...meeru verey dataset only for voilcode tesukoni cheyi manatara.....chesthe aa dataset values ki ee datset ki ella link kaluputham....??
[/quote]



adhi matter.....nee parameter ki datset veredi create cheyy from where u r getting all values for the parameter value [b]ViolationCode[/b]

so like this

[b]select distinct ViolationCode from XXXXXXX[/b]

rapchik LEGEND

rapchik

Posted
  • Author
Posted

[quote name='pandugadu999' timestamp='1380149342' post='1304306644']



adhi matter.....nee parameter ki datset veredi create cheyy from where u r getting all values for the parameter value [b]ViolationCode[/b]

so like this

[b]select distinct ViolationCode from XXXXXXX[/b]
[/quote]
did same thing and it worked .... #4H#[size=4] [/size][size=4] #4H#[/size]

 Share
Go to topic listing
×
×
  • Create New...