Showing posts with label header. Show all posts
Showing posts with label header. Show all posts

Wednesday, March 21, 2012

Interesting Problem/Bug with Logos in the page header

Scenario:

I have a report with a logo in the page header.

This report has 2 parameters: 1) Date 2) Boolean to Show/Hide detail.

When I put in the date and show the report, everything is fine. If I then change the boolean parameter to show or hide the detail, the logo file cannot be found (Displays a red X)

If I export the report like this, the red X is rendered in the export. The logo is not there.

Has anyone else experienced this issue?

Anyone know how to resolve it?

Thanks!

BobP

This is a known bug. The fix will be included in the next release.

Monday, March 12, 2012

interactive sort in group

hi,

i created a report using table with added group header and footer. i set a few columns at the table header for interactive sort. however, the sort doesn't work for thhe field that i place in the group header.

Is interactive sort supported in group header?

Thanks.

Yes, interactive sort is supported in group header. When you click on the sort in the group header, it just doesn't do anything? Can you attach your rdl so that I can see why it's not working for you?

- Fang

|||

thanks Fang for your reply. sorry if this seems silly. how do i attach the rdl file here?

thanks again

|||Looks like there is no way to attach a file here. Can you just post the XML in the thread?|||

hi Fang.. sorie... probably i should rephrase my question.

actually i have fields in my group header and place the labels for the respective fields at the table header. can i sort the fields in group header using the label in table header?

sorie for asking the wrong question.. thanks!

Interactive Sort (problem/bug)

Hi

Header image (setup as external) disappear when interactive sort is used (interactive sort is set in the body of the report), works fine if the image is embedded.

any help is appreciated.

Thank you

Veneto

This is a known issue. The fix is available in a hotfix for RS 2005 SP1, and will also be included in the next service pack.|||Thank you for replying.

Friday, February 24, 2012

Integration Services - Header and Footer

I have been struggling to get this right in Integration Services, Would really appreciate the help.

Basically I have a file with fixed length columns that I would like to import into my database using Integration Services, the file looks something like this

AN_HeaderRecord0001Testfile.txt

MyNameMySurname0127721506

MyName2 MySurname2 0127722322

FooterRec0000000004_02

What I need to find out is how do I import the data, the name and surname and telephone no, but skip the header and footer records. Also I need to be able to use the header and footer data for later use.

Any ideas ?

Rudolf,

You could do that easily in 2 steps(dataflows); the first one to add an extra column with the row number and determine the number of rows in the file (put the number in a variable using a rowcount transformation); then in the second one you can use a conditional split to re-direct the first and last row by comparing the rownumber column with the number in the variable from the first dataflow.

|||Thanx a mil for the response, I think I am getting the hang of this, will try it and let you know|||Your flat file connection manager should let you chose the option of skipping the first row altogether. Then all you'd have to worry about is removing the footer. If the detail records have a different indicator than the footer records, you can use a conditional split transformation to direct only the detail records to your destination.|||

Hi, Rapael

Could you perhaps point me in the correct direction (what components to use) to get the row number next to the row data

in the first data flow.

First Data Flow

I should have a flat file source and then a row count transformation component linked to each other ? I am having problems getting the row

data and the row number next to each other

Thanx in advance

|||

you can use an script component:

http://support.microsoft.com/kb/908460

|||Or use the Row Number transform here: http://www.sqlis.com/93.aspx