How to show table header, footer even when the dataset is empty?

hi,

Just got a question about the report. When my report does not get any data from database, like dataset is empty, it will show nothing. This is reasonable. But what our customers want is, they still need to show the table header, footer, but no data.

Thanks.

Hi, what you desire appears to be the default behavior in RS 2005 unless NoRows is specified.

How to show table header, footer even when the dataset is empty?

hi,
Just got a question about the report. When my report does not get any
data from database, like dataset is empty, it will show nothing. This
is reasonable. But what our customers want is, they still need to show
the table header, footer, but no data.
ThanksHi Nick,
What is in the table headers and footers...dataset field values only
or possibly the header or footer has text? If you do have text in the
header or footer and they don't appear, check the NoRows property for
the table...any text or string value expression you set will cause the
table to not appear in favor of the expression you set. Text in
headers or footers does display, by default, even if a table has no
records...so you can also check for condittional logic that is hiding
the header or footer.
Maybe you can explain what your table headers and footers have in them?
If it's all dataset field vlaues-what shoud appear?
MattA
Reporting Services Newsletter at www.reportarchitex.com

How to show table header in each page

I want the table header appears in each page, how can i do this?
Thanks.
JasonClick on the Table header row handler,go to properties, you can see
Repeatonnewpage property,Enable it.that's it
Jason Chan wrote:
> I want the table header appears in each page, how can i do this?
> Thanks.
> Jason|||Got it. Thanks
"RajDeep" wrote:
> Click on the Table header row handler,go to properties, you can see
> Repeatonnewpage property,Enable it.that's it
> Jason Chan wrote:
> > I want the table header appears in each page, how can i do this?
> >
> > Thanks.
> >
> > Jason
>sql

How to show group header/footer again after hiding them?

I have started to work on a report with table data region, and there
was need to sort the records withing a group, so I created a new
group, assigned the appropriate sort order, and then cleared "Include
group header" and "Include group footer" checkboxes. Because of this
the group did not show up in the layout window. But now I want to make
some changes to the sort, and I could not find a way to get to the
group definition again. Please help. Thanks.Found the solution. From Table Properties, go to Groups tab, and then
you can manage the groups there.

How to set the height of the report body/table dynamically

Hi
I have a report of 8.5"(W) by 11"(H).The header and footer size are fixed.
The header size is 4.75 in and footer size is 2.375in.
In the report body I have a table where the data is dynamic.
The problem is when the data is small i mean like 2 or 3 columns it doesnt touch the footer .
If we have more than 10 columns or so it goes to the next page and even then it doesnt touch the footer beacuse the data stops there.
If we have like 4 columns or so in the table then it touches the footer.
I tried to replace the table with the list but I got the same problem there also.
I tried to place the table in a rectangle and it has the same problem.
I want the table to touch the footer no matter how much the data is .
Is there any work around for this problem?

I really appreciate your help and time
Thanks
Hobbs

Hello,

The table will always grow based on its content. We do not currentlly support "Fill To Page" functionallity. Do you want the table style (borders and background color) to fill the page? Did you try settting the style on the report body?

Thank you,

Nico

|||

Hi Nico

Thanks for the reply.I tried the boderstyle of body and the table but it stops wherever the data ends.

I can send you the rdl file or the exported pdf if u want a take look at what I am talking about.And also I have a the bordstyle of the table column set to solid.even that one stops with the last data.

I was thinking if we have something like calulcating the line height or may be fill the gap after the table somehow dynamically then only fix it.

Thanks

Hobbs

|||

Did you solve it? I've got the same problem. I've got a report that needs border around it. If i use body's border then i can see the report correctly in report manager or after rendering it to pdf. But when i try to print from report manager right hand side border is missing. Printing of the report from rendered pdf file is fine. I tried few things like, created bland report with body only with border style to solid. I could see the border and print the border correctly. Then i added page header/footer and suddenly the right hand side border was missing. I think its bug. check this link http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=115351. I checked all the margin and layout setup everything is correct. Don't know how to get it working?

Regards,

Vivek

How to set the height of the report body/table dynamically

Hi
I have a report of 8.5"(W) by 11"(H).The header and footer size are fixed.
The header size is 4.75 in and footer size is 2.375in.
In the report body I have a table where the data is dynamic.
The problem is when the data is small i mean like 2 or 3 columns it doesnt touch the footer .
If we have more than 10 columns or so it goes to the next page and even then it doesnt touch the footer beacuse the data stops there.
If we have like 4 columns or so in the table then it touches the footer.
I tried to replace the table with the list but I got the same problem there also.
I tried to place the table in a rectangle and it has the same problem.
I want the table to touch the footer no matter how much the data is .
Is there any work around for this problem?

I really appreciate your help and time
Thanks
Hobbs

Hello,

The table will always grow based on its content. We do not currentlly support "Fill To Page" functionallity. Do you want the table style (borders and background color) to fill the page? Did you try settting the style on the report body?

Thank you,

Nico

|||

Hi Nico

Thanks for the reply.I tried the boderstyle of body and the table but it stops wherever the data ends.

I can send you the rdl file or the exported pdf if u want a take look at what I am talking about.And also I have a the bordstyle of the table column set to solid.even that one stops with the last data.

I was thinking if we have something like calulcating the line height or may be fill the gap after the table somehow dynamically then only fix it.

Thanks

Hobbs

|||

Did you solve it? I've got the same problem. I've got a report that needs border around it. If i use body's border then i can see the report correctly in report manager or after rendering it to pdf. But when i try to print from report manager right hand side border is missing. Printing of the report from rendered pdf file is fine. I tried few things like, created bland report with body only with border style to solid. I could see the border and print the border correctly. Then i added page header/footer and suddenly the right hand side border was missing. I think its bug. check this link http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=115351. I checked all the margin and layout setup everything is correct. Don't know how to get it working?

Regards,

Vivek

how to set image as background image to report

i want to set background image to report can any one tell how to set to whole report. i can set image to header, fotter, details, etc but cannot set for whole reportif you have CR XI, there are some examples of templates, one of the templates is a confidential underlay. That is a least one way to do this. also look for underlay following sections (in section expert) add your graphic to a page header, and select underlay following sections.|||Try this:
Insert another Page Header section (PHb), expand this new section that it would be the size of your page. Place your picture in the center of the PHb.
Then in the Section Expert, select the PHb section and check the "Underlay Following Sections".