SreeKanth D
asked on
How to display HTML text with cangrow option in Crystal reports
I had this question after viewing how to read <br> and display a new line in crystal report labels.
HTML-Cangrow.PNG
HTML-Cangrow.PNG
I believe that is correct.
The interpretation set is somewhat limited.
Do you have a database field that has HTML text in it?
mlmcc
The interpretation set is somewhat limited.
Do you have a database field that has HTML text in it?
mlmcc
ASKER
Hi Raghavendra,
Have set up the interpretation as "HTML" and Checked the Can grow option.
My database field datatype is is nvarchar().
the data in the fields as below.
ex:
</br>data is not correct..bla bla..
</br>Data need to verify.. bla bla..
Have set up the interpretation as "HTML" and Checked the Can grow option.
My database field datatype is is nvarchar().
the data in the fields as below.
ex:
</br>data is not correct..bla bla..
</br>Data need to verify.. bla bla..
Hi,
Is it possible to share the report with some sample saved data?
Is it possible to share the report with some sample saved data?
ASKER
Sure,
Please find sample attachment. my comments data is displaying over below line instead of grow.
html-cangrow1.PNG
Please find sample attachment. my comments data is displaying over below line instead of grow.
html-cangrow1.PNG
Hi Sreekanth,
Not screenshot of data. The report with saved sample data.
Not screenshot of data. The report with saved sample data.
ASKER
Hi Raghavendra,
Thank you very much for your Quick responses.
Here is my sample data in nvarchar column in sql db. these data I converted into "HTML" interpretation in crystal report and checked cangrow option
Ex Data:
</br>De-minimis qualification is not applicable because FGCost missing
</br>De-minimis qualification is not applicable because of unknown cost Components
</br>De-minimis qualification is not applicable because of Cost overflow
</br>De-minimis qualification is not applicable because of cost is 0
If it is not your intention on sample data ,please let me know I will provide the crystal report Screenshot.
Thank you very much for your Quick responses.
Here is my sample data in nvarchar column in sql db. these data I converted into "HTML" interpretation in crystal report and checked cangrow option
Ex Data:
</br>De-minimis qualification is not applicable because FGCost missing
</br>De-minimis qualification is not applicable because of unknown cost Components
</br>De-minimis qualification is not applicable because of Cost overflow
</br>De-minimis qualification is not applicable because of cost is 0
If it is not your intention on sample data ,please let me know I will provide the crystal report Screenshot.
Hi,
Yes, need the report .rpt file with "save data with report".
Yes, need the report .rpt file with "save data with report".
ASKER
My Report is one of the sub report in main report. so can't give the entire rpt file.
Just attached snap of sub report section and highlighted the Field of "HTML" Interpretation Text.
Just attached snap of sub report section and highlighted the Field of "HTML" Interpretation Text.
Hi,
Not sure whether you attached anything with your last comment. The reason for asking the report is to check any changes required for the html content.
I have attached a sample I have created using the data you provided.
It works fine for me.
Let me know if you face any issue with the sample I have enclosed.
TestReport-Sreekanth.rpt
Not sure whether you attached anything with your last comment. The reason for asking the report is to check any changes required for the html content.
I have attached a sample I have created using the data you provided.
It works fine for me.
Let me know if you face any issue with the sample I have enclosed.
TestReport-Sreekanth.rpt
ASKER
Hi,
if it is only one field it's working fine.
Just Added one new field to your Test report below the HTML field, again the html text is wrapping into immediate text.
Please find attached report.
TestReport1-Sreekanth.rpt
if it is only one field it's working fine.
Just Added one new field to your Test report below the HTML field, again the html text is wrapping into immediate text.
Please find attached report.
TestReport1-Sreekanth.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for all your quick responses. it's working for me if I add fields in 2 sections.
My current requirement is 2 print both fields under one section. is there any chance to print them without overlapping?
My current requirement is 2 print both fields under one section. is there any chance to print them without overlapping?
That would be difficult to asses unless you know that your first field occupies some fixed number of lines. So, that you can display your second field after that much space.
Any restrictions for not to use them on different sections?
Any restrictions for not to use them on different sections?
ASKER
Yes, as per the logic we need to show the fields side by side, Also have nearly 7 group sections .
So finally added section and working perfect.
So finally added section and working perfect.
ASKER
working perfect after add in to 2 sections
Have you set the text interpretation to "HTML Text"?
Can Grow works with HTML interpretation.