Post reply

About SubReports Where there''s no data

  • October 9, 2005 at 2:02 am

    #165808

    Well I built a report which contain 3 rows of details:one contain the details of the current report and in each other row there's a subreport.

    It work great,but when where's no data on the subreport i get a blank detail row even though there's a textbox that allways visible or i wrote somthing in the NoRows property but i it does'nt appear.

    Why??? is there a way 2 solve this??? 

  • October 11, 2005 at 1:50 pm

    #596650

    You need to assign value to NoRows property of the sub-report OBJECT on the main (parent) report. You can do it by just selecting that sub-report object on main report and assign something to NoRows property in the Property Window.

    Hope this will help.

     

  • October 11, 2005 at 11:54 pm

    #596710

    Thanks,but still why the textbox or label that in the sub-report don't appear???

  • October 13, 2005 at 7:27 am

    #597072

    Well, if there is a DataSet in subreport, it is associated with NoRows property, and subreport object on main report return only whatever is assigned to this property if that DataSet didn’t returned any data, ignoring all other items. So your options are either make that query or SP to atleast return one row to that DataSet or other option is don’t have any DataSet on subreport to make those textboxes and other non-data items displayed.

    Well, as far as performance is concern, we should avoid using subreports. Also we do have some limitations when working with subreports, like only body of a subreport can be displayed on main report (no header and no footer).

  • October 15, 2005 at 11:27 pm

    #597514

    Well thanks again.

    Every day we learn something new

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply