.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Problem to display DBCS when exporting to PDF

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server
Hi, I have created a report but when exporting to PDF I get "????" ____ characters, anyone has any ideas?

View Complete Post

More Related Resource Links

Session problem with display of image in row of reportviewer


Hello techies...

I am new to this sql reporting service. But anyhow by surfing I am able to bind the report but i was stuck in image display.

Anyways, i also managed that. But the real problem is whenever i was keeping a image control in rdlc report i was having session prob. If i remove the image control then as usual report works fine.

Please suggest me some solution.... either for session problem or for image display. I am keeping the image name in database but for binding the rdlc report i am using a store procedure which return the path (static) concating with the image name(kept in database).

Hope to find a solution .....

[VS2008] Designer's display problem

Hello, I created a solution with multi-project and i've recently added some resources files to lacalized my application and of course my XAML files too. I used the "How To:" http://msdn.microsoft.com/en-gb/library/dd882554(v=VS.95).asp I inserted the class LocalizedString in one off my project that I use as library for common actions. But since, my designer is not loading properly because it can't find this class while I precised the good assembly and that the application is running properly with resources applied. It's then not handy to develop an HMI... If anybody has an idea about this trouble... Of course I tried dozens of times to clear the projects and regenerate without success. Thank you for your help !

Problem with GridView display

I have a calendar control where a user selects a date and then inputs info into a FormView control. Underneath the FormView is a GridView that shows all data from the SelectedDate on the calendar control. However, when the date is selected, all the information from the table ( from all dates ) is displayed. Any ideas on why? Code is below and thanks:<asp:Calendar ID="calendarInstallDate" runat="server" BackColor="White" BorderColor="Black" DayNameFormat="Shortest" Font-Names="Times New Roman" Font-Size="10pt" ForeColor="Black" Height="220px" NextPrevFormat="FullMonth" TitleFormat="Month" Width="400px" onselectionchanged="calendarInstallDate_SelectionChanged" > <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" ForeColor="#333333" Height="10pt" /> <DayStyle Width="14%" /> <NextPrevStyle Font-Size="8pt" ForeColor="White" /> <OtherMonthDayStyle ForeColor="#999999" /> <SelectedDayStyle BackColor="#CC3333" ForeColor="White" /> <SelectorStyle BackColor="#CCCCCC" Font-Bold="T

SSRS Report Problem while Exporting into PDF

We are trying to generate a report in SSRS 2005 with Landscape  layout. The report if fine but when we export it into PDF format the result comes in 2 pages that is fine but there is an image in the footer which is only displaying in the last page of the report footer the text fileds are fine only image is not displaying in every page while exporting. Please guide.............

problem with dimenssion Display Values



I Have built a cube and deploy it to 2008 Olap Server.  the dimenssion data looks great .

while deploying the same cube / project to another server (2005 server) the dimenssion data

displayed ?????????????? instand of the correct value. the correct value is in hebrew language.

i check the collation in 2005 server and it support Hebrew Language.

what can be the reason to that?


Win7, IE8 display formatting problem


We only have one Win7 box in the company and it does not want to display our sharepoint 2003 pages correctly. It’s not consistent either, some times it will load correct and other times it won’t. When it’s working right, the pages load quickly, when its not, the pages load real slow or not at all. When they don’t load correct, it’s like the CSS or something along them lines is messed up. The colors are not correct, the text is larger and not where it should be.


The Win7 box has all the latest updates. I’m not sure what patch level the server and sharepoint are at, I don’t manage them myself.

Problem in display Full Name after logged in (Session Problem)


After login, i have create a session to display the Username of the logged user, however instead of display the Username, i want to display the Full_Name of the logged user

However i have no idea how it dones....Kindly if you could help me in giving suggestion / ideas. Thank you.

PersonUser Table

P_ID (PK)   =1

Username =lucy88

Password =88ycul

Full_Name = Lucy

User_Type =Admin

Login.aspx - as i do session, it will display lucy88 however i would like to display Full_Name which is Lucy.


    protected void Button1_Click(object sender, EventArgs e)
        SqlDataSource sds = new SqlDataSource();
        sds.ConnectionString = ConfigurationManager.ConnectionStrings["MyDB"].ToString();
        sds.SelectParameters.Add("Username", TypeCode.String, this.TextBox1.Text);
        sds.SelectParameters.Add("Password", TypeCode.String, this.TextBox2.Text);

        sds.SelectCommand = " SELECT * FROM [PersonUser] WHERE [Username] = @Username AND [Password] = @Password";
        DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty);

        if (dv.Count

Reporting Services 2008 - footer problem when exporting to Word


I have a footer that I want to show up on the last page only. 

I use the following expression for the text box under text box properties --> visability

=IIF(Globals!TotalPages = Globals!PageNumber,

False, True)

When I run the report in reporting services, it does only print the footer on the last page.  When exported to Word, footer prints on all pages.

My questions: 

1.  Is my expression ignored in Word for the footer, so I will not be able to do this in the footer?

2.  Is there another way to have something print at the bottom of the last page that will be recognized when exported to MS Word (report size will vary based on data returned)? 

Any help is appreciated.

Kind regards.

Message Display Problem



I am facing a  strange problem .i use following code for show successfully message to user.so it is working fine but problem is when I go another page and came back same page again  through  browser back button again successful message display.

For example suppose there are two page i.e one.aspx nad two.aspx.  i  save one.aspx record then message display me that "Record Insert Sucessfully!!" then I go to two.aspx and when I came back again one.aspx by browser back button again same message are display again

please someone help me.

Script for message

ClientScript.RegisterStartupScript(Me.GetType(), "alert", "<script language='javascript'>alert('Record Updated Sucessfully..')</script>")

Use like

Public Sub SAVEDATA()



            MYTRANS = myConnection.BeginTransaction()






Problem with Exporting RDLC to PDF while Using Unicode(Marathi)


I Have An RDLC Report in ASP.net 2.0  Application.and SQl Server2008

I have installed IndicaIME for Marathi for unicode.

When I export It in to PDF that will not display correct (Word In Marathi Format)  I USe Ariel Unicode Font
But it  will show some  extra character display with word

e.g Instead of displaying "Kishor" it will display "kshir" in marathi
What I have do ? For that just give link or code To export RDLC report in PDF ?

Exporting SharePoint profile picture to ActiveDirectory thumbnailPhoto attribute problem!



I am trying to export SharePoint profile Picture to ActiveDirectory thumbnailPhoto attribute.  Here's what I did so far :

  • FIM account has Replicating Directory Changes, Read and Write permissions on the users OU
  • Central Administration -> Manage service applications -> User Profile Service Application -> Manage User Properties -> Picture -> Edit -> Add New Mapping -> AD - thumbnailPhoto - export
  • Start Profile Synchronization
  • Result :

Stage SharePoint Server export
Additions 0
Updates 0
Unchanged 0
Successes 0
Failures 0

I have then found on the Internet that since My Sites are in https, I have to load the root certificate in SharePoint.  I use a "GeoTrust DV SSL CA" for My Sites so I have downloaded the GeoTrust_Global_CA.cer root certificate from GeoTrust and did the following :

  • Central Administration -> Security -> Manage Trust -> New -> GeoTrust - GeoTrust_Global_CA.cer
  • Result :

The Root Certificate that was just selected is inv

datetime problem when save into table, doesn't display currentdate


I have a gridview. in this gridview, I can checked a row to select the row. And I can save the row into database. I also have datetime (current date) and idsubject 
out of this gridview. I want to save date and idsubject in database, simultanously with save the checked field in gridview. I write the following code
and can save all three of them. But I have problem with the date. it doesnt save the current date, instead it appears 01/01/00 0:00:00 in table.
I dont know what is the problem.


I have a gridview. in this gridview, I can checked a row to selec

I've got a SplitContainer with a second SplitContainer in the right panel - Display problem

The second SplitContainer does not display at all. However, if I put something else, say a Button, in that panel, it displays without problems.

Problem in Date Format While Exporting To Excel Destination From Flat File Source In SSIS



I have a flat file(.csv) which contains data(strings incuding date in yyyy-mm-dd format).This i am using in Flat File Source and want to export those data to an Excel Destination.Before exporting to Excel Destination i have created a Derived Column component where i am using an express to get day,month,year part and creating a date sting in dd/mm/yyyy format then conveting it to DT_DATE datatype and then exporting to Excel Component.But while exporting to Excel this date format is getting changed to mm/dd/yyyy format.

The expression i used in derived column is

(DT_DATE)(SUBSTRING(date,9,2) + "/" + SUBSTRING(date,6,2) + "/" + SUBSTRING(date,1,4))

where date is a column from Flat File Source.

Even I changed the Locale to English(United Kingdom) in Flat File Connection Manager for the above .csv file.But still it didnt work.

I searched a lot in google and failed to get any solution on this.

Can anyone help me in solving this issue ?

GridView inline Master/Detail record display

This code drop is part of a smash and grab series. If you're in a rush, you can just grab this code and insert it into your application, no understanding is required. When you have some time (ya, right) you may want to review the source code.

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Display data in gridview dynamicallay

I have AD domain which has 100000 users, I want to display all the users in gridview controls.Actually it is displaying users in gridview after parsing entire domain which takes around 30 min. I want to display the users while loading itself.It is continously getting user information from AD domain and getting each user details, I want to display the users information which already queried instead of waiting till getting all users information
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend