.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

Exporting to PDF causes colors to bleed

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

I have a table with up to 30 columns that I turn visibility to hidden depending on a parameter.  For example if the parameter is 20 only columns 20 and below are shown.  Works a treat except when I export to a pdf and these grey spaces appear at the far right of the report.  The grey is the background color for the heading row and it bleeds down a column/s which would be to the right of the last column if it were shown.  Any ideas.  


View Complete Post

More Related Resource Links

Exporting web from MOSS 2007 to WSS 3.0

Hi! I'm trying to export SharePoint web site from MOSS 2007 to WSS 3.0.

There are some problems, which prevent me. WSS doesn't include two features: DataConnectionLibruary and TransMgmtLib. This features are not avaible on WSS, so I tried to deactivate these features using site capabilities. It wo'nt help. Here is the exception text:

Could not find Feature TransMgmtLib
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.VerifyFeatureDefinition(SPRequirementObject reqObj)
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.Validate(SPRequirementObject reqObj)\
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.DeserializeAndValidate()
at Microsoft.SharePoint.Deployment.SPImport.VerifyRequirements()
at Microsoft.SharePoint.Deployment.SPImport.Run()
at InfoCenter.ConsoleTestingApp.Program.ImportInfoCenter()

The question is: which way must I go to solve this problem? Is it really possible (I mean export from MOSS to WSS)? And what is the purpose of TransMgmtLib feature? Thanks.

Autocomplete Colors



I have a question about the colors of the text in the drop down list of Autocomplete box. I'm trying to categorize them into 2 differents colors. For example, the autocomplete box will display the list of soft drink in the store and the color will identify them as "sold out" or "available".

The data in my database is seperated into 2 columns. The first one is the names of the soft drink, and the second columns identify them as "sold out" or "available.

The autocomplete box was implemented in my website using page method. There is a function in the code behind page, calling data from the web services.

Please let me know if there is any suggestion, guideline or any reference link to the answer of my problems.

Thank you.

Exporting MOSS 2007 List to Excel 2007

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

Giving Custom Colors for Graph values in SSRS2000


Hi All,

        I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.

 Problem Statement : Suppose if i want to display two data fields as bar graph

                                 Data Fields are : Vegetable Count and Fruits Count

                                          I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.

Any help would be appreciated.

Thanks in advance.

Anish Shenoy

Can't change Gridview row colors or styles in the DataBound event


I was highlighting certain rows in my gridview using code like this in the DataBound event:

        if (e.Row.RowType == DataControlRowType.DataRow)
            int vendorCheck = 0;
            //TODO make this shorter
            if (DataBinder.Eval(e.Row.DataItem, "vendorId") != System.DBNull.Value)

Create Colors for columns in Chart , WPF

Hi, How can i dynamically create colors , which i want to asigned to the Columns in a WPF toolkit Chart control. i want the colors, which are suitable to the chart control (like the ones which are by default generated). thanks Naresh

Exporting SharePoint list to excel.

Hi All,   We have a SharePoint list in which one column is "Person or Group" and it can take multiple values. When we export it to spread sheet this column contains some junk data.We are using MOSS 2007 and Office 2007. Previously asked question on the same issue http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/00cc338d-8201-4b8d-b2ea-5979ee58a464 Does any one know of a Microsoft published article for this issue as we need to provide it to our higher ups for this issue.   Thanks.

Exporting a gridview into word landscape

Hi,  I have managed to export a gridview into word but is there a way when i export the gridview into Word that Word opens in landscape? Thanks in advance, Jon 

(SQL Server 2008) Exporting entire databases to SQL CREATE/INSERT statements

Hi All, I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements.  I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task.  However, I'm hoping that this isn't the only way by which to do it.  I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends).  I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary. FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row.  You can image how painful this process is... I realize that there are many tools that do this.  However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups.  Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible. Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated. Best.

Issue while exporting to Excel

Hi All, We are having report in SSRS 2005, everything is working fine while Running the report on BIDS as well as on Report Server, but as soon as we export the report to Excel it is creating issue(S) not just a issue. First - I'm not able to see "Footer" in Excel, although it does exist in BIDS as well as Report Server. It is visible while doing Print-Preview in Excel, why so is it a bug, is their any work around to make it visible without doing Print-Preview, please do let me know! Second - It is regarding "Header", I have couple of text boxes in my Report Header, as soon as I include text boxes in Report Header and when I export to excel, the rows & columns height as well as width is getting disturb (meaning some getting compressed and some getting expanded), so to make it look attractive we have to manually arrange in proper order before delivering to our end-user, Can anybody tell me why rows & columns are getting disturbed and also how to arrange with exact height & width without any manual interpection, please help me out, this is getting me crazy?   Thanks Regards, Kumar

How to customise theme secondary colors?

When editing a theme it is possible to set the primary colors and the secondary colors are auto-generated. Is it possible to customise the secondary colors somehow if I don't like the auto-generated ones?

Gradient Colors in table cell

How to fill the gradient colors in table cells?

Gridview not showing alternate colors

I am trying to make the colors different for every line, so lets say one line white and the next light grey. I tried it in the gridview using autoformatting direct formatting css formatting but it has no effect on the display! The lines are all white! Only formatting to work is the header formatting. Who can help? For CSS, I have<RowStyle CssClass="gridRow" /> <HeaderStyle CssClass="gridHeaderSort" /> <AlternatingRowStyle CssClass="gridAlternateRow" /> and .gridAlternateRow {  background-color: #DCDCDC; /*LightGrey*/  } .gridRow {   background-color: White; } .gridHeaderSort { background-color: #DCDCDC; color: Black; font-weight: bold; text-align: left; }   I tried with every option - without any effect. Visual Studio 2005, IE6. No change in the preview, no change when running. I tried with a font option for the row - this one is evaluated. I tried setting it programmatically - no change.

Blank Pages - When exporting reporting to Adobe Acrobat

I have a report in Reporting Services 2005, when the report is exported to Adobe Acrobat, i keep on getting a blank page between every pages! How do i get rid of them? Thanks

Exporting multiple gridviews in multiple excel tabs

Hi All, I am able to export multiple gridviews in a single excel worksheet My question is can I separate these gridviews in multiple tabs under the same excel file ? This is my current method under the link buttonprotected void lnkExport_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition","attachement;filename=TrendAnalysisRpt"+StoreNum); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); HtmlForm frm = new HtmlForm(); this.grd_Inj.Parent.Controls.Add(frm); this.grdBody_1.Parent.Controls.Add(frm); frm.Attributes["runat"] = "server"; frm.Controls.Add(this.grd_Inj); frm.Controls.Add(this.grdBody_1); frm.Controls.Add(this.grdBody_2); frm.Controls.Add(this.grdBody_3); frm.Controls.Add(this.grdBody_4); frm.Controls.Add(this.grdMonth); frm.Controls.Add(this.grdDay); frm.Controls.Add(this.grdHours); frm.Controls.Add(this.grdLengthOS); frm.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); } Thanks again!    
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