I have some complex Word forms that need to be converted into reports. Are
there any tools for converting/importing Word to RDL format as you can't
paste into the desinger.
Thanks
Toby.SQL Server 2000 Reporting Services does not support this directly. You
might check to see if one of our partners is able to assist you:
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Toby" <toby.maillist@.exmlsystems.com> wrote in message
news:uMKD5gshEHA.1276@.TK2MSFTNGP09.phx.gbl...
> I have some complex Word forms that need to be converted into reports. Are
> there any tools for converting/importing Word to RDL format as you can't
> paste into the desinger.
> Thanks
> Toby.
>
Showing posts with label complex. Show all posts
Showing posts with label complex. Show all posts
Friday, March 23, 2012
Monday, March 19, 2012
Importing fixed field length files
Hi,
Im importing data from a file, and saving it into a table, nothing complex.
The file contains fixed length fields, and the table is integers ( default
NULL ). When a value in the file is NULL, it is simply a series of spaces
indicating no value.
When EM parses the spaces, instead of inserting NULL into the table (because
it didn't find a digit), it complains about incompatable types?
Is the parsing engine really so stupid that it cannot convert spaces to a
single NULL when it knows it should be looking for numbers?!
How can i make this work?
Jeo
Does no-one know how to do the conversion?
"JoeB" <joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote in message
news:e$f0MfchEHA.3944@.tk2msftngp13.phx.gbl...
> Hi,
> Im importing data from a file, and saving it into a table, nothing
> complex.
> The file contains fixed length fields, and the table is integers ( default
> NULL ). When a value in the file is NULL, it is simply a series of spaces
> indicating no value.
> When EM parses the spaces, instead of inserting NULL into the table
> (because it didn't find a digit), it complains about incompatable types?
> Is the parsing engine really so stupid that it cannot convert spaces to a
> single NULL when it knows it should be looking for numbers?!
>
> How can i make this work?
>
> Jeo
>
>
|||Hiya,
There are two ways I can think of doing this, the quick dirty way and
the complicated clever way,
1.Import the integer into a text field and then use an update
query to populate the interger field. You can then use a combination
of trim and case statements to get the values you want. It'll work,
but not ideal.
2.I assume you're using DTS to import the data. In which case
you can change the transformation the this column from a simple copy
column to a an activeX script. You can then create some VB script to
change the value to null if it finds all spaces.
If it was me then it would depend on whether this is a one off or a
regular job. For a one off I would do option 1, if I'm going to have
to do this regularly then I would take the time and do option 2.
Darious
On Tue, 24 Aug 2004 11:12:19 +0100, "JoeB"
<joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote:
>Does no-one know how to do the conversion?
>
>"JoeB" <joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote in message
>news:e$f0MfchEHA.3944@.tk2msftngp13.phx.gbl...
>
|||Cheers, Im going to try option one as i cannot write VB code.
Thanks.
Joe
"Darious" <news@.areyoukidding.com> wrote in message
news:q2dni0haq1pemlcbvmnpbmg37js7q5a5em@.4ax.com...
> Hiya,
> There are two ways I can think of doing this, the quick dirty way and
> the complicated clever way,
> 1. Import the integer into a text field and then use an update
> query to populate the interger field. You can then use a combination
> of trim and case statements to get the values you want. It'll work,
> but not ideal.
> 2. I assume you're using DTS to import the data. In which case
> you can change the transformation the this column from a simple copy
> column to a an activeX script. You can then create some VB script to
> change the value to null if it finds all spaces.
> If it was me then it would depend on whether this is a one off or a
> regular job. For a one off I would do option 1, if I'm going to have
> to do this regularly then I would take the time and do option 2.
> Darious
> On Tue, 24 Aug 2004 11:12:19 +0100, "JoeB"
> <joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote:
>
Im importing data from a file, and saving it into a table, nothing complex.
The file contains fixed length fields, and the table is integers ( default
NULL ). When a value in the file is NULL, it is simply a series of spaces
indicating no value.
When EM parses the spaces, instead of inserting NULL into the table (because
it didn't find a digit), it complains about incompatable types?
Is the parsing engine really so stupid that it cannot convert spaces to a
single NULL when it knows it should be looking for numbers?!
How can i make this work?
Jeo
Does no-one know how to do the conversion?
"JoeB" <joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote in message
news:e$f0MfchEHA.3944@.tk2msftngp13.phx.gbl...
> Hi,
> Im importing data from a file, and saving it into a table, nothing
> complex.
> The file contains fixed length fields, and the table is integers ( default
> NULL ). When a value in the file is NULL, it is simply a series of spaces
> indicating no value.
> When EM parses the spaces, instead of inserting NULL into the table
> (because it didn't find a digit), it complains about incompatable types?
> Is the parsing engine really so stupid that it cannot convert spaces to a
> single NULL when it knows it should be looking for numbers?!
>
> How can i make this work?
>
> Jeo
>
>
|||Hiya,
There are two ways I can think of doing this, the quick dirty way and
the complicated clever way,
1.Import the integer into a text field and then use an update
query to populate the interger field. You can then use a combination
of trim and case statements to get the values you want. It'll work,
but not ideal.
2.I assume you're using DTS to import the data. In which case
you can change the transformation the this column from a simple copy
column to a an activeX script. You can then create some VB script to
change the value to null if it finds all spaces.
If it was me then it would depend on whether this is a one off or a
regular job. For a one off I would do option 1, if I'm going to have
to do this regularly then I would take the time and do option 2.
Darious
On Tue, 24 Aug 2004 11:12:19 +0100, "JoeB"
<joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote:
>Does no-one know how to do the conversion?
>
>"JoeB" <joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote in message
>news:e$f0MfchEHA.3944@.tk2msftngp13.phx.gbl...
>
|||Cheers, Im going to try option one as i cannot write VB code.
Thanks.
Joe
"Darious" <news@.areyoukidding.com> wrote in message
news:q2dni0haq1pemlcbvmnpbmg37js7q5a5em@.4ax.com...
> Hiya,
> There are two ways I can think of doing this, the quick dirty way and
> the complicated clever way,
> 1. Import the integer into a text field and then use an update
> query to populate the interger field. You can then use a combination
> of trim and case statements to get the values you want. It'll work,
> but not ideal.
> 2. I assume you're using DTS to import the data. In which case
> you can change the transformation the this column from a simple copy
> column to a an activeX script. You can then create some VB script to
> change the value to null if it finds all spaces.
> If it was me then it would depend on whether this is a one off or a
> regular job. For a one off I would do option 1, if I'm going to have
> to do this regularly then I would take the time and do option 2.
> Darious
> On Tue, 24 Aug 2004 11:12:19 +0100, "JoeB"
> <joe@.kybert__***NO_SPAM*sdfsdfsd****___.com> wrote:
>
Subscribe to:
Posts (Atom)