Showing posts with label body. Show all posts
Showing posts with label body. Show all posts

Monday, March 26, 2012

Gap between header and Body

Hello every body,

I am facing a smal formatting issue. the issue i have 7 text boxes attached with each other in the header to show the week days ,i.e Sunday,Monday,Tuesday,Wednesday,Thursay,Friday and Saturday

In Body,i have a matrix which will extend to have 7 columns for the weekdays.

Every thing is fine,Except a small gap between header and footer where i want the 7 text boxes to act as column header names.

I tried with various options like removing the header and placing the text boxes in Body followed by the matrix. 2) placing the seven column headers in a dummy table and attaching that with matrix,

But i am unable to remove the gap between them. if any one of you had experienced the same problem or knows how to solve.it's really a great help

Thank you,

Will it be possible for you to use a table instead? Place a table in the body. Use the table heade for the column names and the table details for the values.

|||

NO Tech Quest, the matrix doesn't stop with one week.

For Each week one matrix is reported.Its just like a calendar

Thanks

Raj deep.A

|||

Raj, Is there a reason that you are not using the "Columns" within the matrix for the headers. I know the alignment/ formatting gets harder when you separate them and use the headers and footers for this.

Wednesday, March 21, 2012

fuzzy lookup

Hi Friends,

Can some body briefly explain me what is the difference between fuzzy lookup and fuzzy grouping?

thanks and regards

Ruther wrote:

Hi Friends,

Can some body briefly explain me what is the difference between fuzzy lookup and fuzzy grouping?

thanks and regards

One is a lookup, the other is a group by? The fuzzy grouping is good for finding duplicates while the lookup is good for finding matches.|||

If the fuzzy lookup is analogous to the regular LOOKUP component in SSIS then Fuxxy Grouping is most analogous to the AGGREGATE component.

Under the covers the Fuzzy Grouping does the same as the Fuzzy Lookup, it then groups the data according to the looked up value (I think).

BOL will have all the answers.

-Jamie

sql