Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Report Header Problem

Unanswered Report Header Problem

  • Monday, February 18, 2013 5:55 PM
     
     
    Sign In to Vote
    0

    Hi All,

       I am facing some problem with report header.Please guide me to solve the issue.

     I have one table like below.

                                             

                                               EMPLOYEES

    DepartNo :10                        FromDate :18/02/2012                          ToDate:18/02/2013

    Rows are coming here.

    Employees is the Header of the report.

    DepartNo,Fromdate,Todate  are parameter values which i shown in the report.Next data is coming in multiple pages.

    Here All are set in single table.

    I want repeat the HeaderName and column names  for each page.Here header is displayed by using subreport.

    I tried but i got the all three(Header,Parameterinfo,columnnames)per each page .But i want Header and column names 

    per each page .

                   

    Thanks&Regards,

    S.Harikrishna.


     

All Replies

  • Monday, February 18, 2013 6:35 PM
     
     
    Sign In to Vote
    0

    Hi,

    Right now, all 3 information are coming each page? and you only want header and column to show for each page without the parameter? Is the parameter info in the page header or the group header? If in the page header, you can set textbox visibility to this:

    =IIF(Globals!OverallPageNumber=1,True,False)

    So if page is 1, display the parameter textbox. After page 1, you will only see the header and column names for each page without the parameter info. I'm only guessing that this is what you want. If not, please explain more clearly.

    Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

    k r o o t z

     
  • Tuesday, February 19, 2013 6:18 PM
     
     
    Sign In to Vote
    0

    Hi Krootz,

     Thanks for your reply.In my report i am setting sub report in first row,parameter info in next two rows and next table  row is for column names.

            In this way  i set the above information and set the properties for  repeating on each page column names and header.

    Thanks&Regards,

    S.Harikrishna.

    

     
  • Thursday, February 21, 2013 1:09 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi S.Harikrishna,

    I am not very clear about the report structure and your requirement. Could you post a screenshot to show the report structure for further analysis? Then we will try to reproduce the issue and help you out.

    Regards,

    Mike Yin
    TechNet Community Support