User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 391,548 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,541 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 3496 | Replies: 2
Reply
Join Date: Mar 2006
Posts: 84
Reputation: web_developer is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 1
web_developer web_developer is offline Offline
Junior Poster in Training

Help problem in converting from ntext to nvarchar

  #1  
May 17th, 2006
hey all
i need ur help

i have a database, and a table with report column. in this column, i storing data and i can change the bold, colored and aligned the text using a toolbar, like the toolbar here when u want to put a thread.

all that is working, but the problem is i am using crystal report so i want to see the reports. the reports is saved with some code which makes the bold and colored. i want to see only the text in the crystal report.

here is example of report saved in database:
<PRE>this is example</PRE>

i want to see in crystal report only: this is example
so i am using the convert method in sql, to convert from ntext to nvarchar, but nothing is happened.
this is the sql command:
select convert(nvarchar(4000), report) from report_table

what i can do to see only the text?


sam
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2003
Location: Canada
Posts: 786
Reputation: Paladine has a spectacular aura about Paladine has a spectacular aura about Paladine has a spectacular aura about 
Rep Power: 9
Solved Threads: 25
Colleague
Paladine's Avatar
Paladine Paladine is offline Offline
Master Poster

Re: problem in converting from ntext to nvarchar

  #2  
May 18th, 2006
Originally Posted by web_developer
hey all
i need ur help

i have a database, and a table with report column. in this column, i storing data and i can change the bold, colored and aligned the text using a toolbar, like the toolbar here when u want to put a thread.

all that is working, but the problem is i am using crystal report so i want to see the reports. the reports is saved with some code which makes the bold and colored. i want to see only the text in the crystal report.

here is example of report saved in database:
<PRE>this is example</PRE>

i want to see in crystal report only: this is example
so i am using the convert method in sql, to convert from ntext to nvarchar, but nothing is happened.
this is the sql command:
select convert(nvarchar(4000), report) from report_table

what i can do to see only the text?


sam

What are you coding this work in? ASP.NET? 1.1 , 2.0 ? Visual Basic / C-Sharp, C++ ?

Unsderstanding your example, their is a little more involved in "stripping" a crystal report, than a convert statment in SQL.

I am still a little unclear what you are trying to accomplish...for that I apologize.
Assistant Manager, Regional Pharmacy Information Systems
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
Reply With Quote  
Join Date: Mar 2006
Posts: 84
Reputation: web_developer is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 1
web_developer web_developer is offline Offline
Junior Poster in Training

Re: problem in converting from ntext to nvarchar

  #3  
May 18th, 2006
Originally Posted by Paladine
What are you coding this work in? ASP.NET? 1.1 , 2.0 ? Visual Basic / C-Sharp, C++ ?

Unsderstanding your example, their is a little more involved in "stripping" a crystal report, than a convert statment in SQL.

I am still a little unclear what you are trying to accomplish...for that I apologize.


yes i am using asp.net and vb.net as code.

as i said before, i want only to retrive in my crystal report, the text of the report column, not with the bold, colored or any additional code.

ex: in row 10, i have this text:
sam saved in database

in crystal report, i want only to see, sam without the bold code.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb ASP.NET Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the ASP.NET Forum

All times are GMT -4. The time now is 8:59 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC