I have a subreport in that group footer section of my main report, say in section GF1b. The subreport is linked with the main report via employee id. The main report passes ID to the subreport and subreport returns results based upon that ID.
Here is the problem, there is a shared variable at the footer of the subreport that stores count of records. Now I have a formula on the main report that receives that value of count and I have a conditional supress function for GF1b section. The function checks the value of the the count and if count =0 then it should supress whole section, otherwise show the section. But what is happening is it is supressing the whole section even if count is 4, or 5 or >0.
My formula on main report is returning correct count.
Any idea why whole section gets supressed even if the count is >0?
I am using CR8.5 with SQL Server.
Here is the problem, there is a shared variable at the footer of the subreport that stores count of records. Now I have a formula on the main report that receives that value of count and I have a conditional supress function for GF1b section. The function checks the value of the the count and if count =0 then it should supress whole section, otherwise show the section. But what is happening is it is supressing the whole section even if count is 4, or 5 or >0.
My formula on main report is returning correct count.
Any idea why whole section gets supressed even if the count is >0?
I am using CR8.5 with SQL Server.