Is it possible to format (Text) in this way

hi,

i want to display something is this fashion

Roth 401(k) Contribution

jfkajfkdjfdjfkdj ldkfdlkfl;dkfldkfld;fkdl

in a table row, but i am not sure how to do it. can some one pls give me some ideas.

Regards,

Karen

If I understand correctly you want the ability to display bold and non-bold text in the same text box?
km
|||yeah thats true|||

I don't think different font properties are possible in a single textbox. Wat you can try doing is put two textboxes (one with Bold font and the other without, as you require) one below the other inside a rectangle and place the rectangle in your Table Row.

-Aayush

|||thanks a lot it works now.

Is it possible to do a bulk insert with a format file?

Hi,
Is it possible to do a bulk insert from one table to another with field
delimiter?
Example:
I have records in table A that means to be parsed into table B:
Table A
LineFeed Varchar(8000)
Table B
Customer_Number char(8)
First_Name varchar(25)
Last_name varchar(25)
DOB Timedate
The records in table A look like this..
1234567;Kevin;Smith;10/25/2005
123458;Eric;Joe M;11/10/2004
I know how to do this with a cursor and parsing the field by using charindex
and stuff, but i wonder if there's a faster way of doing it with a simple BC
P
utility.Yes, although it's a bit tricky, and the format file is a bit unforgiving
and error messages are cryptic.. You should check out previous posts in this
forum on Bulk Insert" (and Books OnLine as well)
"EricH" wrote:

> Hi,
> Is it possible to do a bulk insert from one table to another with field
> delimiter?
> Example:
> I have records in table A that means to be parsed into table B:
> Table A
> LineFeed Varchar(8000)
> Table B
> Customer_Number char(8)
> First_Name varchar(25)
> Last_name varchar(25)
> DOB Timedate
> The records in table A look like this..
> 1234567;Kevin;Smith;10/25/2005
> 123458;Eric;Joe M;11/10/2004
> I know how to do this with a cursor and parsing the field by using charind
ex
> and stuff, but i wonder if there's a faster way of doing it with a simple
BCP
> utility.|||Hi CBretana,
I've tried reading books online and it don't talk about moving data from one
table to another.
I have tried the following syntax and it's coming back as an error:
BULK INSERT tempdb.dbo.TableA
FROM (SELECT Linefeed from tempdb.dbo.TableB) S
WITH
(FIELDTERMINATOR = ';')
Anyone else seeing a problem here?|||Because Bulk Insert is for moving Data from EXTERNAL files into Sql Server,
not for moving data from One table to another. For this latter purpose you
should use standard SQL Insert/Update Statements, or DTS.
"EricH" wrote:

> Hi CBretana,
> I've tried reading books online and it don't talk about moving data from o
ne
> table to another.
> I have tried the following syntax and it's coming back as an error:
> BULK INSERT tempdb.dbo.TableA
> FROM (SELECT Linefeed from tempdb.dbo.TableB) S
> WITH
> (FIELDTERMINATOR = ';')
> Anyone else seeing a problem here?
>

Is it possible to custom format the parameter dropdownlist?

I have a reporting services 2000 report that has only one string report
parameter with a prompt 'Select a Project'. The project list contains
project names that are so long that they take up about 95% of the page
width and the View report button becomes a partially visible button
with a horizontal scroll bar to scroll further to the right to view the
entire page.
My users hate to have to scroll to the right. They are requesting a
fixed width dropdownlist with fully visible 'View report' button.
We want to make our DDL pretty narrow so that it only shows the first n
characters of the project name string when the DDL is not dropped down.
When the user
drops the list down we want to resize it wide enough to show the entire
string.
We could also assign a tool tip to the DDL if we could supply a unique
tip
to each row in the DDL?
Any ideas? Does SSRS 2005 let the designer specify the parameter
control width?
Many thanks in advance.I've found that the parameter panel is not at all configurable and have
been creating a front-end web page for each report giving me total
control over presentation. Then I hide the parameter panel via a
parameter on the URL. It's my understanding RS 2005 has more control
over the parameter panel.|||Many thanks, Kent.

Is it possible to "decorate" rendering?

This is a multi-part message in MIME format.
--=_NextPart_000_0024_01C4B3A9.116B5BF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I was curious if was possible (or someone has at least attempted this) = to hook into the rendering mechanism. I'm interested especially in = being able to do this with charts.
--
Regards,
Tim Ellison, MCP
Ironworks Consulting, LLC
(m) 804.405.4874
--=_NextPart_000_0024_01C4B3A9.116B5BF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I was curious if was possible (or = someone has at least attempted this) to hook into the rendering mechanism. I'm = interested especially in being able to do this with charts.
-- Regards,

Tim Ellison, MCPIronworks Consulting, LLC(m) 804.405.4874
--=_NextPart_000_0024_01C4B3A9.116B5BF0--That's not supported in RS 2000.
There will be options for doing this in charts in future releases.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TIM ELLISON" <TimEllison@.direcway.com> wrote in message
news:O8Tsiq8sEHA.820@.TK2MSFTNGP12.phx.gbl...
I was curious if was possible (or someone has at least attempted this) to
hook into the rendering mechanism. I'm interested especially in being able
to do this with charts.
--
Regards,
Tim Ellison, MCP
Ironworks Consulting, LLC
(m) 804.405.4874|||Thanks. I was looking for a way to hook into the event model to do this but
actually came up with a neat way to "sort of" reproduce it with a finite
list (i.e., all columns known beforehand). I am definitely on the RS
bandwagon. I worked with it when it was bits and it was solid then. This
is perhaps one of the best V1 products I've worked with in my 12 years. The
documentation is even good :)..
--
Regards,
Tim Ellison, MCP
Ironworks Consulting, LLC
(m) 804.405.4874
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:eUQnp$9sEHA.2316@.TK2MSFTNGP12.phx.gbl...
> That's not supported in RS 2000.
> There will be options for doing this in charts in future releases.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "TIM ELLISON" <TimEllison@.direcway.com> wrote in message
> news:O8Tsiq8sEHA.820@.TK2MSFTNGP12.phx.gbl...
> I was curious if was possible (or someone has at least attempted this) to
> hook into the rendering mechanism. I'm interested especially in being
able
> to do this with charts.
> --
> Regards,
> Tim Ellison, MCP
> Ironworks Consulting, LLC
> (m) 804.405.4874
>

Is it possiable conversion

Hi

i heared that Oracle can convert from number to word thru query i
remember thru (jsp format) .Is it possiable in sqlserver

ThanksHi

Although I have not done this myslf, you may want to look at either:
Creating an RTF document
Creating a txt document and a word macro to format and save it
Using a COM object (called from sp_AO* procedures)
Using XML and a word template that picks it up.
Sucking data from SQL Server into word

John

"Raghuraman" <raghuraman_ace@.rediffmail.com> wrote in message
news:66c7bef8.0311140440.4738e50d@.posting.google.c om...
> Hi
> i heared that Oracle can convert from number to word thru query i
> remember thru (jsp format) .Is it possiable in sqlserver
>
>
> Thanks

Is Excel really Excel

I have a client who uses Reporting Services for their reports. They
prefer Excel format, but what comes back doesn't seem to be a real Excel
file. It will only load in Office 2003 for the PC, everything else,
including Macs, thinks they are some XML file. For large reports,
several thousands rows that produce 52 MB files, do not load at all and
will cause desktops to crap out. What kind of Excel comes back from RS?Hi,
I think you need to install Service Pack 1 for Reporting services as it
introduces excel export for excel pre Office 2003.
Although Service Pack 2 is out now so you can just install that (it already
contains Service Pack 1).
"No One" wrote:
> I have a client who uses Reporting Services for their reports. They
> prefer Excel format, but what comes back doesn't seem to be a real Excel
> file. It will only load in Office 2003 for the PC, everything else,
> including Macs, thinks they are some XML file. For large reports,
> several thousands rows that produce 52 MB files, do not load at all and
> will cause desktops to crap out. What kind of Excel comes back from RS?
>|||Is this chosen with the same format specifier or a different one?
NH wrote:
> Hi,
> I think you need to install Service Pack 1 for Reporting services as it
> introduces excel export for excel pre Office 2003.
> Although Service Pack 2 is out now so you can just install that (it already
> contains Service Pack 1).
> "No One" wrote:
>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||I dont understand your question.
"No One" wrote:
> Is this chosen with the same format specifier or a different one?
> NH wrote:
> > Hi,
> >
> > I think you need to install Service Pack 1 for Reporting services as it
> > introduces excel export for excel pre Office 2003.
> >
> > Although Service Pack 2 is out now so you can just install that (it already
> > contains Service Pack 1).
> >
> > "No One" wrote:
> >
> >
> >>I have a client who uses Reporting Services for their reports. They
> >>prefer Excel format, but what comes back doesn't seem to be a real Excel
> >>file. It will only load in Office 2003 for the PC, everything else,
> >>including Macs, thinks they are some XML file. For large reports,
> >>several thousands rows that produce 52 MB files, do not load at all and
> >>will cause desktops to crap out. What kind of Excel comes back from RS?
> >>
>|||When you choose Excel prior to the service packs it came out in an XML
format known and supported by Excel. But, it had to be Excel 2003. With the
service pack they went to binary format of Excel which is supported by Excel
2000 and greater. When you select Excel after the service pack is applied
you will get the binary format.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"No One" <aintnoway@.blahblahblah.com> wrote in message
news:adbml2-jp9.ln1@.gandalf.grey-net.com...
> Is this chosen with the same format specifier or a different one?
> NH wrote:
>> Hi,
>> I think you need to install Service Pack 1 for Reporting services as it
>> introduces excel export for excel pre Office 2003. Although Service Pack
>> 2 is out now so you can just install that (it already contains Service
>> Pack 1).
>> "No One" wrote:
>>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||Thanks.
Is there anyway to tell if the stream returned in empty?
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>|||It also works in OpenOffice. Very good.
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>