How to get Birthday member data based on from to date

Question

How to get Birthday member data from 10,000 of records based on ((from) and ( to date)) .

 

    The From and Todate contains only month and date  

 

      example  fromdate[08-Aug] todate [24-Aug]

 

please help me friends i have already spent 2 days for that Thanks in Advance

..................

Answer 1

Hi, I got the solution. The only solution to resolve these kind of issues(extra page issues in rdlc) is .... In the report designer, reduce the width of the table and report body. Keep this relation in mind: report body width must be <= (report width - report margins width). Ideally Report widht and height should be 8.5in and 11 In respectively.

Answer 2

Then please suggest me the alternate solution for my problem. Please reply as soon as possible.

Answer 3

Hi Alibasha, 

The problem is every subreport control has an implicit KeepTogether property which tries to keep the content of the subreport together inside the page. This has a problem.

Say your subreport 1 tries to keep everything inside the page, but cannot find the space enough to show everything. It then go ahead and keep this page blank and write everything on a new separate page. This is a known bug in SQL server reporting service. So it is recommended to avoid using subreport inside rdl files to support continuous printing.