Help Backup: page

Showing posts with label page. Show all posts

Friday, March 30, 2012

Hide Pagefooter

Hi All,
I would like to show pagefooter on first page only. I tried with
Visibility -> Hidden = IIF(Globals!PageNumber=1,False,True)
It succesfully hide but showing space on other pages.
Please suggest any solution.
Kind Regards
ZahidWhen the report is rendered at run-time it will always display the
space allocated for the page footer, even if you set the Hidden
property to True.
zahid76@.gmail.com wrote:
> Hi All,
> I would like to show pagefooter on first page only. I tried with
> Visibility -> Hidden = IIF(Globals!PageNumber=1,False,True)
> It succesfully hide but showing space on other pages.
> Please suggest any solution.
> Kind Regards
> Zahid

hide my report toolbar

Hi.

i would like to configure my reports to hide the Toolbar. I'm not using any aspx page to contain my report, I'm just opening it from the server with IE.

is there a way to configure the report thet he does't have any tool bar?

Thanks,

Roy.

Look in the BOL for ULR parametrization, the rc:Toolbar=no should do the job.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de
|||

Thanks :)

i don't know what is "BOL for ULR ".

but the code was good (i used rc:toolbar=false).

thanks!

|||Just to add, BOL means Books Online which is actually the help of SQL Server. look for the URL access there.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Monday, March 26, 2012

Hidden Rectangle causing blank page.

Hello all,

I'm running into an issue with a report we have, I was hoping you may be able to help...

We have a report that contains a rectangle which has conditional visiblity. When the expression evaluates to true, the contents of the rectangle are indeed "hidden", but we are seeing a blank page.

The rectangle does NOT have page breaks selected before or after it. (and neither does the objects before or after that rectangle.)

Any ideas?

Is this when you are viewing or printing?

Make sure that the hidden rectangle is somewhere within the page bounds of your report (and include margins in your calculations). Just a guess, but give it a try.

Mike

Friday, March 23, 2012

Hidden items, whitespace

Hi,

i have an issue with hidden items causing whitespace on the output of a report. The last page of the report contains a table, which may be hidden if certain conditions are met. However the final page is still rendered even though it contains nothing. The page does have a header and footer, but the page is still rendered if i also conditionally hide all the elements in the header or footer.

Ideally i would like the last page to not be rendered if that table is hidden. Is there any way to achieve this?

Thanks,

sluggy

Do you have a pagebreak before the table? If you hide the contents of the table, you would still get the last (blank) page. But if you hide the table (by setting table visibility property), you shouldn't get the page.

Hidden Items Still Taking Space on The Page

Hi everyone,
I have a report where I have a rectangle witha bunch of lists and
textboxes on it which I hide on a certain case. The problem is, its
still taking space on the report page when the report is generated. It
doesn't appear, but I get a big empty space...
Is there any way to let the other items move up a little bit so I don't
have a big gap on my report?
Note: I can't add it to another table since I have lists on the
rectangle...
Thank you,Anyone has any ideas about how to accomplish this by any chance? I am
pretty stuckk...|||Can you try turning "Can Shrink" to true so that when there is no data that
it will shrink to a smaller size and let everything else move up?
"Spartacus" wrote:
> Anyone has any ideas about how to accomplish this by any chance? I am
> pretty stuckk...
>|||If it possible on Image or Rectangle?
Image and Rectangle doesn't have CanShrink.
Any idea?
Thanks!
Angi
"KimB" <KimB@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:7DB5C4A0-0C88-4CE1-99A9-BB5BAE2E0F14@.microsoft.com...
> Can you try turning "Can Shrink" to true so that when there is no data
> that
> it will shrink to a smaller size and let everything else move up?
> "Spartacus" wrote:
>> Anyone has any ideas about how to accomplish this by any chance? I am
>> pretty stuckk...
>>

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

Hidden columns/blank PDF page(s)

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

Hidden columns/blank PDF page(s)

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

sql

Hidden columns/blank PDF page(s)

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

hidden cell in excel

Hello,

Can someone please tell me why there's ALWAYS a hidden cell in Excel when a report has a more than one page?

for example, a report has 10 page breaks and after exported to Excel it has the first row hidden in each sheet except the first sheet.

Why this happens always? is there any workaround to avoid this?

thanks

I also have the same questions as the original poster.

How does one get rid of the hidden row in an exported Excel spreadsheet when there are page breaks in the report?

Thanks in advance.

|||

Hey Guys.

Can you clarify this a little more? I have exported my reports to excel but I get one long continuous sheet even when my report has multiple pages.

I have notice however that excel does include your report page margins, So I'm taking a guess that this could be what you're seeing in your export.

Ham

|||

Hey Ham,

Yes, one long continuous sheet in Excel, but the page breaks are there in the report definition for viewing via the Report Manager web site. We (independently, the OP and I) think that somehow the page breaks are influencing the "hidden row" phenomenon.

The hidden row presents itself in the exported Excel spreadsheet on "Sheet 2", where "Sheet 1" was the parameter detail information. If one inspects Sheet 2 (which is the actual data produced by the report), one would see that row 1 is hidden (perhaps a better word is collapsed; one can expand it by double clicking on the row separator in the left margin-ish area), row 2 contains the header row/column headings, then row 3 and beyond contain the actual data.

Our report users don't like that hidden row 1. I know that it would be easy to expand and then remove it in Excel but....you know users, they don't want it there from the get-go.

Thanks for any advice.

John

|||

Hi,

Can it be that you are using Document Maps in your report? It might be that it are document maps that you see.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Although I didn't build the reports myself, I spoke with the author, and inspected the layout view (and RDL), and we are NOT using Document Maps.

Might there be another reason for the "hidden row" issue with exported Excel reports?

John

|||

Hi John,

It is hard to say like that. Can you please mail or post the contents of the RDL file so I can take a look at it.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Here is the RDL. I took the majority of lines associated with a BMP image. Thanks for taking a look.

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="dsKnetch">
<DataSourceReference>dsKnetch</DataSourceReference>
<rd:DataSourceID>42d0feab-c2ad-4306-b39a-0993cc80c5f8</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.5in</BottomMargin>
<RightMargin>0.5in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="StartDtRange">
<DataType>DateTime</DataType>
<Prompt>Start of Date Range</Prompt>
</ReportParameter>
<ReportParameter Name="EndDtRange">
<DataType>DateTime</DataType>
<Prompt>End of Date Range</Prompt>
</ReportParameter>
<ReportParameter Name="Title">
<DataType>String</DataType>
<Prompt>Title Starts With</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Image Name="image1">
<Sizing>FitProportional</Sizing>
<ZIndex>5</ZIndex>
<Source>Embedded</Source>
<Style />
<Height>0.375in</Height>
<Value>knetch</Value>
</Image>
<Textbox Name="textbox38">
<Top>0.75in</Top>
<rd:DefaultName>textbox38</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>12pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Knetch - Crosscheck Report (by Title & Date)</Value>
</Textbox>
<Textbox Name="textbox37">
<Top>0.375in</Top>
<rd:DefaultName>textbox37</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>12pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Company</Value>
</Textbox>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="textbox55">
<Left>1.5in</Left>
<Top>0.125in</Top>
<rd:DefaultName>textbox55</rd:DefaultName>
<ZIndex>3</ZIndex>
<Width>8.375in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Parameters!Title.Value</Value>
</Textbox>
<Textbox Name="textbox28">
<Left>0.125in</Left>
<Top>0.125in</Top>
<ZIndex>2</ZIndex>
<Width>1.25in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Title Starts With:</Value>
</Textbox>
<Textbox Name="textbox2">
<Left>0.125in</Left>
<Top>0.375in</Top>
<ZIndex>1</ZIndex>
<Width>1.25in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Class(es) Date Range:</Value>
</Textbox>
<Textbox Name="textbox3">
<Left>1.5in</Left>
<Top>0.375in</Top>
<Width>8.375in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Parameters!StartDtRange.Value & " to " & Parameters!EndDtRange.Value</Value>
</Textbox>
</ReportItems>
<Top>1.375in</Top>
<ZIndex>2</ZIndex>
<PageBreakAtEnd>true</PageBreakAtEnd>
<Height>0.625in</Height>
</Rectangle>
<Textbox Name="textbox54">
<Top>1.125in</Top>
<ZIndex>1</ZIndex>
<Width>2.75in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Self Service Filter Options:</Value>
</Textbox>
<Table Name="table1">
<DataSetName>dsDisvantageCrosscheck</DataSetName>
<Top>2.125in</Top>
<Width>9.925in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!username.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!employee_name.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!office_name.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!class_no.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<Format>MM/dd/yy</Format>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!start_date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<Format>MM/dd/yy</Format>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!end_date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.2in</Height>
</TableRow>
</TableRows>
<Grouping Name="table1_Details_Group">
<GroupExpressions>
<GroupExpression>=Fields!username.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!employee_name.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!start_date.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!end_date.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox29">
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Username</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox30">
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Participant Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox31">
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Office</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox32">
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Class Number</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox33">
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Start Date</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox34">
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>End Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>1.5in</Width>
</TableColumn>
<TableColumn>
<Width>2.5in</Width>
</TableColumn>
<TableColumn>
<Width>3.125in</Width>
</TableColumn>
<TableColumn>
<Width>1in</Width>
</TableColumn>
<TableColumn>
<Width>0.9in</Width>
</TableColumn>
<TableColumn>
<Width>0.9in</Width>
</TableColumn>
</TableColumns>
<Height>0.45in</Height>
</Table>
</ReportItems>
<Height>2.75in</Height>
</Body>
<rd:ReportID>a8221bfa-83bd-4bbb-9054-09ad45a8dcad</rd:ReportID>
<LeftMargin>0.5in</LeftMargin>
<EmbeddedImages>
<EmbeddedImage Name="knetch">
<ImageData>Qk1atAA////</ImageData>
<MIMEType>image/bmp</MIMEType>
</EmbeddedImage>
</EmbeddedImages>
<DataSets>
<DataSet Name="dsDisCrosscheck">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandType>StoredProcedure</CommandType>
<CommandText>rpt.up_get_class_attend_crosscheck_title_date</CommandText>
<QueryParameters>
<QueryParameter Name="@.Title">
<Value>=Parameters!Title.Value</Value>
</QueryParameter>
<QueryParameter Name="@.StartDtRange">
<Value>=Parameters!StartDtRange.Value</Value>
</QueryParameter>
<QueryParameter Name="@.EndDtRange">
<Value>=Parameters!EndDtRange.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>dsKnetch</DataSourceName>
</Query>
<Fields>
<Field Name="reg_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>reg_id</DataField>
</Field>
<Field Name="class_no">
<rd:TypeName>System.String</rd:TypeName>
<DataField>class_no</DataField>
</Field>
<Field Name="course_no">
<rd:TypeName>System.String</rd:TypeName>
<DataField>course_no</DataField>
</Field>
<Field Name="course_title">
<rd:TypeName>System.String</rd:TypeName>
<DataField>course_title</DataField>
</Field>
<Field Name="course_type">
<rd:TypeName>System.String</rd:TypeName>
<DataField>course_type</DataField>
</Field>
<Field Name="function">
<rd:TypeName>System.String</rd:TypeName>
<DataField>function</DataField>
</Field>
<Field Name="start_date">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>start_date</DataField>
</Field>
<Field Name="end_date">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>end_date</DataField>
</Field>
<Field Name="credit_point">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>credit_point</DataField>
</Field>
<Field Name="student_count">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>student_count</DataField>
</Field>
<Field Name="peoplesoft_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>peoplesoft_id</DataField>
</Field>
<Field Name="username">
<rd:TypeName>System.String</rd:TypeName>
<DataField>username</DataField>
</Field>
<Field Name="employee_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>employee_name</DataField>
</Field>
<Field Name="reg_status">
<rd:TypeName>System.String</rd:TypeName>
<DataField>reg_status</DataField>
</Field>
<Field Name="text_status">
<rd:TypeName>System.String</rd:TypeName>
<DataField>text_status</DataField>
</Field>
<Field Name="loc_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>loc_name</DataField>
</Field>
<Field Name="office_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>office_name</DataField>
</Field>
<Field Name="office_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>office_id</DataField>
</Field>
<Field Name="area_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>area_name</DataField>
</Field>
<Field Name="area_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>area_id</DataField>
</Field>
<Field Name="product_id_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>product_id_name</DataField>
</Field>
<Field Name="product_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>product_id</DataField>
</Field>
<Field Name="segment_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>segment_name</DataField>
</Field>
<Field Name="segment_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>segment_id</DataField>
</Field>
<Field Name="service_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>service_name</DataField>
</Field>
<Field Name="service_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>service_id</DataField>
</Field>
<Field Name="bu_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>bu_name</DataField>
</Field>
<Field Name="bu_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>bu_id</DataField>
</Field>
<Field Name="process_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>process_name</DataField>
</Field>
<Field Name="process_id">
<rd:TypeName>System.String</rd:TypeName>
<DataField>process_id</DataField>
</Field>
<Field Name="job_type">
<rd:TypeName>System.String</rd:TypeName>
<DataField>job_type</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Author>Cll (Consultant)</Author>
<Code>public function IsDup(byval currentUsername as string, byref previousUsername as object) as string
dim result as string = "False"
if (currentUsername = previousUsername.Value)
result = "True"
else
previousUsername.Value = currentUsername
end if
IsDup = result
end function</Code>
<Width>10in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Description>This report returns a list of learners who have registration statuses of Open-Normal or Open-Confirmed for the title(s) and date range(s) specified. It provides the learner’s username, name and office. This report is used to crosscheck learners enrolled in Knetch and learners with a hotel reservation for the particular class or classes.</Description>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Textbox Name="textbox16">
<Top>0.03125in</Top>
<rd:DefaultName>textbox16</rd:DefaultName>
<ZIndex>2</ZIndex>
<Width>1.25in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>6pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="Page " & Globals!PageNumber & " of " & Globals!TotalPages</Value>
</Textbox>
<Textbox Name="textbox18">
<Left>1.375in</Left>
<Top>0.03125in</Top>
<ZIndex>1</ZIndex>
<Width>6.9375in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>6pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="? " & DateTime.Now.Year &</Value>
</Textbox>
<Textbox Name="textbox19">
<Left>8.375in</Left>
<Top>0.03125in</Top>
<Width>1.5625in</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontSize>6pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="Run Date/Time: " & DateTime.Now</Value>
</Textbox>
</ReportItems>
<Height>0.25in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.5in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>

|||Did anyone ever find the solution to this problem? I am also having this of using page breaks, and in Excel every sheet except sheet 1 has row 1 minimized.sql

hidden cell in excel

Hello,

Can someone please tell me why there's ALWAYS a hidden cell in Excel when a report has a more than one page?

for example, a report has 10 page breaks and after exported to Excel it has the first row hidden in each sheet except the first sheet.

Why this happens always? is there any workaround to avoid this?

thanks

I also have the same questions as the original poster.

How does one get rid of the hidden row in an exported Excel spreadsheet when there are page breaks in the report?

Thanks in advance.

|||

Hey Guys.

Can you clarify this a little more? I have exported my reports to excel but I get one long continuous sheet even when my report has multiple pages.

I have notice however that excel does include your report page margins, So I'm taking a guess that this could be what you're seeing in your export.

Ham

|||

Hey Ham,

Our report users don't like that hidden row 1. I know that it would be easy to expand and then remove it in Excel but....you know users, they don't want it there from the get-go.

Thanks for any advice.

John

|||

Hi,

Can it be that you are using Document Maps in your report? It might be that it are document maps that you see.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Although I didn't build the reports myself, I spoke with the author, and inspected the layout view (and RDL), and we are NOT using Document Maps.

Might there be another reason for the "hidden row" issue with exported Excel reports?

John

|||

Hi John,

It is hard to say like that. Can you please mail or post the contents of the RDL file so I can take a look at it.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Here is the RDL. I took the majority of lines associated with a BMP image. Thanks for taking a look.

Friday, February 24, 2012

HELP: ODBC Registry Error

Hi,
some registry entries about sql server odbc driver was accidently
deleted by me. now, in the driver page of odbc data source administor,
i can not found the sql server driver in the list. for the reason, the
SQL Server 2000 can not complete its installation normally, and the
problem is that i need to install the software.
i don't know how do i fix the error. i've already download a MDAC RTM
from microsoft, but it stop installation and report: MDAC 2.8 RTM is
incompatible with this version of Windows. All of its features are
currently part of Windows.
can anyone please help me ( my system is Windows XP )For what it's worth, here are the contents of a working Windows 2000
MDAC 2.8 SQL Server driver settings - obviously you need to tweak the
path to the DLL's according to your setup.
Windows Registry Editor Version 5.00
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODB
CINST.INI\SQL Server]
"UsageCount"=dword:00000007
"Driver"="C:\\WINNT\\System32\\SQLSRV32.dll"
"Setup"="C:\\WINNT\\System32\\SQLSRV32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="03.50"
"ConnectFunctions"="YYY"
"APILevel"="2"
"CPTimeout"="60"

Help: Multiple sub-reports creating extra blank pages on print

I have a project with multiple pages of reports. I am using one main page with all the other reports added through the sub-report control. The only problem is, after the first page and a couple of the other pages, it inserts a blank page in the print preview. If I view and print the reports seperately, and not all on the main report page they print fine, they don't roll over, don't print any extra blank pages. This only occurs when I add all them all as sub-reports. The last 5 pages don't suffer from this problem either.

Can anyone think of what the problem could be, or a way to solve it? All the pages are 8.5x11 with no margins. As I said, the pages alone print fine without any extra blank pages, so I'm confused why they would create extra white pages when added as sub-reports. The other thing is, I thought that perhaps pages having text that go all the way to the bottom were causing the issue, but some of the reports don't have text that extend to the bottom, so that rules that out.

I'd really appreciate any help. Thanks in advance.

We have seen a similar problem before. Can you try making the subreport element in the main report wider (enough to contain the entire subreport) and see that helps?|||The sub elements are all 8.5 inch,.25inch. The main report is 8.5,11 as are all the other reports. I initially had just placed them on there and they were seperated by a grid space or so, and their heights were all different (widths all stayed constant at 8.5). When I did this, though, the formatting was even worse and some of the reports would run into eachother. I would try making the main report length the size of all the subreports * 11 but I have 21 pages of reports and the maximum length is 160 inches.

Right now my main report is setup with each sub report element set at 8.5,.25 and starting from the very top of the main report, they are placed one below the other right where the previous one ends.
|||Any MSFT people who can provide any help? :||||I'm sorry to bump this again, but I could really use some assistance. I've tried everything and I can't get it to work.|||Can you attach your rdls? That'd help us repro and investigate the problem.

Friday, March 30, 2012

Hide Pagefooter

hide my report toolbar

Monday, March 26, 2012

Hidden Rectangle causing blank page.

Friday, March 23, 2012

Hidden items, whitespace

Hidden Items Still Taking Space on The Page

Hidden columns/blank PDF page(s)

Hidden columns/blank PDF page(s)

Hidden columns/blank PDF page(s)

Hidden columns/blank PDF page(s)

hidden cell in excel

hidden cell in excel

Friday, February 24, 2012

HELP: ODBC Registry Error

Help: Multiple sub-reports creating extra blank pages on print

Help Backup

Blog Archive

About Me