Comments by Member 10546877 (Top 2 by date)

Member 10546877 6-Jan-15 8:11am View

Thanks for your Answer,
it took me near to the solution, but not exactly, little bit far from solution...

now let say KPI_ID 1001, and 1002 has values for 201401(JAN 2014),
AND if i select Jan 2014, it shows me correct result...all KPI_ID with or without values..

But if i select Mar 2014, it does not shows me KPI_ID 1001, and 1002..

because i think these two KPI Has values for Jan 2014 and Feb 2014..

But i want to see all .... i will add values for march 2014...

if you pass parameter '201403%' in your query, you will not see KPI_ID 1001, and 1002,,,

Many Thanks...

is it clear...? Please

Member 10546877 6-Jan-15 7:16am View

Yes, Up to here, its working... fine..

But i have two drop down list, out side the grid view, where user can select the year AND OR Month to see Values
for selected Year Month... i am using Like keyword and matching selected month year, with value_date..

for example User Select Year = 2014, and month = Jan, then in the query i am getting selected values and concatenating them like where Value_Date Like '201401%',

but if value_Date is null for a record , then its not showing that record...

i want to show all record, if a record in null, then user will enter a value for it, other wise he can see if he already has entered value...
hope its clear now.....

Thanks for your answers...