•
•
•
•
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
 |
•
•
Join Date: Mar 2006
Posts: 84
Reputation: 
Rep Power: 3
Solved Threads: 1
Junior Poster in Training
problem in converting from ntext to nvarchar 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
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
•
•
Join Date: Feb 2003
Location: Canada
Posts: 786
Reputation:
Rep Power: 9
Solved Threads: 25
Master Poster
•
•
•
•
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
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
•
•
Join Date: Mar 2006
Posts: 84
Reputation:
Rep Power: 3
Solved Threads: 1
Junior Poster in Training
•
•
•
•
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
Linear Mode
- Hi Everyone, Have a C++ Problem. (C++)
- Problem converting Selection Sort to Class (C++)
- C problem in strings and recursive check (C)
- Problem converting to a double (C)
- Converting from VB code to C (C)
- Math problem in C (C)
- VC++:convert File IStream to hex and store...? (C++)
Other Threads in the ASP.NET Forum
- Previous Thread: Wierd Error message.
- Next Thread: configuring barcode scanner
