flatten out a normalized child table?

I need to extract Customer Order data, and join it to normalized ship-to
table so I can get their address on a single line/row of data. The Column
names are not importat in that final flat file, just what was in
row1,2,3,...6
GARY C Test Row1
LISA C Test Row2
816 RIVERVIEW PLACE Row3
WASHINGTON, MO 63090 Row4
Row5
Row6
THOMAS H Other-Test Row1
2102 N SHAMROCK RD Row2
BEL AIR, MD 21014 Row3
Row4 ,etc.
I have to account for double names names, and possibably titles, Suite #,
etc.
TIAPlease post DDL with your sample data. What is the key of the table you
posted? What relates the address lines together to make a single
address? Apparently nothing links an address together in the sketch you
posted except for the order in which you typed them out. We know that
tables have no fixed order so it isn't possible to combine the rows
reliably to make addresses out of each one.
If you had an additional column such as contact_name or contact_no for
each address line then you could do something like:
SELECT MAX(CASE WHEN row_num = 1 THEN addr END),
MAX(CASE WHEN row_num = 2 THEN addr END),
MAX(CASE WHEN row_num = 3 THEN addr END),
... etc
FROM your_table
GROUP BY contact_name ;
Hope this helps.
David Portas
SQL Server MVP
--|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1129058354.597302.39690@.g44g2000cwa.googlegroups.com...
> Please post DDL with your sample data. What is the key of the table you
> posted? What relates the address lines together to make a single
> address? Apparently nothing links an address together in the sketch you
> posted except for the order in which you typed them out. We know that
> tables have no fixed order so it isn't possible to combine the rows
> reliably to make addresses out of each one.
> If you had an additional column such as contact_name or contact_no for
> each address line then you could do something like:
> SELECT MAX(CASE WHEN row_num = 1 THEN addr END),
> MAX(CASE WHEN row_num = 2 THEN addr END),
> MAX(CASE WHEN row_num = 3 THEN addr END),
> ... etc
> FROM your_table
> GROUP BY contact_name ;
Thanks

fitting a report into a single page

hello guys,

i am making a report which views atleast 20 columns..and on the default font size it is being rendered which is in 11 it is impossible to print it in a single page..

i am just wondering if it is possible if during the exporting to pdf, is it possible to fit it in a single page by shrinking its contents into a size that will fit the page..

any help will be highly appreciated..

thanks in advance!

Yes. Simply define your page large enough to contain all of the columns. Then export to PDF and print using 'fit to page' option. Warning, the print may be VERY small, but it will scale and be readable on a high quality printer. Remember to increase the length of your page in ratio with the width.|||

ok ill try that one..so that means there is no way you can do it in the reporting services..it is manually done in the acrobat during printing phase isn't it?

anyway thanks for the reply..it really helps!

fitting a report into a single page

hello guys,

i am making a report which views atleast 20 columns..and on the default font size it is being rendered which is in 11 it is impossible to print it in a single page..

i am just wondering if it is possible if during the exporting to pdf, is it possible to fit it in a single page by shrinking its contents into a size that will fit the page..

any help will be highly appreciated..

thanks in advance!

Yes. Simply define your page large enough to contain all of the columns. Then export to PDF and print using 'fit to page' option. Warning, the print may be VERY small, but it will scale and be readable on a high quality printer. Remember to increase the length of your page in ratio with the width.|||

ok ill try that one..so that means there is no way you can do it in the reporting services..it is manually done in the acrobat during printing phase isn't it?

anyway thanks for the reply..it really helps!

First Time Installing - Can't Find BIDS

Thank you to all that take the time to read this!

All software is installed on a single development pc.I have a SQL Server 2000 Developer Edition Database that I am using to test a new Accounting System.SQL Server 2000 is the required format.I would like to start developing some SRSS reports against that database.It was suggested that I install the SQL Server 2005 Reporting Services, because I was told 2005 is less buggy and easier to use.I installed SRSS 2005, and only SRSS 2005, and used the Configuration Tool to get it configured properly, I think. I have green checks on everything except "Email Settings" and "Execution Account"

Now, I want to write some reports.BIDS is not under the "Microsoft SQL Server 2005" program group, only "Configuration Tools".I was also told that I could use Visual Studio to write reports.I installed Visual Studio 2005 Standard Edition.When I go start a new project, "Business Intelligence” is not a project type or sub-type.

What do I need to do so I can either install BIDS or use VS 2005 to write reports?

If you open Visual Studio 2005 and create a new project, do you see 'Business Intelligence Projects' as an available project type?

Jarret

|||

BIDS is part of the SQL Server 2005 Workstation components and development tools - you'll need to go back and install that option in the installer.

Installing BIDS includes the SSRS support in Visual Studio. (BIDS actually is Visual Studio, just with little/no programming language support by default.)

|||

Rup,

Thank you for the help! That was the problem.