layout problem

Hi,
I have 4 subreports in a report and adjust thier position well on layout
tag.
Preview on the report designer everything is fine.
But deploy to report server and browse on IE the subreports all on the wrong
position!
How can I resolve this problem?
Thanks for help!
AngiI had the same problem with some of my reports I found out the only way
ot get the layout right is to enter the location for each item on the
report in the location property and " measure/space" so nothing is over
laping. One can begin where one ends but if they overlap the location
it will be moved to onther page. It still looks a little funny on the
browser but it prints perfectly.sql

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comIf you click on the header in the designer and then look at the properties
there is a property that is PrintOnFirstPage. This defaults to True, I think
if you set this to False the report will behave the way you want.
Stuart
"roy mm" wrote:
> Layout problem -
> I've created a report with the wizard and it looks fine.
> It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
> Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
> I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
> Can anybody help me with the title part to make it visible in all pages?
> Thank alot in advance,
> Roy.
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.

Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.

I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.

Can anybody help me with the title part to make it visible in all pages?

Thank alot in advance,
Roy.Are you using a true page header or just a couple of test fields at the top of the page. Click the Report menu and see if you have a Page Header selected.

layout problem

hi all,

i got a table which shows me the number of transfers of a store on everyday day together with the summed amount the store gained. my table looks like this:

store day transfers amount

1 1 1 2.50

1 2 5 3.50

2 1 2 1

and i want to put it in a report like this

store monday tuesday

1 1 / 2.50 5 / 3.50

2 2 / 1

i tried with a matrix but the the result wasnt satisifiying. the best one looked like this:

store monday tuesday

1 1 / 2.50

1 5 / 3.50

2 2 / 1

anyone can give a solution or atleast some hints?

drop store to the row group and day to the column group should satisfy your need.

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.

Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.

I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.

Can anybody help me with the title part to make it visible in all pages?

Thank alot in advance,
Roy.

Firstly, there is no way to specify that an item should appear on all pages.

However, you do have a few options:

Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.

I wrote to myself your comment about the display in the exporting! Its importent.

Thank,
Roy.|||

A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.

If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.

So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.

The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.

Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.

|||

Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.

Nadeem

Layout problem

Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.

Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.

I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.

Can anybody help me with the title part to make it visible in all pages?

Thank alot in advance,
Roy.

Firstly, there is no way to specify that an item should appear on all pages.

However, you do have a few options:

Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.

I wrote to myself your comment about the display in the exporting! Its importent.

Thank,
Roy.|||

A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.

If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.

So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.

The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.

Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.

|||

Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.

Nadeem

sql

Layout of report parameters

Hi all

Is there any way to change the way the report parameters are displayed?

Presently they are just in a tabular format. I am after displaying them as follows:

- - -

__

- -

The horizontal line is there to group the parameters. Is that possible?

Thanks heaps
This is not natively supported. You would need to construct your own prompting area.