| | |
problem in converting from ntext to nvarchar
Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
![]() |
•
•
Join Date: Mar 2006
Posts: 84
Reputation:
Solved Threads: 1
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
•
•
•
•
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
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.
•
•
Join Date: Mar 2006
Posts: 84
Reputation:
Solved Threads: 1
•
•
•
•
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.
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.
![]() |
Similar Threads
- 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
| Thread Tools | Search this Thread |
.net 2.0 3.5 activexcontrol advice ajax alltypeofvideos appliances asp asp.net bc30451 beginner bottomasp.net browser businesslogiclayer c# c#gridviewcolumn cac checkbox commonfunctions compatible confirmationcodegeneration content contenttype courier css dataaccesslayer database datagrid datagridview datagridviewcheckbox datalist development dgv dropdownlist dropdownmenu dynamically edit fileuploader fill flash flv formatdecimal forms formview gridview gudi homeedition iframe iis javascript jquery listbox menu microsoft mono mouse mssql multistepregistration nameisnotdeclared news objects opera panelmasterpagebuttoncontrols redirect registration relationaldatabases reportemail rotatepage schoolproject security serializesmo.table sessionvariables silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking treeview unauthorized validatedate validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webapplications webarchitecture webdevelopemnt webprogramming webservice youareanotmemberofthedebuggerusers





