Is there any way to solve (by coding) if there comes extra columns in excel sheet at the time of downloading.
if (repDS.Tables[0].Rows.Count > 0)
{
Rpt.Load(Server.MapPath(ReportPath));
Rpt.SetDataSource(repDS);
pnlReport.Height = 500;
CrystalReportViewer1.ReportSource = Rpt;
CrystalReportViewer1.DataBind();
}
I'm having issues using the Print/Export functions from the CrystalReportViewer toolbar in Visual Studio 2005. In some cases, the print/export dialog window is simply replaced with the report page, instead of exporting/printing the data. Based on a dropdown box, the Report Document is loaded with a different report file:
If ddReport.SelectedValue = "Report-1" Then rptDoc1.Load(Server.MapPath("/Reports/Report1.rpt"))Else rptDoc1.Load(Server.MapPath("/Reports/Report2.rpt"))End If
I want to give the manul expot option for export the crystal report to excel .
View 1 RepliesI want to export dataset to Excel. I did the following ways:
1) bind a dataset to a crystal report,
2) export crystal report to Excel Can it be done without displaying crystal report and only Excel file? Or, I have to find out a way export to Excel directly from dataset?
after export the report to as excel file,i tried to edit in values of legend but no affect occurs in corresponding value on chart this method can be done in excel,i tried to do this issue after exporting as excel but it is image ,i tried but all in vain
how can i edit in this exported excel file from crystal report in legend values then correlated values on chart affect?? how?
How can i export the data in an exel file in to my DB(sql) table . How can i do this using C# code
View 4 RepliesI'm exporting report to excel using (crystal report built in export option),
the result of excel file is not in proper alignment.. the lines boxes are not showing in excel file
How to export with proper alignment to excel with line boxes etc... which shown in output of crystal report
When i export crystal report (table formtatted) to excel (using in web app) and see the output than i dont get column and row lines i mean My data comes in table format but without column and row lines. Can anyone pl guide me on this? What should i do to get proper format like present in crystal report.
View 1 RepliesIt's been a while since I've posted here, but I do have a vexing question. I have an export to Excel that is working just fine with the exception that I have one blank line at the top of my export and one blank line at the bottom of my export. All paging and sorting are turned off at this point, so I'm really not sure where these empty lines are coming from. They appear above the header row and below the last row of data, almost like there's an invisible line that gets created after the data makes it to Excel.
View 6 RepliesI'm puzzled by this predicament that I'm in right now. I developed a simple application in ASP.NET 2.0 using Visual Studio 2005 and Crystal Reports that came with VS2005. My code works and displays the report correctly with the data on my desktop but when I copy it to the production server to deploy it, everything else runs except for the report which only displays a blank screen.
I've installed Crystal Reports on the server, the IIS setting has the correct ASP.net Framework version. When I view the source on the blank report, it is pointing to the correct path for all the Crystal Reports scripts and images.
[Code]....
I have an web application with crystal report. The report are printing fine. But the problem is
i have applied page margin setting as
Top Margin 0.25 in
Left Margin 0.02 in
Bottom Margin 0.17 in
Right Margin 0.42 in
all are fine without Bottom Margin. Bottom Margin will come with more space without considering 0.17 in. I think that it may be happened that the detail section i have a rectangle box object. Inside this box have data from data base. I want to print this box as 3 times in a page with three records. all are fine.I adjested maxium to fit the box in details section to dispaly three times in a page. But when i wil get the print out the three box will come with 3 times. But after the three rectangle box ,the footer of the page will take some extra space.
I don't want to print pagefooter,page header,report header, report footer at all. i am suppressed these things.
I want to know why it is came with some more space on the footer.?
How to solve the issue?
And tell me the C#.Net code for pageHeader Suppress,report header suppress,report footer suppress,page footer
I am developing web application using csharp on visual studio 2008.I am able to generate reports, but I want just to export or generate reports in pdf only. How can I achieve this? The code I am using is below. But it is not working.
[Code]....
The code for report
[Code]....
I have a gridview containing 10 columns. Three of them are set to visible="false' by default. When I click on 'Export to excel' Button, I can hide those invisible columns.
[Code]....
There must be more efficient way than this. How can I find the invisible columns and store their information in array and then only do a loop once?
how to export only a subset of columns from Gridview to excel? i'm sure there are examples online, but have not been able to get the right kinda examples.
View 1 RepliesI'm trying to find a code to delete multiple columns because when you delete a column the next column takes his place so for example:
If you delete column 6 then column 7 becomes column six.
I tried the following code with an for loop & a while loop:
Dim field As DataControlField = gv.Columns(i)
gv.Columns.Remove(field)
&
gv.columns.removeat(i)
But same case that the column 7 becomes column 6
The variable removeColumns is an array with the column number that need to be deleted.
If wanted I can also provide the Header Names
[Code]....
know diff between exporting in microsoft excel(97-2003) and microsoft excel(97-2003) data only.
View 1 RepliesMy hosting provider has ASP.NET 3.5 and I'm using MVC 2.0. I have two domains on my account, [URL], and [URL], each has it's own virtual directory off of the root:
/
/domainone
/domaintwo
Their routing commands for their httpd.ini rerouts [URL]to [URL] If I type in the address bar [URL], it works properly. The Problem My website links created using Html.ActionLink add the virtual directory. If you mouse over the About link in your standard MVC2.0 webapp, it displays as follows: [URL]
All of my testing and setup on my development machine doesn't have this virtual directory, and in the past my webhost didn't have this issue in the path. But since the move to their 'new' shared hosting platform, this is now what I'm having to deal with. How do I setup my ASP.NET MVC 2.0 web application to remove the unwanted virtual directory name from the path in my ActionLink controls?.....
I have written an article about How to create a Crystal Reports invoice and export it as PDF
View 1 RepliesI have a report that I need to export to a txt file for EDI import. It adds extra blank lines at the bottom. This report is 1 line of text in the report footer. Any way to remove the extra lines that the export produces?
View 6 Repliesthough paramerter in crystal report with stored procedure
View 1 RepliesHow to display more than 20 columns in a crystal report.
In .Net Crystal report how can I display over 20 columns? I can use not more than 10 columns.
I'm using CR that included in VS 2005. I have a Dataset of Phone Extenions that I pass to Crystal Reports then exports it to a PDF for printing.
View 9 RepliesWhen i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 RepliesEverythings working fine on my PC but when I deployed my application on server, Print and export are not working. Even the toolbar images were not displaying on the report. So I added them manually to my application.
Is there some folder missing?
I am exporting crystal report into html format and sending the html file via email (HTML EMAIL) in the body of text.The problem is while the receiver forwarded the email to any other person, the email content get distrubed and format of the report became tollay wrong.Also when I tried to send the report to GMAIL account, the gmail account is not displaying format properly.I report this issue in the asp.net crystal report forum perviously also.crystal report export to HTML Format issue when forwarding email to other person
View 3 Replies