Report objects shift to right on very wide report - why?

Greetings,

I have a very wide report of more than 20 inches. I've placed several parameter values in the report header section so that the user can see what filters have been applied to the data. The testboxes shift their position several inches to the right when the report is run from the Report Manager.

Is there a way to make sure that a textbox is displayed at an absolute position? I thought maybe there would be a property on the report or body object that controls this but I don't see one.

Thanks for your help,

BCB

It may be because your left margin is high. Check how much left margin you have specified in Report (menu) -> Report Properties -> Layout (tab).

Shyam

|||Hi,

I've found similar (non-reproducible) behaviour sometimes, I've solved it putting all the "affected" items inside a rectangle control.

HTH

Jordi Rambla|||

Oh my, having the same problem and it drives me NUTS. Keeps kicking my textboxes to the right without any logical explanation I could think of. In layout tab, everything is fine. In preview tab, some textboxes that reside in Body, are shifted chaotically to the right, sometimes beyond the right border of the first page. When report is deployed and viewed, the position of the textboxes changes but they are still far on the right side. And finally in the printout, position may change once again and still not where I meant them to be. Nice WYSIWYG I should say.

My report is very simple, it contains a table and a matrix region. The textboxes in question hold the information about parameters and about printing time. The layout of the page is A4 landscape, with 15mm left margin and 10mm other margins. Does anybody have an idea what is going on? A bug? And by the way, enclosing textboxes into rectangle object doesn't work for me.

Denis

|||

Try increasing the Interactive Size or Report Size (properties found on the report object). In my case the browser seemed to want to treat the location of the text boxes I had in the page header as a percentage of page width rather than an obsolute location. The actual report was much wider than the property width (I forget which of the two properties I changed). When I increased page width the text boxes stopped shifting right or at least moved a very small amount that was tolerable. This all took place within the PageHeader section.

BCB

|||

Thank you very much for your reply.

I tried playing with "Interactive size" properties of the Report object, but that didn't change anything. BTW in my case, the interactive size values were wrong too, compared to the actual size of the reporting sections.

But then, I moved my textboxes from Body to the Page Header section, and that solved the problem. Now textboxes stay where they are in both Design, Preview and printed report.

Upon further investigation, the awful truth finally revealed itself. My report utilizes a matrix control to display variable amount of columns. It turns out that when matrix is expanding to the right at runtime, it will "push out" everything that is located on the right side of it in the design tab. Only controls located in the same section (usually Body) will be affected. What confuses me most, the vertical position of controls doesn't matter, as soon as .Left property of a control is greater than the right border of the matrix in the design tab, the control will be shifted to the right at runtime.

Since Report Designer does not support user-defined sections to split Body into individual parts, the only solution seems to be enclosing controls into Rectangle object to keep it on the left from the evil matrix control. Just as Jordi recommended.

Denis

Report objects shift to right on very wide report - why?

Greetings,

I have a very wide report of more than 20 inches. I've placed several parameter values in the report header section so that the user can see what filters have been applied to the data. The testboxes shift their position several inches to the right when the report is run from the Report Manager.

Is there a way to make sure that a textbox is displayed at an absolute position? I thought maybe there would be a property on the report or body object that controls this but I don't see one.

Thanks for your help,

BCB

It may be because your left margin is high. Check how much left margin you have specified in Report (menu) -> Report Properties -> Layout (tab).

Shyam

|||Hi,

I've found similar (non-reproducible) behaviour sometimes, I've solved it putting all the "affected" items inside a rectangle control.

HTH

Jordi Rambla|||

Oh my, having the same problem and it drives me NUTS. Keeps kicking my textboxes to the right without any logical explanation I could think of. In layout tab, everything is fine. In preview tab, some textboxes that reside in Body, are shifted chaotically to the right, sometimes beyond the right border of the first page. When report is deployed and viewed, the position of the textboxes changes but they are still far on the right side. And finally in the printout, position may change once again and still not where I meant them to be. Nice WYSIWYG I should say.

My report is very simple, it contains a table and a matrix region. The textboxes in question hold the information about parameters and about printing time. The layout of the page is A4 landscape, with 15mm left margin and 10mm other margins. Does anybody have an idea what is going on? A bug? And by the way, enclosing textboxes into rectangle object doesn't work for me.

Denis

|||

Try increasing the Interactive Size or Report Size (properties found on the report object). In my case the browser seemed to want to treat the location of the text boxes I had in the page header as a percentage of page width rather than an obsolute location. The actual report was much wider than the property width (I forget which of the two properties I changed). When I increased page width the text boxes stopped shifting right or at least moved a very small amount that was tolerable. This all took place within the PageHeader section.

BCB

|||

Thank you very much for your reply.

I tried playing with "Interactive size" properties of the Report object, but that didn't change anything. BTW in my case, the interactive size values were wrong too, compared to the actual size of the reporting sections.

But then, I moved my textboxes from Body to the Page Header section, and that solved the problem. Now textboxes stay where they are in both Design, Preview and printed report.

Upon further investigation, the awful truth finally revealed itself. My report utilizes a matrix control to display variable amount of columns. It turns out that when matrix is expanding to the right at runtime, it will "push out" everything that is located on the right side of it in the design tab. Only controls located in the same section (usually Body) will be affected. What confuses me most, the vertical position of controls doesn't matter, as soon as .Left property of a control is greater than the right border of the matrix in the design tab, the control will be shifted to the right at runtime.

Since Report Designer does not support user-defined sections to split Body into individual parts, the only solution seems to be enclosing controls into Rectangle object to keep it on the left from the evil matrix control. Just as Jordi recommended.

Denis

Report objects shift to right on very wide report - why?

Greetings,

I have a very wide report of more than 20 inches. I've placed several parameter values in the report header section so that the user can see what filters have been applied to the data. The testboxes shift their position several inches to the right when the report is run from the Report Manager.

Is there a way to make sure that a textbox is displayed at an absolute position? I thought maybe there would be a property on the report or body object that controls this but I don't see one.

Thanks for your help,

BCB

It may be because your left margin is high. Check how much left margin you have specified in Report (menu) -> Report Properties -> Layout (tab).

Shyam

|||Hi,

I've found similar (non-reproducible) behaviour sometimes, I've solved it putting all the "affected" items inside a rectangle control.

HTH

Jordi Rambla|||

Oh my, having the same problem and it drives me NUTS. Keeps kicking my textboxes to the right without any logical explanation I could think of. In layout tab, everything is fine. In preview tab, some textboxes that reside in Body, are shifted chaotically to the right, sometimes beyond the right border of the first page. When report is deployed and viewed, the position of the textboxes changes but they are still far on the right side. And finally in the printout, position may change once again and still not where I meant them to be. Nice WYSIWYG I should say.

My report is very simple, it contains a table and a matrix region. The textboxes in question hold the information about parameters and about printing time. The layout of the page is A4 landscape, with 15mm left margin and 10mm other margins. Does anybody have an idea what is going on? A bug? And by the way, enclosing textboxes into rectangle object doesn't work for me.

Denis

|||

Try increasing the Interactive Size or Report Size (properties found on the report object). In my case the browser seemed to want to treat the location of the text boxes I had in the page header as a percentage of page width rather than an obsolute location. The actual report was much wider than the property width (I forget which of the two properties I changed). When I increased page width the text boxes stopped shifting right or at least moved a very small amount that was tolerable. This all took place within the PageHeader section.

BCB

|||

Thank you very much for your reply.

I tried playing with "Interactive size" properties of the Report object, but that didn't change anything. BTW in my case, the interactive size values were wrong too, compared to the actual size of the reporting sections.

But then, I moved my textboxes from Body to the Page Header section, and that solved the problem. Now textboxes stay where they are in both Design, Preview and printed report.

Upon further investigation, the awful truth finally revealed itself. My report utilizes a matrix control to display variable amount of columns. It turns out that when matrix is expanding to the right at runtime, it will "push out" everything that is located on the right side of it in the design tab. Only controls located in the same section (usually Body) will be affected. What confuses me most, the vertical position of controls doesn't matter, as soon as .Left property of a control is greater than the right border of the matrix in the design tab, the control will be shifted to the right at runtime.

Since Report Designer does not support user-defined sections to split Body into individual parts, the only solution seems to be enclosing controls into Rectangle object to keep it on the left from the evil matrix control. Just as Jordi recommended.

Denis

Report not using pagination properly

I have a portrait report that has 1 table with 1 hidden group header (for the Page Header to reference fields from) and 36 detail rows. My problem is that pagination is not working properly. Depending on the length of data in the detail rows, the report tends to push majority of data on the next page(s) which leaves a lot of blank lines or blank page at the beginning of each group of data. I want the data to complete the first page before rolling over to the next page. That's why I have 36 individual detail rows instead of all the data in 1 detail row. I've tried adjusting the page length, but it doesn't seem to work all that well. I either get all the report on one page (which is fine when viewing online, but data is cut off when printing) or inadequate pagination. I do not have any white space at the bottom of the table and the page footer. Anyone have any ideas?

Thanks,

T

Have you tried setting KeepTogether=false on your table? The behavior your describing sounds like it's set to true, which would mean that if the table can't fit completely on the current page, but will fit on the next page, it will move the table to the next page.

You shouldn't need to specify the detail rows individually if you're populating from a data source!|||Yes, KeepTogether is false and yes I am using a shared data source and data is queried using Stored Procedure.|||Well it seems the problem lies within the Group Header row. I removed that row and pagination works properly now, but I lose the ability to call fields in my page header when the report spans more than one page.|||

Ok, I found a solution for showing Field values in Page Header even when the report spans more than one page(but you don't know at what point the report spans to the next page). It's a combination of several solutions:

1) Create hidden textbox(es) with the field value you're wanting on every line where the page might span to the next page.

textbox1

textbox2

textbox3

2) Create a function in code that will reference each hidden textbox(es) by name

Shared Function Header(reportItems as ReportItems) as string
Dim final as string
If ReportItems!textbox1.value <> "" Then
final = ReportItems!textbox1.value
Else If ReportItems!textbox2.value <> "" Then
final = ReportItems!textbox2.value
Else If ReportItems!textbox3.value <> "" Then
final = ReportItems!textbox3.value
End If
Return final
End Function

3) In Page Header call function, pass (ReportItems)

=Code.Header(ReportItems)

The reason for the function is because you can't reference multiple ReportItems in Page Header textbox, so you have to determine which hidden textbox has a value on that page and return that value to the calling Header textbox. Hope this helps....

sql

Report Manager - Blank Reports Page

Hi,

I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space.

I had it working fine a week ago. Any ideas?

The RS runs on Win2003 Std, SQL 2005 Std.

Thanks

Very likely the account that you use to connect to report manager no longer has permission. Connect as a admin and check your permissions.|||

I'm connecting as administrator.

Speaking about permission... Which permissions are you talking about?

Thanks

|||I am talking about RS permissions. In report manager look at the property tab of the home page. But I guess you are not seeing the tab either?|||

You are right.

I'm getting just a header part of the page:

"SQL Server Reporting Services - Home" and few other links like "Home", "My Subscriptions", etc.

Does any one have an idea how this page rendered?

What can cause this part of the page to be blank?

Thanks,

Mark

|||

Log in locally on your report server computer as a member of the Local Administrators group. Then on the home folder, select Properties, go to Security and give the users you want the access level you want them to have.

This help topic will give you a starting point for learning about how to secure reporting services:

http://msdn2.microsoft.com/en-us/library/ms157198.aspx

Hope that helps,

-Lukasz

|||I am having the same problem. What home folder do you mean?

|||

When you first launch report manager, it defaults to the home folder. This is also known as the 'root' or the folder with path "/". You need to login as a local admin on the report server computer, then you should see the properties tab and be able to get to the security tab.

-Lukasz

|||Yeah my problem is that I don't see any of that. I really get nothing except a couple of links in the top corner for home and subscriptions and an icon for a folder on the left and side that does nothing. As far as i can tell I am logged in as an administrator. I have also changed the authentication from anonymous to windows like I have read elsewhere. Something tells me the only thing left to do is uninstall and reinstall.
|||

instereo,

I found that incorrect virtual directory mapping caused the problem.

Check whether each virtual directory of reporting services in IIS has phisycal folder mapped:

in my case, I created dedicated web site in IIS for 2 reports virtual directories, and my problem was a physical folder mapped for this dedicated site - it had no "home directory" mapped,actually, for "reportserver" virtual directory.

Hope it will help you

Mark

|||

If you're accessing the machine remotely, try logging onto it as a member of the local administrators group and trying to open report manager.

The other thing you can do is check that your Virtual directory settings are correct in the reporting services configuration tool. Go to the report server and report manager virtual directory tabs and click the "apply default settings" button on each.

you should see some buttons on a tool bar allowing you to upload a file, etc.

-Lukasz

|||I did end up getting it to work. I reinstalled SQL Server and reconfigured everything. For some reason my default website was not working in IIS and upon further investigation i found that i was missing my wwwroot directory. So i copied this file from a co-worker but the security setting were all wrong. I don't know how to properly configure this directory so i just made an Everyone group with all access. Not the best thing to do for sure, however everything works now.
|||ok, I have done everything that has been suggested above. I am currently logged in as local admin. Given that I should at least see the properties in order to add or change permissions, however, I dont. Everything lines up in report server configuration. The only ones not green are the keyfile (optional) and initialization (not a developers edition)

So, what gives?
|||

I would really appreciate if anyone could provide the solutions for this problem.

I'm running SQL Server 2005 and reporting service in a computer with Vista Business.

I've already tried every single method that I could find find on the internet included disabling anonymous login for both Reports and ReportServer in IIS manager. However, I still can only see HOME, MY SUBSCRIPTIONS and HELP link on the header only. The rest is all blank below.

ps: I'm able to connect to Reporting Service Configuration with green checkmarks on those necessary components without any error.

Please help..

|||

First, you willl need to do the steps that I listed previously in this forum thread.

If you login locally, you will also need to add both the report server and report manager URLs to Trusted Sites if you are using IE.

Let me know if this solves your problem.

-Lukasz

Report Manager - Blank Reports Page

Hi,

I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space.

I had it working fine a week ago. Any ideas?

The RS runs on Win2003 Std, SQL 2005 Std.

Thanks

Very likely the account that you use to connect to report manager no longer has permission. Connect as a admin and check your permissions.|||

I'm connecting as administrator.

Speaking about permission... Which permissions are you talking about?

Thanks

|||I am talking about RS permissions. In report manager look at the property tab of the home page. But I guess you are not seeing the tab either?|||

You are right.

I'm getting just a header part of the page:

"SQL Server Reporting Services - Home" and few other links like "Home", "My Subscriptions", etc.

Does any one have an idea how this page rendered?

What can cause this part of the page to be blank?

Thanks,

Mark

|||

Log in locally on your report server computer as a member of the Local Administrators group. Then on the home folder, select Properties, go to Security and give the users you want the access level you want them to have.

This help topic will give you a starting point for learning about how to secure reporting services:

http://msdn2.microsoft.com/en-us/library/ms157198.aspx

Hope that helps,

-Lukasz

|||I am having the same problem. What home folder do you mean?|||

When you first launch report manager, it defaults to the home folder. This is also known as the 'root' or the folder with path "/". You need to login as a local admin on the report server computer, then you should see the properties tab and be able to get to the security tab.

-Lukasz

|||Yeah my problem is that I don't see any of that. I really get nothing except a couple of links in the top corner for home and subscriptions and an icon for a folder on the left and side that does nothing. As far as i can tell I am logged in as an administrator. I have also changed the authentication from anonymous to windows like I have read elsewhere. Something tells me the only thing left to do is uninstall and reinstall.|||

instereo,

I found that incorrect virtual directory mapping caused the problem.

Check whether each virtual directory of reporting services in IIS has phisycal folder mapped:

in my case, I created dedicated web site in IIS for 2 reports virtual directories, and my problem was a physical folder mapped for this dedicated site - it had no "home directory" mapped,actually, for "reportserver" virtual directory.

Hope it will help you

Mark

|||

If you're accessing the machine remotely, try logging onto it as a member of the local administrators group and trying to open report manager.

The other thing you can do is check that your Virtual directory settings are correct in the reporting services configuration tool. Go to the report server and report manager virtual directory tabs and click the "apply default settings" button on each.

you should see some buttons on a tool bar allowing you to upload a file, etc.

-Lukasz

|||I did end up getting it to work. I reinstalled SQL Server and reconfigured everything. For some reason my default website was not working in IIS and upon further investigation i found that i was missing my wwwroot directory. So i copied this file from a co-worker but the security setting were all wrong. I don't know how to properly configure this directory so i just made an Everyone group with all access. Not the best thing to do for sure, however everything works now.|||ok, I have done everything that has been suggested above. I am currently logged in as local admin. Given that I should at least see the properties in order to add or change permissions, however, I dont. Everything lines up in report server configuration. The only ones not green are the keyfile (optional) and initialization (not a developers edition)

So, what gives?|||

I would really appreciate if anyone could provide the solutions for this problem.

I'm running SQL Server 2005 and reporting service in a computer with Vista Business.

I've already tried every single method that I could find find on the internet included disabling anonymous login for both Reports and ReportServer in IIS manager. However, I still can only see HOME, MY SUBSCRIPTIONS and HELP link on the header only. The rest is all blank below.

ps: I'm able to connect to Reporting Service Configuration with green checkmarks on those necessary components without any error.

Please help..

|||

First, you willl need to do the steps that I listed previously in this forum thread.

If you login locally, you will also need to add both the report server and report manager URLs to Trusted Sites if you are using IE.

Let me know if this solves your problem.

-Lukasz

Report Manager - Blank Reports Page

Hi,

I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space.

I had it working fine a week ago. Any ideas?

The RS runs on Win2003 Std, SQL 2005 Std.

Thanks

Very likely the account that you use to connect to report manager no longer has permission. Connect as a admin and check your permissions.|||

I'm connecting as administrator.

Speaking about permission... Which permissions are you talking about?

Thanks

|||I am talking about RS permissions. In report manager look at the property tab of the home page. But I guess you are not seeing the tab either?|||

You are right.

I'm getting just a header part of the page:

"SQL Server Reporting Services - Home" and few other links like "Home", "My Subscriptions", etc.

Does any one have an idea how this page rendered?

What can cause this part of the page to be blank?

Thanks,

Mark

|||

Log in locally on your report server computer as a member of the Local Administrators group. Then on the home folder, select Properties, go to Security and give the users you want the access level you want them to have.

This help topic will give you a starting point for learning about how to secure reporting services:

http://msdn2.microsoft.com/en-us/library/ms157198.aspx

Hope that helps,

-Lukasz

|||I am having the same problem. What home folder do you mean?

|||

When you first launch report manager, it defaults to the home folder. This is also known as the 'root' or the folder with path "/". You need to login as a local admin on the report server computer, then you should see the properties tab and be able to get to the security tab.

-Lukasz

|||Yeah my problem is that I don't see any of that. I really get nothing except a couple of links in the top corner for home and subscriptions and an icon for a folder on the left and side that does nothing. As far as i can tell I am logged in as an administrator. I have also changed the authentication from anonymous to windows like I have read elsewhere. Something tells me the only thing left to do is uninstall and reinstall.
|||

instereo,

I found that incorrect virtual directory mapping caused the problem.

Check whether each virtual directory of reporting services in IIS has phisycal folder mapped:

in my case, I created dedicated web site in IIS for 2 reports virtual directories, and my problem was a physical folder mapped for this dedicated site - it had no "home directory" mapped,actually, for "reportserver" virtual directory.

Hope it will help you

Mark

|||

If you're accessing the machine remotely, try logging onto it as a member of the local administrators group and trying to open report manager.

The other thing you can do is check that your Virtual directory settings are correct in the reporting services configuration tool. Go to the report server and report manager virtual directory tabs and click the "apply default settings" button on each.

you should see some buttons on a tool bar allowing you to upload a file, etc.

-Lukasz

|||I did end up getting it to work. I reinstalled SQL Server and reconfigured everything. For some reason my default website was not working in IIS and upon further investigation i found that i was missing my wwwroot directory. So i copied this file from a co-worker but the security setting were all wrong. I don't know how to properly configure this directory so i just made an Everyone group with all access. Not the best thing to do for sure, however everything works now.
|||ok, I have done everything that has been suggested above. I am currently logged in as local admin. Given that I should at least see the properties in order to add or change permissions, however, I dont. Everything lines up in report server configuration. The only ones not green are the keyfile (optional) and initialization (not a developers edition)

So, what gives?
|||

I would really appreciate if anyone could provide the solutions for this problem.

I'm running SQL Server 2005 and reporting service in a computer with Vista Business.

I've already tried every single method that I could find find on the internet included disabling anonymous login for both Reports and ReportServer in IIS manager. However, I still can only see HOME, MY SUBSCRIPTIONS and HELP link on the header only. The rest is all blank below.

ps: I'm able to connect to Reporting Service Configuration with green checkmarks on those necessary components without any error.

Please help..

|||

First, you willl need to do the steps that I listed previously in this forum thread.

If you login locally, you will also need to add both the report server and report manager URLs to Trusted Sites if you are using IE.

Let me know if this solves your problem.

-Lukasz

Report Manager - Blank Reports Page

Hi,

I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space.

I had it working fine a week ago. Any ideas?

The RS runs on Win2003 Std, SQL 2005 Std.

Thanks

Very likely the account that you use to connect to report manager no longer has permission. Connect as a admin and check your permissions.|||

I'm connecting as administrator.

Speaking about permission... Which permissions are you talking about?

Thanks

|||I am talking about RS permissions. In report manager look at the property tab of the home page. But I guess you are not seeing the tab either?|||

You are right.

I'm getting just a header part of the page:

"SQL Server Reporting Services - Home" and few other links like "Home", "My Subscriptions", etc.

Does any one have an idea how this page rendered?

What can cause this part of the page to be blank?

Thanks,

Mark

|||

Log in locally on your report server computer as a member of the Local Administrators group. Then on the home folder, select Properties, go to Security and give the users you want the access level you want them to have.

This help topic will give you a starting point for learning about how to secure reporting services:

http://msdn2.microsoft.com/en-us/library/ms157198.aspx

Hope that helps,

-Lukasz

|||I am having the same problem. What home folder do you mean?

|||

When you first launch report manager, it defaults to the home folder. This is also known as the 'root' or the folder with path "/". You need to login as a local admin on the report server computer, then you should see the properties tab and be able to get to the security tab.

-Lukasz

|||Yeah my problem is that I don't see any of that. I really get nothing except a couple of links in the top corner for home and subscriptions and an icon for a folder on the left and side that does nothing. As far as i can tell I am logged in as an administrator. I have also changed the authentication from anonymous to windows like I have read elsewhere. Something tells me the only thing left to do is uninstall and reinstall.
|||

instereo,

I found that incorrect virtual directory mapping caused the problem.

Check whether each virtual directory of reporting services in IIS has phisycal folder mapped:

in my case, I created dedicated web site in IIS for 2 reports virtual directories, and my problem was a physical folder mapped for this dedicated site - it had no "home directory" mapped,actually, for "reportserver" virtual directory.

Hope it will help you

Mark

|||

If you're accessing the machine remotely, try logging onto it as a member of the local administrators group and trying to open report manager.

The other thing you can do is check that your Virtual directory settings are correct in the reporting services configuration tool. Go to the report server and report manager virtual directory tabs and click the "apply default settings" button on each.

you should see some buttons on a tool bar allowing you to upload a file, etc.

-Lukasz

|||I did end up getting it to work. I reinstalled SQL Server and reconfigured everything. For some reason my default website was not working in IIS and upon further investigation i found that i was missing my wwwroot directory. So i copied this file from a co-worker but the security setting were all wrong. I don't know how to properly configure this directory so i just made an Everyone group with all access. Not the best thing to do for sure, however everything works now.
|||ok, I have done everything that has been suggested above. I am currently logged in as local admin. Given that I should at least see the properties in order to add or change permissions, however, I dont. Everything lines up in report server configuration. The only ones not green are the keyfile (optional) and initialization (not a developers edition)

So, what gives?
|||

I would really appreciate if anyone could provide the solutions for this problem.

I'm running SQL Server 2005 and reporting service in a computer with Vista Business.

I've already tried every single method that I could find find on the internet included disabling anonymous login for both Reports and ReportServer in IIS manager. However, I still can only see HOME, MY SUBSCRIPTIONS and HELP link on the header only. The rest is all blank below.

ps: I'm able to connect to Reporting Service Configuration with green checkmarks on those necessary components without any error.

Please help..

|||

First, you willl need to do the steps that I listed previously in this forum thread.

If you login locally, you will also need to add both the report server and report manager URLs to Trusted Sites if you are using IE.

Let me know if this solves your problem.

-Lukasz

Report Manager - Blank Reports Page

Hi,

I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space.

I had it working fine a week ago. Any ideas?

The RS runs on Win2003 Std, SQL 2005 Std.

Thanks

Very likely the account that you use to connect to report manager no longer has permission. Connect as a admin and check your permissions.|||

I'm connecting as administrator.

Speaking about permission... Which permissions are you talking about?

Thanks

|||I am talking about RS permissions. In report manager look at the property tab of the home page. But I guess you are not seeing the tab either?|||

You are right.

I'm getting just a header part of the page:

"SQL Server Reporting Services - Home" and few other links like "Home", "My Subscriptions", etc.

Does any one have an idea how this page rendered?

What can cause this part of the page to be blank?

Thanks,

Mark

|||

Log in locally on your report server computer as a member of the Local Administrators group. Then on the home folder, select Properties, go to Security and give the users you want the access level you want them to have.

This help topic will give you a starting point for learning about how to secure reporting services:

http://msdn2.microsoft.com/en-us/library/ms157198.aspx

Hope that helps,

-Lukasz

|||I am having the same problem. What home folder do you mean?

|||

When you first launch report manager, it defaults to the home folder. This is also known as the 'root' or the folder with path "/". You need to login as a local admin on the report server computer, then you should see the properties tab and be able to get to the security tab.

-Lukasz

|||Yeah my problem is that I don't see any of that. I really get nothing except a couple of links in the top corner for home and subscriptions and an icon for a folder on the left and side that does nothing. As far as i can tell I am logged in as an administrator. I have also changed the authentication from anonymous to windows like I have read elsewhere. Something tells me the only thing left to do is uninstall and reinstall.
|||

instereo,

I found that incorrect virtual directory mapping caused the problem.

Check whether each virtual directory of reporting services in IIS has phisycal folder mapped:

in my case, I created dedicated web site in IIS for 2 reports virtual directories, and my problem was a physical folder mapped for this dedicated site - it had no "home directory" mapped,actually, for "reportserver" virtual directory.

Hope it will help you

Mark

|||

If you're accessing the machine remotely, try logging onto it as a member of the local administrators group and trying to open report manager.

The other thing you can do is check that your Virtual directory settings are correct in the reporting services configuration tool. Go to the report server and report manager virtual directory tabs and click the "apply default settings" button on each.

you should see some buttons on a tool bar allowing you to upload a file, etc.

-Lukasz

|||I did end up getting it to work. I reinstalled SQL Server and reconfigured everything. For some reason my default website was not working in IIS and upon further investigation i found that i was missing my wwwroot directory. So i copied this file from a co-worker but the security setting were all wrong. I don't know how to properly configure this directory so i just made an Everyone group with all access. Not the best thing to do for sure, however everything works now.
|||ok, I have done everything that has been suggested above. I am currently logged in as local admin. Given that I should at least see the properties in order to add or change permissions, however, I dont. Everything lines up in report server configuration. The only ones not green are the keyfile (optional) and initialization (not a developers edition)

So, what gives?
|||

I would really appreciate if anyone could provide the solutions for this problem.

I'm running SQL Server 2005 and reporting service in a computer with Vista Business.

I've already tried every single method that I could find find on the internet included disabling anonymous login for both Reports and ReportServer in IIS manager. However, I still can only see HOME, MY SUBSCRIPTIONS and HELP link on the header only. The rest is all blank below.

ps: I'm able to connect to Reporting Service Configuration with green checkmarks on those necessary components without any error.

Please help..

|||

First, you willl need to do the steps that I listed previously in this forum thread.

If you login locally, you will also need to add both the report server and report manager URLs to Trusted Sites if you are using IE.

Let me know if this solves your problem.

-Lukasz

Report Links in Page Header

I have a report that I put links to other reports in the page header.

When I click on those links, I get the error:

"source of the report definition has not been specified"

If I move the links to the body of the report, they work fine.

Is this a bug or a limitation, and will we eventually be able to put links in the header?

Thanks!

BobP

Drillthrough links in page header/footer are not supported in RS2005. We plan to get it fixed in the next release.

Report Jump in Page Header

I tried to add a report jump to a page header - visual studio mentions that this is not supported by all renders, but I did not find any information which renderers support this. It seems the default html renderer does not support it, because i receive the following error
"The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)"
while I only specify the report name.

Is there a way to add a report jump to the page header ? with parameters ?
I have an startpage with links to each report - and in the header of the reports a want to support a back to the table of content link. Is there a othere way so switch back to the origninal report (after some parameter switches) ?

Thanks
HANNES

As indicated by the publishing warning message in report designer preview, drillthrough actions are currently not supported in page headers/footers in RS 2005.

The closest you can get for the page header/footer is to use a hyperlink action and build a url that points back to the report server and uses URL access to run a report with certain parameter settings. The Globals collection in the report object model exposes properties such as ReportServerUrl that you will need to build the URL - see also: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_7ilv.asp

-- Robert

Report item only found in the first page of the report Header

I have a textbox in a Page Header which refers to a ReportItem found in the
body of the report, Im using a not visible textbox in the body.
The first page its ok, but after it doesnt appear any data about values un
the report header textboxes
Could you help me please with specific information about how fix this problem?
Thanks in advance!
--
.So you have a textbox header that wont repeat on pages after the first
and you want it to repeat on subsequent pages? Is that correct? Each
textbox item has an option to repeat based on another textbox (or I
think Table Item) in the report.. Basically select the textbox header -
right click and select properties - then select the advanced button in
the lower left corner of the Properties dialog - on the General tab
their should be a "Repeat report item.." option (selected by default)
beneath this option is a drop-down to select the data region. Just
select the Data Region you wish the header to repeat on and you should
be fine.|||So you have a textbox header that wont repeat on pages after the first
and you want it to repeat on subsequent pages? Is that correct? Each
textbox item has an option to repeat based on another textbox (or I
think Table Item) in the report.. Basically select the textbox header -
right click and select properties - then select the advanced button in
the lower left corner of the Properties dialog - on the General tab
their should be a "Repeat report item.." option (selected by default)
beneath this option is a drop-down to select the data region. Just
select the Data Region you wish the header to repeat on and you should
be fine.|||ok, let me explain it better.
I have a dataset value form a textbox1 in BODY, and I make
=reportitem!textbox1.value put it in a Textbox in HEADER, with this, is
possible that data value can be see it in header.
At the first page , you can see tha value at the HEADER, but after this
number one page, it doesnt see the values anymore
Question. How can I do, for this values can appears in all the HEADER in
each page?
P.D. What data regions can I select?, it doesnt appear any data.
"papaboom" wrote:
> So you have a textbox header that wont repeat on pages after the first
> and you want it to repeat on subsequent pages? Is that correct? Each
> textbox item has an option to repeat based on another textbox (or I
> think Table Item) in the report.. Basically select the textbox header -
> right click and select properties - then select the advanced button in
> the lower left corner of the Properties dialog - on the General tab
> their should be a "Repeat report item.." option (selected by default)
> beneath this option is a drop-down to select the data region. Just
> select the Data Region you wish the header to repeat on and you should
> be fine.
>|||This worked for me...
From a post by Lev Semenets [MSFT]
Here is some info about adding parameters :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_38du.asp
You need to create a parameter with no prompt (If the prompt is left blank,
and a default parameter value is specified, the default value is used, and
the input box for the parameter is not displayed when the user runs the
report), set default value to "From query" and select dataset and field for
default value.
"mario_quijada" wrote:
> I have a textbox in a Page Header which refers to a ReportItem found in the
> body of the report, Im using a not visible textbox in the body.
> The first page its ok, but after it doesnt appear any data about values un
> the report header textboxes
> Could you help me please with specific information about how fix this problem?
> Thanks in advance!
> --
> .

Report Headers vs Page Headers?

Is there such a thing as a Report Header, which only shows up at the
beginning of the report?
This is in contrast to a Page Header which shows up at the top of each page.
Thanks,
Daniel WilliamsYes, there is a report header. Type the text you want to be in the header in
the Body section before your data region. Similarly, you can type report
footer text below the data region.
Charles Kangai, MCT, MCDBA
"Daniel Williams" wrote:
>
> Is there such a thing as a Report Header, which only shows up at the
> beginning of the report?
> This is in contrast to a Page Header which shows up at the top of each page.
> Thanks,
> Daniel Williams
>
>

Report Headers & Footers

I see the Page Header and Page footer, but what about Report Header and Report Footers? Doesn't look like ssrs has this ability, am I wrong?

I was able to accomplish what I want by following the suggestion in this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377566&SiteID=1

IMO, this is lame. Come on, even Access has a Report Header & Report Footer, what were they thinking? Seems like to get simple stuff done in ssrs you have to basically find hacks and workarounds. Not impressed.

|||

Hello,

Would the table header/footer work for you?

Jarret

|||

Yes, I ended having to use the table header/footer like it is described in the link in my previous post. I still think this is kind of a hack and am wondering why ReportHeader & ReportFooter were left out.

|||

The link in your previous post takes me to another post by you for Parameter Validation Failed. Oh well, glad you got it working.

Maybe I am missing something, but I can't think of any reason why they wouldn't be considered synonymous. Can you give me an example of something a report header can do that a table header can't (or vice versa), just for my knowledge?

Jarret

|||Sorry about that! I have fixed the link to point to the correct article, thanks for pointing that out.

report header: how do i have underline

im using tablerow for header of my report and i want to have underline for the labels. how do i do that?

thanks

change the TextDecoration property to Underline.

Mark

Report Header woes

I am creating a report which consists of data in two columns. I've set the Body section to have 2 columns in it. This works fine until I start working with the report header. I do not want a page header that shows up on every page, I only want a header on the first page, a report header.

I first tried to hide the header by placing it in the Page Header section, then putting in the "page > 1" expression in the visibility property. This does what I want, except a large blank space is present at the top of my report (the header is about 1.2 "). This is unacceptable.

So my next test was to put the header into the Body section so that it only shows up in the beginning of the report. Because of this, I will need to remove the columns from the Body and make it only 1 column now. I decided to put the multi-column section into a subreport that has 2 columns and add this to the body of my report. But, this failed; the data appears in one column only. I can change the width the ensure it fits and set all other sorts of properties, nothing works.

I've researched both issues and found that these are both "bugs" in reporting services, although I cannot find thedocumented bugs.

Is there any workaround to putting a header onto only the first page of a multi-column report? Other reporting engines are able to handle this with ease, I'm suprised by Reporting Services lack of a "Report Header" section. I am an experienced .NET developer, so if there is a programmatic way through this, I am game.

Thanks,

Scott Steigerwald

I realize this thread is over a year and a half old. The point of this reply is to bring the issue back among the recent posts; a "bump" as it were.

I am struggling with a near identical problem, and have already tried all the workarounds proposed by Mr. Steigerwald, to no avail.

I hope that after 20 or so months, some solution has been discovered.

Thanks,

David Emigh

|||I am pretty confident there is still no solution to this.
I actually faked a multi column report by manipulating the dataset I was pulling across, but this was a failry specific situation where I knew approximately how many rows were always being returned.|||

Thanks.

Sadly, I rather suspected this. At least I know now to look for a solution outside of SQL Reporting Services.

|||

Um, folks... hold on a sec .

I saw the re-post on this question and I think I have succeeded in doing what you want. (Sorry I didn't get around to posting this last night.)

It's a little hacky and it probably won't work for *every* situation, but I did get the basic parameters down:

* -- I've got a Body section with two columns

* -- I have a header that appears to stretch over both areas

* -- it "collapses" after the first page.

Here is what I did:

I couldn't get it to work as a Page header, for reasons you've already discussed. So, instead, I worked out how you could have a Body header that disappeared properly and stretched across.

The first step is to figure out where to put it. In my example, and I am not sure how many other ways there might be to do it, it's a group header and I page breaked on group. I don't think this is relevant, but whatever your data region you need a body element that will be placed at the top of every column.

The background of this page header element should be transparent, because we're going to change its contents for the second column (or more, if it's > 2 cols) and we want it to look as seamless -across as possible.

For the same reason (making the header look seamless-across), you probably want to set the colum spacing as low as possible (you can add some extra padding on the right side by adding an extra blank column, and merge the layout element across, to compensate).

Note that, just as we'll make the contents different for each col, text alignment can be an expression, so using what I"m doing here you could (say) have the left col header left aligned and the right col header right aligned.

I set the expression for this header element to =Code.MyUDF().

You can see my code below. Notice that the ColNo var is incremented each time, so I can use it both for "which column am I in" and "which page am I on".

The tricky part was just figuring out when the Visibility of the element would be evaluated with respect to this function being invoked -- so that I could set the visibility properly. With how I'm doing it here, the visibility expression has to be =Code.ColNo > 1 (one less than you might think, IOW).

The visibility expression would be a little different if I invoked one function to increment earlier, say in an earlier no-height line, and a second function to figure out the expressions to show, but this combined design works okay as well.

I also set the CanShrink property of this element to True to and I set the Visibility of the row to the same expression as the layout element.

Here's the code I used:

Code Snippet

Public ColNo AS Integer = 0

Function MyUDF AS String
Dim myheadpart As String
ColNo = ColNo + 1
If ColNo = 1
myheadpart= "1st part of header"
ElseIf ColNo = 2
myheadpart= "2nd part"
Else
myheadpart = ""
End If
Return myheadpart
End Function

... HTH,

>L<

|||

Thank you!

I've bookmarked this thread for future reference, as this situation will almost certainly come up again.

Unfortunately, in my particular situation, it doesn't seem applicable. I have a requirement to include an image that is wider than the the sum of the widths of the first column and the space between it and the second. The image has a minimum size and a non-negotiable aspect ratio.

I wasn't the thread starter on this one, but if I were, I would mark this as "answered"

Thanks again,

David

|||

Hi David

I see what you mean about the image -- I know this whole idea is a bit dodgy but there might be some way to split the image up into two? First make a "full image" the full width of the page, I mean with a lot of filler-empty space on the right (or on both sides, if you're trying to center it horizontally on the page), and then split it down the middle for column one and column two. No guarantees that it will work, of course, but worth a shot?

>> I would mark it

Well, I can mark it as a moderator but I won't <g>. I won't do that with my own answers unless they prove out (actually help somebody) <g>.

>L<

|||

Maybe I am misundertanding things but generally when I want a first page only header I create a second dataset that returns a single record by using a statment like "select x=1". Then I just use a table set to the dummy header at the top of my body section. A typical example where I would use it is for invoices.

|||

Lisa,

Perhaps another moderator will come along and do the deed which modesty prevents you doing yourself

My manager has decided on a different approach to this problem, one which precludes any image editing, but I will keep that in mind also.

David

|||

Hi there,

Yeah, a first page header *alone* is not the problem here. (There are lots of ways to do that -- for example you can group on something that will never break as an outer group...)

The problem we're trying to solve here is the multi-column report and getting the page header to stretch across those columns without using a page header...

>L<

|||

Hi David,

If you don't mind my asking... what did you and your manager settle on? (It's always good to be able to remove the requirement if the requirement is a PITA <rofl>)

>L<

|||

Hey Lisa,

The requirement didn't go away, we just opted to generate the report header and report body separately, then merge them later (probably as an active .pdf via a web app).

|||

Ah.

Well, good to know. (I have posted about combining files in a PDF a couple of times, and recently found a nice utility for this to complement my usual low-level ghostcript PDF approach... give a shout if you have a difficulties.

FWIW there are many reasons to do this that have nothing to do with your current problem, for example different orientation of a cover page. Repeat after me: a report is a document section, not a document. Extended essay on this subject here: http://spacefold.com/lisa/post/Reporting-Convergences-Chapter-The-one-about-multiple-sets-of-printing-instructions.aspx.

>L<

Report Header woes

I am creating a report which consists of data in two columns. I've set the Body section to have 2 columns in it. This works fine until I start working with the report header. I do not want a page header that shows up on every page, I only want a header on the first page, a report header.

I first tried to hide the header by placing it in the Page Header section, then putting in the "page > 1" expression in the visibility property. This does what I want, except a large blank space is present at the top of my report (the header is about 1.2 "). This is unacceptable.

So my next test was to put the header into the Body section so that it only shows up in the beginning of the report. Because of this, I will need to remove the columns from the Body and make it only 1 column now. I decided to put the multi-column section into a subreport that has 2 columns and add this to the body of my report. But, this failed; the data appears in one column only. I can change the width the ensure it fits and set all other sorts of properties, nothing works.

I've researched both issues and found that these are both "bugs" in reporting services, although I cannot find thedocumented bugs.

Is there any workaround to putting a header onto only the first page of a multi-column report? Other reporting engines are able to handle this with ease, I'm suprised by Reporting Services lack of a "Report Header" section. I am an experienced .NET developer, so if there is a programmatic way through this, I am game.

Thanks,

Scott Steigerwald

I realize this thread is over a year and a half old. The point of this reply is to bring the issue back among the recent posts; a "bump" as it were.

I am struggling with a near identical problem, and have already tried all the workarounds proposed by Mr. Steigerwald, to no avail.

I hope that after 20 or so months, some solution has been discovered.

Thanks,

David Emigh

|||I am pretty confident there is still no solution to this.
I actually faked a multi column report by manipulating the dataset I was pulling across, but this was a failry specific situation where I knew approximately how many rows were always being returned.
|||

Thanks.

Sadly, I rather suspected this. At least I know now to look for a solution outside of SQL Reporting Services.

|||

Um, folks... hold on a sec .

I saw the re-post on this question and I think I have succeeded in doing what you want. (Sorry I didn't get around to posting this last night.)

It's a little hacky and it probably won't work for *every* situation, but I did get the basic parameters down:

* -- I've got a Body section with two columns

* -- I have a header that appears to stretch over both areas

* -- it "collapses" after the first page.

Here is what I did:

I couldn't get it to work as a Page header, for reasons you've already discussed. So, instead, I worked out how you could have a Body header that disappeared properly and stretched across.

The first step is to figure out where to put it. In my example, and I am not sure how many other ways there might be to do it, it's a group header and I page breaked on group. I don't think this is relevant, but whatever your data region you need a body element that will be placed at the top of every column.

The background of this page header element should be transparent, because we're going to change its contents for the second column (or more, if it's > 2 cols) and we want it to look as seamless -across as possible.

For the same reason (making the header look seamless-across), you probably want to set the colum spacing as low as possible (you can add some extra padding on the right side by adding an extra blank column, and merge the layout element across, to compensate).

Note that, just as we'll make the contents different for each col, text alignment can be an expression, so using what I"m doing here you could (say) have the left col header left aligned and the right col header right aligned.

I set the expression for this header element to =Code.MyUDF().

You can see my code below. Notice that the ColNo var is incremented each time, so I can use it both for "which column am I in" and "which page am I on".

The tricky part was just figuring out when the Visibility of the element would be evaluated with respect to this function being invoked -- so that I could set the visibility properly. With how I'm doing it here, the visibility expression has to be =Code.ColNo > 1 (one less than you might think, IOW).

The visibility expression would be a little different if I invoked one function to increment earlier, say in an earlier no-height line, and a second function to figure out the expressions to show, but this combined design works okay as well.

I also set the CanShrink property of this element to True to and I set the Visibility of the row to the same expression as the layout element.

Here's the code I used:

Code Snippet

Public ColNo AS Integer = 0

Function MyUDF AS String
Dim myheadpart As String
ColNo = ColNo + 1
If ColNo = 1
myheadpart= "1st part of header"
ElseIf ColNo = 2
myheadpart= "2nd part"
Else
myheadpart = ""
End If
Return myheadpart
End Function

... HTH,

>L<

|||

Thank you!

I've bookmarked this thread for future reference, as this situation will almost certainly come up again.

Unfortunately, in my particular situation, it doesn't seem applicable. I have a requirement to include an image that is wider than the the sum of the widths of the first column and the space between it and the second. The image has a minimum size and a non-negotiable aspect ratio.

I wasn't the thread starter on this one, but if I were, I would mark this as "answered"

Thanks again,

David

|||

Hi David

I see what you mean about the image -- I know this whole idea is a bit dodgy but there might be some way to split the image up into two? First make a "full image" the full width of the page, I mean with a lot of filler-empty space on the right (or on both sides, if you're trying to center it horizontally on the page), and then split it down the middle for column one and column two. No guarantees that it will work, of course, but worth a shot?

>> I would mark it

Well, I can mark it as a moderator but I won't <g>. I won't do that with my own answers unless they prove out (actually help somebody) <g>.

>L<

|||

Maybe I am misundertanding things but generally when I want a first page only header I create a second dataset that returns a single record by using a statment like "select x=1". Then I just use a table set to the dummy header at the top of my body section. A typical example where I would use it is for invoices.

|||

Lisa,

Perhaps another moderator will come along and do the deed which modesty prevents you doing yourself

My manager has decided on a different approach to this problem, one which precludes any image editing, but I will keep that in mind also.

David

|||

Hi there,

Yeah, a first page header *alone* is not the problem here. (There are lots of ways to do that -- for example you can group on something that will never break as an outer group...)

The problem we're trying to solve here is the multi-column report and getting the page header to stretch across those columns without using a page header...

>L<

|||

Hi David,

If you don't mind my asking... what did you and your manager settle on? (It's always good to be able to remove the requirement if the requirement is a PITA <rofl>)

>L<

|||

Hey Lisa,

The requirement didn't go away, we just opted to generate the report header and report body separately, then merge them later (probably as an active .pdf via a web app).

|||

Ah.

Well, good to know. (I have posted about combining files in a PDF a couple of times, and recently found a nice utility for this to complement my usual low-level ghostcript PDF approach... give a shout if you have a difficulties.

FWIW there are many reasons to do this that have nothing to do with your current problem, for example different orientation of a cover page. Repeat after me: a report is a document section, not a document. Extended essay on this subject here: http://spacefold.com/lisa/post/Reporting-Convergences-Chapter-The-one-about-multiple-sets-of-printing-instructions.aspx.

>L<

Report Header woes

I am creating a report which consists of data in two columns. I've set the Body section to have 2 columns in it. This works fine until I start working with the report header. I do not want a page header that shows up on every page, I only want a header on the first page, a report header.

I first tried to hide the header by placing it in the Page Header section, then putting in the "page > 1" expression in the visibility property. This does what I want, except a large blank space is present at the top of my report (the header is about 1.2 "). This is unacceptable.

So my next test was to put the header into the Body section so that it only shows up in the beginning of the report. Because of this, I will need to remove the columns from the Body and make it only 1 column now. I decided to put the multi-column section into a subreport that has 2 columns and add this to the body of my report. But, this failed; the data appears in one column only. I can change the width the ensure it fits and set all other sorts of properties, nothing works.

I've researched both issues and found that these are both "bugs" in reporting services, although I cannot find thedocumented bugs.

Is there any workaround to putting a header onto only the first page of a multi-column report? Other reporting engines are able to handle this with ease, I'm suprised by Reporting Services lack of a "Report Header" section. I am an experienced .NET developer, so if there is a programmatic way through this, I am game.

Thanks,

Scott Steigerwald

I realize this thread is over a year and a half old. The point of this reply is to bring the issue back among the recent posts; a "bump" as it were.

I am struggling with a near identical problem, and have already tried all the workarounds proposed by Mr. Steigerwald, to no avail.

I hope that after 20 or so months, some solution has been discovered.

Thanks,

David Emigh

|||I am pretty confident there is still no solution to this.
I actually faked a multi column report by manipulating the dataset I was pulling across, but this was a failry specific situation where I knew approximately how many rows were always being returned.
|||

Thanks.

Sadly, I rather suspected this. At least I know now to look for a solution outside of SQL Reporting Services.

|||

Um, folks... hold on a sec .

I saw the re-post on this question and I think I have succeeded in doing what you want. (Sorry I didn't get around to posting this last night.)

It's a little hacky and it probably won't work for *every* situation, but I did get the basic parameters down:

* -- I've got a Body section with two columns

* -- I have a header that appears to stretch over both areas

* -- it "collapses" after the first page.

Here is what I did:

I couldn't get it to work as a Page header, for reasons you've already discussed. So, instead, I worked out how you could have a Body header that disappeared properly and stretched across.

The first step is to figure out where to put it. In my example, and I am not sure how many other ways there might be to do it, it's a group header and I page breaked on group. I don't think this is relevant, but whatever your data region you need a body element that will be placed at the top of every column.

The background of this page header element should be transparent, because we're going to change its contents for the second column (or more, if it's > 2 cols) and we want it to look as seamless -across as possible.

For the same reason (making the header look seamless-across), you probably want to set the colum spacing as low as possible (you can add some extra padding on the right side by adding an extra blank column, and merge the layout element across, to compensate).

Note that, just as we'll make the contents different for each col, text alignment can be an expression, so using what I"m doing here you could (say) have the left col header left aligned and the right col header right aligned.

I set the expression for this header element to =Code.MyUDF().

You can see my code below. Notice that the ColNo var is incremented each time, so I can use it both for "which column am I in" and "which page am I on".

The tricky part was just figuring out when the Visibility of the element would be evaluated with respect to this function being invoked -- so that I could set the visibility properly. With how I'm doing it here, the visibility expression has to be =Code.ColNo > 1 (one less than you might think, IOW).

The visibility expression would be a little different if I invoked one function to increment earlier, say in an earlier no-height line, and a second function to figure out the expressions to show, but this combined design works okay as well.

I also set the CanShrink property of this element to True to and I set the Visibility of the row to the same expression as the layout element.

Here's the code I used:

Code Snippet

Public ColNo AS Integer = 0

Function MyUDF AS String
Dim myheadpart As String
ColNo = ColNo + 1
If ColNo = 1
myheadpart= "1st part of header"
ElseIf ColNo = 2
myheadpart= "2nd part"
Else
myheadpart = ""
End If
Return myheadpart
End Function

... HTH,

>L<

|||

Thank you!

I've bookmarked this thread for future reference, as this situation will almost certainly come up again.

Unfortunately, in my particular situation, it doesn't seem applicable. I have a requirement to include an image that is wider than the the sum of the widths of the first column and the space between it and the second. The image has a minimum size and a non-negotiable aspect ratio.

I wasn't the thread starter on this one, but if I were, I would mark this as "answered"

Thanks again,

David

|||

Hi David

I see what you mean about the image -- I know this whole idea is a bit dodgy but there might be some way to split the image up into two? First make a "full image" the full width of the page, I mean with a lot of filler-empty space on the right (or on both sides, if you're trying to center it horizontally on the page), and then split it down the middle for column one and column two. No guarantees that it will work, of course, but worth a shot?

>> I would mark it

Well, I can mark it as a moderator but I won't <g>. I won't do that with my own answers unless they prove out (actually help somebody) <g>.

>L<

|||

Maybe I am misundertanding things but generally when I want a first page only header I create a second dataset that returns a single record by using a statment like "select x=1". Then I just use a table set to the dummy header at the top of my body section. A typical example where I would use it is for invoices.

|||

Lisa,

Perhaps another moderator will come along and do the deed which modesty prevents you doing yourself

My manager has decided on a different approach to this problem, one which precludes any image editing, but I will keep that in mind also.

David

|||

Hi there,

Yeah, a first page header *alone* is not the problem here. (There are lots of ways to do that -- for example you can group on something that will never break as an outer group...)

The problem we're trying to solve here is the multi-column report and getting the page header to stretch across those columns without using a page header...

>L<

|||

Hi David,

If you don't mind my asking... what did you and your manager settle on? (It's always good to be able to remove the requirement if the requirement is a PITA <rofl>)

>L<

|||

Hey Lisa,

The requirement didn't go away, we just opted to generate the report header and report body separately, then merge them later (probably as an active .pdf via a web app).

|||

Ah.

Well, good to know. (I have posted about combining files in a PDF a couple of times, and recently found a nice utility for this to complement my usual low-level ghostcript PDF approach... give a shout if you have a difficulties.

FWIW there are many reasons to do this that have nothing to do with your current problem, for example different orientation of a cover page. Repeat after me: a report is a document section, not a document. Extended essay on this subject here: http://spacefold.com/lisa/post/Reporting-Convergences-Chapter-The-one-about-multiple-sets-of-printing-instructions.aspx.

>L<

Report header when using columns

Hi,
I am designing a report with two columns, and I'm trying to add a header
only on the first page of the report. I've added a text box in the body of
the report, but my problem is that this textbox can't be larger than the
column size.
Is there any way to put this header on the whole width of the report ?
Thanks in advance.
--
Florent MERYHi,
No need to add text boxes. Just follow the below steps
Right click on the table-> select properties->General Tab-> Uncheck the
"Repeat header row on each page"..
Regards,
Sriman.
"Florent" wrote:
> Hi,
> I am designing a report with two columns, and I'm trying to add a header
> only on the first page of the report. I've added a text box in the body of
> the report, but my problem is that this textbox can't be larger than the
> column size.
> Is there any way to put this header on the whole width of the report ?
> Thanks in advance.
> --
> Florent MERY|||Thank you for your answer, but it's not exactly what I'm trying to do. As I'm
using 2 columns in my report, the table headers will only appear on the top
of the first column.
What I would like to do is to have in fact a kind of title zone for my
report, only for the first page.
If I use the Page header, with a conditional visibility, I always get a
blanck zone at the top of every page, even when the header is not visible.
And if I use the table header rows, it only appear on the first column of
the page, and it does not use the whole width of the page.
Any workaround for my problem ?
Thanks in advance...
--
Florent MERY
"Sriman" wrote:
> Hi,
> No need to add text boxes. Just follow the below steps
> Right click on the table-> select properties->General Tab-> Uncheck the
> "Repeat header row on each page"..
> Regards,
> Sriman.
> "Florent" wrote:
> > Hi,
> >
> > I am designing a report with two columns, and I'm trying to add a header
> > only on the first page of the report. I've added a text box in the body of
> > the report, but my problem is that this textbox can't be larger than the
> > column size.
> >
> > Is there any way to put this header on the whole width of the report ?
> >
> > Thanks in advance.
> >
> > --
> > Florent MERY

Report header only on first page

Hi
I wish to have a report with a header only on the first page. Normally the
header is repeated on every page. Is there a way to get it only on the first
page?
Thanks for any help!It sounds like you have used a page header rather than a report header in
your report. A report header automatically does what you are wanting to do.
To create a report header, just place a textbox above your data region and
type in the text for your header. It will automatically appear only on the
first page.
Page headers naturally print on every page. However these have a property
called PrintOnFirstPage/PrintOnLastPage which controls printing on first/last
page.
HTH
Charles Kangai, MCT, MCDBA
"M. Peyer" wrote:
> Hi
> I wish to have a report with a header only on the first page. Normally the
> header is repeated on every page. Is there a way to get it only on the first
> page?
> Thanks for any help!|||Thanks Charles for your valuable reply.
but more specific to the same problem, I need Report Header (only once) to
appear before the Page Header. But as per the solution provided by you, it
will appear at the top of the "Body" section.
Can I make Report header to appear at the top of the Page Header.
Thanks & Regards
Rohit
"Charles Kangai" wrote:
> It sounds like you have used a page header rather than a report header in
> your report. A report header automatically does what you are wanting to do.
> To create a report header, just place a textbox above your data region and
> type in the text for your header. It will automatically appear only on the
> first page.
> Page headers naturally print on every page. However these have a property
> called PrintOnFirstPage/PrintOnLastPage which controls printing on first/last
> page.
> HTH
> Charles Kangai, MCT, MCDBA
> "M. Peyer" wrote:
> > Hi
> > I wish to have a report with a header only on the first page. Normally the
> > header is repeated on every page. Is there a way to get it only on the first
> > page?
> > Thanks for any help!