how to fix report layout problems

When you use Report designer in the BI development studio, on the Preview tab, you can have a straight preview or a print layout preview. I suppose what you see in the print layout preview is what you get when you print the report or export the report to the other format.

However, often you see everything looks perfect in a straight preview but does look right in the print layout preview. For example, you might get the following problems in the print layout preview, even if everything looks perfect in a straight preview.

· Every even page is a blank page

· Items that should be together on the same page are separated into different pages. For example, on the first page, I had a TextBox1 followed by Image1 then followed by TextBox2. Both textboxes have constant (static) values, and Image1 holds a jpg image. Strangely enough, when I do print layout preview, I saw both textboxes and blank space in-between on the first page, and then saw the image on the second page. No matter how I adjust and what I adjust (position, size, bring to front, send to back, ... etc), I just could not get them into the same page, and I have no clue why.

Can anyone provide some suggestions, advices, experience, knowledge, or pointers?

Where and what elements should I look into to fix the layout problems stated above?

Thanks in advance.

Chris in Toronto

Hi There,

It's probably a problem with page width. Your report is too wide to fit on a single page, and so the right hand edge will be carved off into a new page, hene every other page is blank or your data is split across pages.

The report should be something like 21cm by 29.7cm (sorry, I can't remember the inch equivalents). And the body should be about 18cm wide. (at least these measurements certainly fit on a sheet of A4 in one of my reports).

Cheers - Andrew.
|||

I have already considered the page width.

No matter how I adjust the page width, it does not fix the two problems that I described.

Thanks anyway.

|||

When you looked at the page width vs. body width, did you consider the size of the margins? This blog article might help:

http://blogs.msdn.com/chrisbal/archive/2006/08/10/694892.aspx

This situation is the only one I'm aware of that will reliably cause every other page to be blank in physical page layout renderers.

-Chris

How to find table name by Table ID

waitresource
--
TAB: 12:600441263 []
I had blocking issue. I query sysproceses table and it shows me process are
waiting for "waitresource=TAB: 12:600441263 []"
TAB table
12 -- it is DB id...it is not problem to find dbname...sysdatabases
600441263 - table ID
How to find table name from Table ID '
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1Switch to the proper DB and do:
SELECT OBJECT_NAME(600441263 )
RLF
"jkostic via SQLMonster.com" <u11642@.uwe> wrote in message
news:64cf78c5f56a6@.uwe...
> waitresource
> --
> TAB: 12:600441263 []
> I had blocking issue. I query sysproceses table and it shows me process
> are
> waiting for "waitresource=TAB: 12:600441263 []"
> TAB table
> 12 -- it is DB id...it is not problem to find dbname...sysdatabases
> 600441263 - table ID
> How to find table name from Table ID '
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1
>|||OBJECT_NAME() function will give you the table/any object name when you pass
the id.
in your case
Select OBJECT_NAME(600441263 )
will give you the table name.
There are otherways to do it.
Here is one more by using the system table
select name from sysobjects where id = 600441263
you have to run this comments on the particular database i.e the database id
12 you mentioned.
regards,
Saravanan
"jkostic via SQLMonster.com" <u11642@.uwe> wrote in message
news:64cf78c5f56a6@.uwe...
> waitresource
> --
> TAB: 12:600441263 []
> I had blocking issue. I query sysproceses table and it shows me process
> are
> waiting for "waitresource=TAB: 12:600441263 []"
> TAB table
> 12 -- it is DB id...it is not problem to find dbname...sysdatabases
> 600441263 - table ID
> How to find table name from Table ID '
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1
>

How to filter a table with an "OR" condition

I'd like to set the Filters in the Filters tab of the Table Properties dialog to say:

=Fields!WT_TO.Value > 0 OR

=Fields!WT_TO_PREV.Value > 0

but teh And/Or column is permanently disabled, and its sticking in a default value of AND

what's up with that?

Hello,

I don't think there is a way to change the AND/OR, and the only way to get an OR is to have the exact same expression in your filter.

Try this instead:

Expression: =Fields!WT_TO.Value > 0 or Fields!WT_TO_PREV.Value > 0

Operator: =

Value: =True

Hope this helps.

Jarret

|||your technique works great - i'm surprised they bother with the multiple filters and the and/or column since you can't really use it and all you really need is a single expression. Anyway, thanks!|||

"I don't think there is a way to change the AND/OR, and the only way to get an OR is to have the exact same expression in your filter."

What about changing it directly in the XML? Is that a possibility?

The need for OR is obvious.

Maybe there's a similar solution for my situation--but the OR option is really it.

I need to be able to show some subset of the list of states (from the US) based on the selection from a multivalue parameter, "OR" the TOTALS row.

Suggestions?
|||I figured this out myself, thank you.

OR is only used if the Operator for the filter is an equal (=) sign. Otherwise, it's AND.

They assume that programmers/developers are retards and can't figure out the logic for themselves.

God forbid that I should have multiple, dynamic options to compare--at the same time that a static value is also a possibility.
|||OMG that sucks. still, lotta good stuff is SSRS