exporting to a pdf problem

HI everybody, my problem is that when i export to a pdf file i get on first page cut of info and the second page I just get a header and footer. Is there anything to do to fix this problemWould you please post your RDL and the PDF file. If you are using SP1, would
you also post the <ReportName>.rdl.data file.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-man" <J-man@.discussions.microsoft.com> wrote in message
news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
> HI everybody, my problem is that when i export to a pdf file i get on
first page cut of info and the second page I just get a header and footer.
Is there anything to do to fix this problem|||Just checking - are you running SP1?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-man" <J-man@.discussions.microsoft.com> wrote in message
news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
> HI everybody, my problem is that when i export to a pdf file i get on
> first page cut of info and the second page I just get a header and footer.
> Is there anything to do to fix this problem|||Well, if you didn't apply SP1 you are probably not running it. When you
browse to http://servername/reportserver, what version do you see? If it
says 878, you are running SP1. If it says 743, you are running RTM. You can
install SP1 from the link off http://www.microsoft.com/sql/reporting.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"j-man" <j-man@.discussions.microsoft.com> wrote in message
news:A76A0B7C-3A01-4CFB-B43A-1D0485E847E0@.microsoft.com...
>I have no clue, I'm just a dumb kid. How would i find this out?
> "Brian Welcker [MSFT]" wrote:
>> Just checking - are you running SP1?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "J-man" <J-man@.discussions.microsoft.com> wrote in message
>> news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
>> > HI everybody, my problem is that when i export to a pdf file i get on
>> > first page cut of info and the second page I just get a header and
>> > footer.
>> > Is there anything to do to fix this problem
>>

Exporting text file and populate it as table using SQL

Hi,
I have a problem, I have some text files in the server. I have to export that file and read it line by line and then cut it into fields and populate it as a table in SQl with SQL commnads.

Could you anybody help mw with some hints, any relevent readings etc..
How can i use sql framework for thisIf you have control over how the text files can look like, I would recommend using the FOR XML and XML Shredding mechanisms (OpenXML, nodes() method).

Otherwise in SQL 2005, I would look into CLR user-defined functions to write the parsing code in your fav .Net language.

In SQL 2000, you would have to do it in TSQL or the mid-tier.

Also, if the data is not yet in the database but in a file, you can look into OpenRowset(BULK) in SQL Server 2005. Otherwise you need to read it in the mid-tier...