How to print crystal report from web without using ReportViewer

Question

0.00/5 (No votes)

See more:

VS2010

SQL-Server-2008R2

, +

Hello

I had created a web based asp.net project on visual studio 2010 ultimate.
I have crystal reports in my project but I have not used reportviewer to view it.

On clicking on print button, the print dialog box should appear and reports will be printed.

The code that i had written worked fine in my ASP.NET application inside visual studio 2010.

but as soon as i deployed it and uploaded it in server, it showed a error that

Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.

I searched the error in google and came to know that windows dialog box wont work in server.

I am pasting my print code here, can anyone please help me what code to be replaced so that on clicking on print button, print dialog box appears on the server and my reports gets printed.

Kindly please help as its a need.

I always prefer codeproject.com. Here experts are very helpful. I dont have much idea about javascript code or other.

C#

protected void btnPrint_Click(object sender, EventArgs e)
    {
        //  ReportDocument rDoc = new ReportDocument();
        //rDoc.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/SoldCrystalReport.rpt");
        //rDoc.SetParameterValue("@Category", ddlCategory.SelectedValue);
        //rDoc.SetDatabaseLogon("sa", "gariahat");
        //this.crystalReportViewer.ReportSource = rDoc;
        //this.crystalReportViewer.DataBind();
        //this.crystalReportViewer.Focus();
        //rDoc.Refresh();
        //rDoc.PrintToPrinter(1, true, 0, 0);

        ReportDocument rDoc = new ReportDocument();
        PrintDialog dialog1 = new PrintDialog();
        rDoc.Load(Server.MapPath("SoldCrystalReport.rpt"));
        rDoc.SetParameterValue("@Category", ddlCategory.SelectedValue);
        rDoc.SetDatabaseLogon("sa", "gariahat");
        dialog1.AllowSomePages = true;
        dialog1.AllowPrintToFile = false;
        if (dialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
        {
            int copies = dialog1.PrinterSettings.Copies;
            int fromPage = dialog1.PrinterSettings.FromPage;
            int toPage = dialog1.PrinterSettings.ToPage;
            bool collate = dialog1.PrinterSettings.Collate;

            rDoc.PrintOptions.PrinterName = dialog1.PrinterSettings.PrinterName;
            rDoc.PrintToPrinter(copies, collate, fromPage, toPage);
        }
        rDoc.Dispose();
        dialog1.Dispose();

Thanks in advance
Please kindly help

Posted 19-May-15 21:18pm

sudeshna from bangkok

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sid_Joshi · Answer 1 · 2015-05-19T21:44:00

Solution 1

VB

Protected Sub printDiv()
        Dim key As String = "script3"
        Dim cstype As Type = Me.GetType()
        Dim script As String = "<script type=""text/javascript"">" & vbCrLf _
             + "function printDivnew(divID) {" & vbCrLf _
             + "//Get the HTML of div" & vbCrLf _
             + "var divElements = document.getElementById(divID).innerHTML;" & vbCrLf _
             + "//Get the HTML of whole page" & vbCrLf _
             + "var oldPage = document.body.innerHTML;" & vbCrLf _
             + "//Reset the page's HTML with div's HTML only" & vbCrLf _
             + "document.body.innerHTML =" & vbCrLf _
             + """<html><head><title></title></head><body>""" & vbCrLf _
             + "divElements + ""</body>"";" & vbCrLf _
             + "//Print Page" & vbCrLf _
             + "window.print();" & vbCrLf _
             + "//Restore orignal HTML" & vbCrLf _
             + "document.body.innerHTML = oldPage;" & vbCrLf _
             + "}" & vbCrLf _
             + "</script>"
        'ClientScript.RegisterStartupScript(cstype, key, script)
        Me.ClientScript.RegisterStartupScript(cstype, key, script)
    End Sub

Posted 19-May-15 21:44pm

Sid_Joshi

Comments

sudeshna from bangkok 20-May-15 3:46am

Where shall i paste this code? Do i have to make any changes in the code? Where will i put my crystal report name?

Sid_Joshi 20-May-15 3:49am

use this to convert crystal report in html text in a div.
Reportdoc.Value = Server.MapPath("") & "\RPT\PrintClientBrokerageSum.rpt"
Dim orpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument
'Dim reporturl As String = ""
'reporturl = UCase(Mid(rEPORTfILE, rEPORTfILE.LastIndexOf("\") + 2, rEPORTfILE.Length).ToUpper())
orpt.Load(Reportdoc.Value)
orpt.SetDataSource(DtMain)
Dim ReportStream As System.IO.Stream = orpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.HTML40)
Dim bytes(ReportStream.Length) As Byte
ReportStream.Position = 0
ReportStream.Read(bytes, 0, ReportStream.Length)
orpt.Dispose()
DivReportVIew.InnerHtml = Encoding.UTF8.GetString(bytes)
Erase bytes
ReportStream.Flush()
ReportStream.Dispose()
and replace divID with DivReportVIew at above code

sudeshna from bangkok 20-May-15 3:58am

Sorry to say again. I am new to these. How can I use this code to convert my crystal report to html in a div?

Sid_Joshi 20-May-15 4:04am

<div id="DivReportVIew" runat="server">
</div>
add this to your aspx code
the above code will convert crystal report in html text and populates in DivReportVIew div and first code will print div contained html text.

sudeshna from bangkok 20-May-15 4:13am

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="SoldItems.aspx.cs" Inherits="SoldItems" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="crystalReport" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="Server">
<div id="DivReportVIew" runat="server">
</div>
<div class="content">

View Sold Items

<div class="commonFilters">
<div>
<p>
<asp:Label ID="lblCategory" runat="server">Choose By Category :</p>
<asp:DropDownList ID="ddlCategory" runat="server">
<asp:ListItem >Choose Category
<asp:ListItem>Earrings
<asp:ListItem>Pendant
<asp:ListItem>Bangles
<asp:ListItem>Bracelets
<asp:ListItem>Necklace
<asp:ListItem>Toe Rings
<asp:ListItem>Cuff Links
<asp:ListItem>Rings
<asp:ListItem>Sets
<asp:ListItem>Tie-Pin
<asp:ListItem>Brooch

</div>
<div>
<asp:Button ID="btnShow" runat="server" Text="Show" OnClick="btnShow_Click" />
</div>
<div>
<asp:Button ID="btnPrint" runat="server" Text="Print" OnClick="btnPrint_Click" />
</div>
</div>
<div class="searchResults">
<asp:Label ID="lblMessageInfo" runat="server" Font-Bold="true" Font-Size="14px" ForeColor="Red"
Visible="false">
<asp:GridView ID="gvJewellery" runat="server" AllowPaging="false" AutoGenerateColumns="false"
Width="960px" OnRowDataBound="gvJewellery_RowDataBound">
<HeaderStyle BackColor="#207ce5" Height="75px" VerticalAlign="Middle" HorizontalAlign="Center"
Font-Bold="true" />
<columns>
<asp:BoundField DataField="SerialNumber" HeaderText="Serial Number" ItemStyle-Width="75px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="Category" HeaderText="Category" ItemStyle-Width="120px"
ItemStyle-HorizontalAlign="Center" />
<asp:TemplateField HeaderText="Image" ItemStyle-Width="120px" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:Image ID="imgJewellery" runat="server" Height="50px" Width="60px" />

<asp:BoundField DataField="Description" HeaderText="Description" ItemStyle-Width="385px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="CostPrice" HeaderText="Cost Price" ItemStyle-Width="70px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="SellingPrice" HeaderText="Selling Price" ItemStyle-Width="70px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="SoldPrice" HeaderText="Sold Price" ItemStyle-Width="70px"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="Custo

sudeshna from bangkok 20-May-15 4:14am

I have placed the code under Content placeholder. Next what do i do?

Sid_Joshi 20-May-15 4:38am

my code will shows crystal report in DivReportVIew and print this div
without crystal report viewr
keep DivReportVIew empty at design time
crystal report will display in this div at run time.

sudeshna from bangkok 20-May-15 4:46am

I still couldnt understand your solution, I have pasted the 2 lines of div code in one of my aspx page. After that what do i do?

sudeshna from bangkok 20-May-15 5:01am

Can you please explain me step by step what to do?

sudeshna from bangkok 20-May-15 5:01am

Can anyone please help me with a solution? I need help

Sid_Joshi 20-May-15 5:13am

<div>
<asp:Button ID="btnShowReport" runat="server" Text="Show Report" /><br />
<input type="button" value="Print" />
</div>
<div id="DivReportVIew" runat="server">
</div>

Protected Sub btnShowReport_Click(sender As Object, e As System.EventArgs) Handles btnShowReport.Click
Dim dt As New System.Data.DataTable
Dim Reportdoc As String = Server.MapPath("") & "\RPT\PrintClientBrokerageSum.rpt"
Dim orpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument
orpt.Load(Reportdoc)
orpt.SetDataSource(dt)
Dim ReportStream As System.IO.Stream = orpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.HTML40)
Dim bytes(ReportStream.Length) As Byte
ReportStream.Position = 0
ReportStream.Read(bytes, 0, ReportStream.Length)
orpt.Dispose()
DivReportVIew.InnerHtml = Encoding.UTF8.GetString(bytes)
Erase bytes
ReportStream.Flush()
ReportStream.Dispose()
printsetting()
End Sub

Public Sub printsetting()
Dim key As String = "script3"
Dim cstype As Type = Me.GetType()
Dim script As String = "<script type=""text/javascript"">" & vbCrLf _
+ "function printDivnew(divID) {" & vbCrLf _
+ "//Get the HTML of div" & vbCrLf _
+ "var divElements = document.getElementById(divID).innerHTML;" & vbCrLf _
+ "//Get the HTML of whole page" & vbCrLf _
+ "var oldPage = document.body.innerHTML;" & vbCrLf _
+ "//Reset the page's HTML with div's HTML only" & vbCrLf _
+ "document.body.innerHTML =" & vbCrLf _
+ """<html><head><title></title></head><body>""" & vbCrLf _
+ "divElements + ""</body>"";" & vbCrLf _
+ "//Print Page" & vbCrLf _
+ "window.print();" & vbCrLf _
+ "//Restore orignal HTML" & vbCrLf _
+ "document.body.innerHTML = oldPage;" & vbCrLf _
+ "}" & vbCrLf _
+ "</script>"
'ClientScript.RegisterStartupScript(cstype, key, script)
Me.ClientScript.RegisterStartupScript(cstype, key, script)
End Sub

sudeshna from bangkok 20-May-15 5:16am

Thank you for the detailed answer, one last thing shall i create a new aspx page and paste the div code there?

sudeshna from bangkok 20-May-15 5:32am

My project code is in c#

Sid_Joshi 20-May-15 5:35am

use http://converter.telerik.com/ to convert code

Sid_Joshi 20-May-15 5:48am

protected void btnShowReport_Click(object sender, System.EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
string Reportdoc = Server.MapPath("") + "\\RPT\\PrintClientBrokerageSum.rpt";
CrystalDecisions.CrystalReports.Engine.ReportDocument orpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
orpt.Load(Reportdoc);
orpt.SetDataSource(dt);
System.IO.Stream ReportStream = orpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.HTML40);
byte[] bytes = new byte[ReportStream.Length + 1];
ReportStream.Position = 0;
ReportStream.Read(bytes, 0, (int)ReportStream.Length);
orpt.Dispose();
DivReportVIew.InnerHtml = System.Text.Encoding.UTF8.GetString(bytes);
bytes = null;
ReportStream.Flush();
ReportStream.Dispose();
printsetting();
}

public void printsetting()
{
string key = "script3";
Type cstype = this.GetType();
string script = "<script type=\"text/javascript\"> \n function printDivnew(divID) { \n"
+ "//Get the HTML of div \n"
+ "var divElements = document.getElementById(divID).innerHTML; \n"
+ "//Get the HTML of whole page \n"
+ "var oldPage = document.body.innerHTML;\n"
+ "//Reset the page's HTML with div's HTML only \n"
+ "document.body.innerHTML =\n"
+ "\"<html><head><title></title></head><body>\" \n"
+ "divElements + \"</body>\"; \n"
+ "//Print Page \n"
+ "window.print();\n"
+ "//Restore orignal HTML \n"
+ "document.body.innerHTML = oldPage;\n"
+ "}" + "</script>";
//ClientScript.RegisterStartupScript(cstype, key, script)
this.ClientScript.RegisterStartupScript(cstype, key, script);
}

sudeshna from bangkok 20-May-15 5:46am

ReportStream.Read(bytes, 0, ReportStream.Length);

error coming in this line and on the word Encoding
and error on the word Constants. it tells the word Constants does not exist in the current context

Sid_Joshi 20-May-15 6:03am

did u changed PrintClientBrokerageSum.rpt to ur report file name
and DataTable filled with data or not?

sudeshna from bangkok 20-May-15 6:06am

Oh i have named my report file name inside the double quotes after Server.Mappath

and your html code i pasted on a new aspx file, it says put the buttonshow inside form tag under runat server

sudeshna from bangkok 20-May-15 6:07am

and my datatable has data

sudeshna from bangkok 20-May-15 6:22am

can you send the html code to paste in aspx page, as the code you have given error coming, saying buttonshow should come under form tag under runat=server

Sid_Joshi 20-May-15 6:31am

sudeshna from bangkok 20-May-15 6:34am

string Reportdoc = Server.MapPath("SoldCrystalReport.rpt") + "\\RPT\\PrintClientBrokerageSum.rpt"

Is this correct? I have put crystal report name inside the server.mappath

Sid_Joshi 20-May-15 6:44am

string Reportdoc = Server.MapPath("") + "\\SoldCrystalReport.rpt"
concentrate on .rpt

sudeshna from bangkok 20-May-15 6:49am

yes I changed the way you mentioned. at runtime when i am clicking on show report, error coming cant load report. this I am doing from my local machine

Will this code work on server? I mean my project is live,

sudeshna from bangkok 20-May-15 7:02am

this error coming after i have given double slash "\\SoldCrystalReport.rpt"
Error in File SoldCrystalReport {89DB8975-B569-4C5A-81D3-78F821EE368E}.rpt:
Invalid group condition.

Sid_Joshi 20-May-15 7:14am

chk ur crystal report's sql query in sql management studio.

sudeshna from bangkok 20-May-15 7:29am

i have checked its stored procedure

Sid_Joshi 20-May-15 7:42am

mail me ur project

sudeshna from bangkok 20-May-15 7:41am

USE [DB3184_InventoryDatabase]
GO
/****** Object: StoredProcedure [dbo].[spGetJeweleryOnSoldItems] Script Date: 20/05/2015 19:47:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <author,,name>
-- Create date: <create date,,="">
-- Description: <description,,>
-- =============================================
ALTER PROCEDURE [dbo].[spGetJeweleryOnSoldItems]
-- Add the parameters for the stored procedure here
@Category varchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT SerialNumber, Category, [Description], [Image], CostPrice, SellingPrice, SoldPrice, CustomerName, SoldDate
FROM dbo.tblInventory
where Category = @Category AND IsSold = 'True'
END

this is the query on my sql management studio

sudeshna from bangkok 20-May-15 9:17am

send me your email id

Sid_Joshi 20-May-15 9:21am

sidjoshi12@gmail.com

sudeshna from bangkok 20-May-15 9:35am

I have sent you.kindly check and please help me

sudeshna from bangkok 20-May-15 12:29pm

did you find any solution? can you tell me please the solution?

sudeshna from bangkok 20-May-15 12:29pm

Can anyone else tell me please a solution? i need it urgency