Reporting services--Problem with the subreport
-
Hi All, I have a table report which has 10 fields as cols.The last 2 fields come from 2 diffrent subreport, having a single field each. There are also 2 groups in this table. I have to limit the rows by checking each cell in a group is 0. If all the cells have got a 0 then hide the row. I can check for all the cells except the last 2(Subreport). Since the last 2 cells has only got 2 subreports instead of a textbox, as it is the case for the remaining 8 cells, i don't know how to check for data returning from a subreport. For all the other textboxes i have checked it as ReportItems!textbox1.value=0 Can anyone help me with this Please? Thanks & Regards, Payal
-
Hi All, I have a table report which has 10 fields as cols.The last 2 fields come from 2 diffrent subreport, having a single field each. There are also 2 groups in this table. I have to limit the rows by checking each cell in a group is 0. If all the cells have got a 0 then hide the row. I can check for all the cells except the last 2(Subreport). Since the last 2 cells has only got 2 subreports instead of a textbox, as it is the case for the remaining 8 cells, i don't know how to check for data returning from a subreport. For all the other textboxes i have checked it as ReportItems!textbox1.value=0 Can anyone help me with this Please? Thanks & Regards, Payal
-
Subreport report items have a
NoRowsproperty. You can check its value to determine whether any data has been returned for the subreport.Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
Thanks Paul :) . Can this property be checked from the main report? I don't know how to refer the subreport from the main report...Like ReportItems!txtbox1 is there options for referring to a subreport also? It will be really helpful if u could help me out with some examples as i am coming across this for the first time. Cheers Payal