nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

parameter for a detail report

chandra t · 2013-10-03T09:50:22+00:00

I have created a detail report for workorder, while creating the datasets and all I have used wonum in ('" +(params["wonum"].toUpperCase())+"') ) as the parameter for each dataset as well as…

chandra t

I have created a detail report for workorder,while creating the datasets and all I have used wonum in ('" +(params["wonum"].toUpperCase())+"') ) as the parameter for each dataset as well as the dataset , But for a detail report as we dont have any input parameter I am in confusion how to retrive the data for the current record? Should I use something like + rows[0]["wonum"].replace(/'/g,"''")?? Please let me know Thanks in advance

Find more posts tagged with

Comments

wwilliams

If this is Maximo, look at the supplied detail reports.+ " where " + params["where"]

chandra t

Thanks for the quick response WIlliams I tiried in different ways but If I use + " where " + params["where"]will it retrive the current record? more over I have 6 datasets and in each dataset I am using inputparameter in where condition Thanks

pvaterlaus

Hi Chandra I had a similar issue working with a sub report for Maximo. I had tried all of the parameter markers and data bindings that were suggested but all failed. What worked was a simple reference to the column I wanted to use, just like you suggested in your first post:[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]rows[0]["wonum"][/color] [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]A useful tool I found is to have a label print out the combined SQL query when the page is rendered. This gave me lots of insight as to whether or not the script was picking up the correct data I expected to see. Lots of times I wasn't getting any data that I was expecting and the query label showed quite easily that a null value was being passed.[/color] [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]I hope this helps!

[/color]

chandra t

As mentioned by williams in couple of cases I am able to use where " + params["where"] 
for the remaining I need to check with[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]rows[0]["wonum"][/color] [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]any idea what is the use replace(/'/g,"''")??[/color] [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Thanks[/color]