Comments by Member 9346617

Member 9346617 18-May-23 6:40am View

Yes. I have already set it to SimSun.

Member 9346617 18-May-23 6:13am View

<textbox name="textbox3">
<cangrow>true
<canshrink>true
<keeptogether>true
<paragraphs>
<paragraph>
<textruns>
<textrun>
<value>=Fields!value.Value
<markuptype>HTML

<FontFamily>SimSun</fontfamily>
<FontSize>9pt</fontsize>
<Language>zh-CN</language>

</paragraph>
</paragraphs>
<Style>
<PaddingLeft>4pt</paddingleft>
<PaddingRight>6pt</paddingright>
<PaddingTop>4pt</paddingtop>
<PaddingBottom>4pt</paddingbottom>

This is how I am adding the text box and setting it's properties.

Member 9346617 18-May-23 6:01am View

Thanks for your reply.
I have taken the datatype of column as "nvarchar" and I can save chinese characters properly in database. I can also retrieve them very well. But while showing it on rdl report, it's showing as "?????"
I tried setting the language of the designer under Localization as "zh-CN" and also set the same language for the text box but still it didn't help me.

Member 9346617 18-May-23 1:02am View

Yes. In control panel, I can see that SimSun font was already installed.
Even I tried adding the chinese language in browser but still no luck.
Appreciate your thought on this.

Member 9346617 9-Apr-19 1:11am View

Thanks Richard. It worked for me.

Member 9346617 5-Apr-19 7:08am View

I have the similar challenge. I want to access the shared folder and need to display files within that shared folder which are older than 4 days.
But I can't use net use X: \\192.168.1.X\sharename {password} /USER:username /P:yes command since I can't pass username and password of production server.
Any help is much appreciated.

Member 9346617 5-May-16 0:29am View

Hi,
Below is my code to create, add data to excel & then close the excel via code.
Once it gets generated, I goes to that location & manually opens the excel.
By default the focus is set to last sheet i.e. 4th sheet.

Dim xlApp As Excel.Application = Nothing
xlApp = New Excel.Application()
Dim xlWorkBook As Excel.Workbook
xlWorkBook = xlApp.Workbooks.Add
xlWorkBook.SaveAs("C:\ABC.xlsx")
xlWorkBook.Close()
Dim excel_app As New Excel.ApplicationClass()
Dim workbook As Excel.Workbook = _
excel_app.Workbooks.Open(Filename:="C:\ABC.xlsx")
Dim sSheet_name(4) As String
sSheet_name(0) = "Summary"
sSheet_name(1) = "Original Source"
sSheet_name(2) = "Processed Data"
sSheet_name(3) = "Failed Records"
sSheet_name(4) = "Partial Processed"
For j = 0 To 3
Dim sheet As Excel.Worksheet = FindSheet(workbook, sSheet_name(j).ToString)
' Add the worksheet at the end.
sheet = DirectCast(workbook.Sheets.Add( _
After:=workbook.Sheets(workbook.Sheets.Count), _
Count:=1, _
Type:=Excel.XlSheetType.xlWorksheet), Excel.Worksheet)
sheet.Name = sSheet_name(j).ToString
workbook.Close(SaveChanges:=True)
excel_app.Quit()
xlApp = Nothing

Comments by Member 9346617 (Top 7 by date)