Crystal Reports

Printing Multiple Copies of a Report

stretcher25 — Mon, 23 Nov 2009 02:15:30 GMT

I am using ASP.NET VB code using the Crystal ReportsCrystalReportViewer on my aspx page. Everything works fine, I'm trying to print multiple copies of my report. I see that PrintToPrinter used to be what people use to tell how many copies to print. I'm using Visual Studio 2008 and it does not work. How can I print multiple copies using code?

Thanks

Can we suppress linked subreport parameters when main report returns no rows

sonaasp — Thu, 12 Nov 2009 08:26:24 GMT

Hi All

I am using .net 3.5 framework.I have a main report and 3 linked subreports.In the main report I have a WOID that WOID i am linking with all three supreports. So In the three subreports i have parameters like "Pm-dtwostatusreport.WOID". My problem is.....

If my main report does not return any rows. how to handle with the subreports parameters?????????????when I run the report it asking for "Pm-dtwostatusreport.WOID in subwoassignmentdetails: Pm-dtwostatusreport.WOID " This is nothing but the subreport parameters. I am bit confused how to handle this. Can we suppress the subreport parameters when the main report returns no rows. Please help...

crystal reports load fail IIS7

sryan@seewolf.com — Sat, 21 Nov 2009 23:09:45 GMT

i have a lot of cr2008.net (from VS2008) that run fin on my vista development machine

When i publish to the Windows 2008 X64 server - i get a report failed to load error.

I have the right merge modules on the machine

error messages that i receive are...

Log Name:      Application
Source:        ASP.NET 2.0.50727.0
Date:          11/20/2009 7:05:03 AM
Event ID:      1309
Task Category: Web Event
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      vvvvvvvv.com
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/20/2009 7:05:03 AM
Event time (UTC): 11/20/2009 2:05:03 PM
Event ID: 23dfe435799846418a1fdd99fb3a8dec
Event sequence: 50
Event occurrence: 2
Event detail code: 0

Application information:
    Application domain: /LM/W3SVC/2/ROOT-1-129031985578620356
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\inetpub\vvvvvvvvv\
    Machine name: SWCVI1

Process information:
    Process ID: 1248
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
    Exception type: CrystalReportsException
    Exception message: Load report failed.

Request information:
    Request URL: https://172.16.0.105:443/vvvvvvvv.aspx
    Request path: /CheckOut/frmOrderInvoice.aspx
    User host address: 172.16.0.106
    User:vvvvvvvv.com
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
    Thread ID: 5
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)
   at frmOrderInvoice.GetEmailNotification() in C:\inetpub\CVIPhase4\Checkout\frmOrderInvoice.aspx.vb:line 444
   at frmOrderInvoice.Page_Load(Object sender, EventArgs e) in C:\inetpub\CVIPhase4\Checkout\frmOrderInvoice.aspx.vb:line 113
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="ASP.NET 2.0.50727.0" />
    <EventID Qualifiers="32768">1309</EventID>
    <Level>3</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-11-20T14:05:03.000Z" />
    <EventRecordID>1002</EventRecordID>
    <Channel>Application</Channel>
    <Computer>vvvvvvvvv.com</Computer>
    <Security />
</System>
<EventData>
    <Data>3005</Data>
    <Data>An unhandled exception has occurred.</Data>
    <Data>11/20/2009 7:05:03 AM</Data>
    <Data>11/20/2009 2:05:03 PM</Data>
    <Data>23dfe435799846418a1fdd99fb3a8dec</Data>
    <Data>50</Data>
    <Data>2</Data>
    <Data>0</Data>
    <Data>/LM/W3SVC/2/ROOT-1-129031985578620356</Data>
    <Data>Full</Data>
    <Data>/</Data>
    <Data>C:\vvvvvvvvv\</Data>
    <Data>SWCVI1</Data>
    <Data>
    </Data>
    <Data>1248</Data>
    <Data>w3wp.exe</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>CrystalReportsException</Data>
    <Data>Load report failed.</Data>
    <Data>https://172.16.0.105:443/vvvvvvvvvvv.aspx</Data>
    <Data>/CheckOut/vvvvv.aspx</Data>
    <Data>172.16.0.106</Data>
    <Data>vvvvv</Data>
    <Data>True</Data>
    <Data>Forms</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>5</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>False</Data>
    <Data>   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)
   at frmOrderInvoice.GetEmailNotification() in C:\inetpub\CVIPhase4\Checkout\frmOrderInvoice.aspx.vb:line 444
   at frmOrderInvoice.Page_Load(Object sender, EventArgs e) in C:\inetpub\cccccc.aspx.vb:line 113
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
</Data>
</EventData>
</Event>

and

Log Name:      Application
Source:        ASP.NET 2.0.50727.0
Date:          11/20/2009 6:57:35 AM
Event ID:      1309
Task Category: Web Event
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      xxxxx.com
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/20/2009 6:57:35 AM
Event time (UTC): 11/20/2009 1:57:35 PM
Event ID: 16f190580d0e45d4825430fb9a1e958c
Event sequence: 46
Event occurrence: 1
Event detail code: 0

Application information:
    Application domain: /LM/W3SVC/2/ROOT-1-129031985578620356
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\inetpub\CVIPhase4\
    Machine name: SWCVI1

Process information:
    Process ID: 1248
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
    Exception type: CrystalReportsException
    Exception message: Load report failed.

Request information:
    Request URL: https://172.16.0.105:443/xxxxxxx.aspx
    Request path: /CheckOut/xxx.aspx
    User host address: 172.16.0.106
    User: xxxx    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
    Thread ID: 6
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)
   at frmOrderInvoice.GetEmailNotification() in C:\inetpub\CVIPhase4\Checkout\frmOrderInvoice.aspx.vb:line 444
   at frmOrderInvoice.Page_Load(Object sender, EventArgs e) in C:\inetpub\CVIPhase4\Checkout\frmOrderInvoice.aspx.vb:line 113
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="ASP.NET 2.0.50727.0" />
    <EventID Qualifiers="32768">1309</EventID>
    <Level>3</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-11-20T13:57:35.000Z" />
    <EventRecordID>1001</EventRecordID>
    <Channel>Application</Channel>
    <Computer>xxx.com</Computer>
    <Security />
</System>
<EventData>
    <Data>3005</Data>
    <Data>An unhandled exception has occurred.</Data>
    <Data>11/20/2009 6:57:35 AM</Data>
    <Data>11/20/2009 1:57:35 PM</Data>
    <Data>16f190580d0e45d4825430fb9a1e958c</Data>
    <Data>46</Data>
    <Data>1</Data>
    <Data>0</Data>
    <Data>/LM/W3SVC/2/ROOT-1-129031985578620356</Data>
    <Data>Full</Data>
    <Data>/</Data>
    <Data>C:\inetpub\xxxx\</Data>
    <Data>SWCVI1</Data>
    <Data>
    </Data>
    <Data>1248</Data>
    <Data>w3wp.exe</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>CrystalReportsException</Data>
    <Data>Load report failed.</Data>
    <Data>https://172.16.0.105:443/CheckOut/frmOrderInvoice.aspx</Data>
    <Data>/CheckOut/frmOrderInvoice.aspx</Data>
    <Data>172.16.0.106</Data>
    <Data>xxxx</Data>
    <Data>True</Data>
    <Data>Forms</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>6</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>False</Data>
    <Data>   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)
   at frmOrderInvoice.GetEmailNotification() in C:\inetpub\CVIPhase4\Checkout\frmOrderInvoice.aspx.vb:line 444
   at frmOrderInvoice.Page_Load(Object sender, EventArgs e) in C:\inetpub\CVIPhase4\Checkout\frmOrderInvoice.aspx.vb:line 113
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
</Data>
</EventData>
</Event>

cusrtomize crystal reports

coolvaas1 — Fri, 20 Nov 2009 20:09:35 GMT

In my web page I have added a crystal report viewer to display reports. Now I want to customize the controls using code.

1. Disable the Group tree

2. In the export options remove everything except export to pdf

I am not sure how to do this. Could someone help please? Any help is greatly appreciated.

how to use image instead of text in crystal report

girish dagdiya — Thu, 19 Nov 2009 11:47:18 GMT

hi,

I want to use image in crystal report instead of text, and that text is coming from database.

eg: I want to show image1 when text in database field is 'Complete',

and image2 when text in database field is 'Incomplete',

and image3 when text in database field is 'Cannot say'

Crystal Reports in asp.net

Mohd Ali Keerio — Fri, 20 Nov 2009 11:21:31 GMT

I am new to learn asp.net and i want to Create Reports in asp.net how i can create Reports in asp.net Provide me Basic please

The report you requested requires further information

airedwin — Fri, 15 Sep 2006 13:05:52 GMT

how do i get the report to work correctly without giving this message and login prompt?

i searched the threads and i saw this a few times but i haven't actually seen a real solution

ii have a reportviewer and a reportsource

<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True"

Height="50px" ReportSourceID="CrystalReportSource1" Width="350px" />

<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">

</Report>

</CR:CrystalReportSource>

and the crystalreport2.rpt i have it set to an ado.net dataset

Passing a parameter to a crystal report

wop_nuno — Wed, 18 Nov 2009 17:00:32 GMT

Hi everyone,

I'm trying to do a thing that is problably quit simple, but i'm having an hard time.

I have a page where lot's of records are shown in a gridview. In this gridview i have a column called "Details", so when the user clicks on it, it redirects to an other page that shows the details of this record. It passes a parameter called "id".

Until here it works fines.

Now i want to print this information, whic is a web form, and since i was having a hard time to do this, i decided to use a crystal report.

So what i would like to do is, at the end of the web form, have a button called "Print", that when the user clicked it would show the report. The values on the report would be the same has the form, because the value of the parameter would be the same.

Also if someone could explain me, how i can make dissapear the initial autentication of the crystal report, i would really aprreciate.

Thanks in advance.

Displaying Multiple Groups in one report using multiple DataSets

ProgrammingFreak — Wed, 11 Nov 2009 19:52:49 GMT

Hi,

I am new to Crystal Reports, So far I have created simple ones.

My Problem is that:

I have a web-page (aspx) which have four sections, 3 of them have grid and one have some textboxes/labels. There are four DataSets (or you can say DataTables, because each dataset has one DataTable), that are used to display data on this web-page. 3 DataSets are bound to grid and one dataset (or DataTable) have only one row which is displayed in Textboxes and Labels.

My task is to create same kind of 'report' in Crystal Report (100% deto-copy). I want to know that how I can add multiple grids (detail sections) in crystal report and bind with seperate dataset/datatable ?

I really need this help urgently....

Waiting for Crystal Reports Masters........

table 'usp_rpt_XXXX;1' could not be found getting error -VS2005 + Crystal Report

diadem_2k — Thu, 19 Nov 2009 14:56:44 GMT

I started getting error recently and the wired thing is, it works fine on development and production but failing in staging environment.

Whenever i try to run the crystal programmatically from ASP.NET (C#) to get the PDF and save it on a specific location, I get this error ONLY on Staging environment:
==================================================================================
MESSAGE: The table 'usp_rpt_XXXX;1' could not be found.
Error in File C:\WINDOWS\TEMP{EEE89874-2169-45CE-819E-9D145459E9B2}.rpt:
The table could not be found.

SOURCE: RptControllers.dll
=====================================================================================
I am confused where it is failing. I am using CrystalDecisions.CrystalReports.Engine; and its corresponding code that we got... thing is it works fine in DEV and Prod ... but started getting errors in staging more recently...

I was trying to analyze this from last 24 hours but getting no ideas??? could you please help me out by giving some ideas where exactly i need to look for the problem.

Before it was working fine on all the environments suddenly it started throwing errors on staging environment....

Thanks a lot in advance.

Crystal Access Denied, Failed to Load the report

jackie_sean — Thu, 19 Nov 2009 18:22:23 GMT

I've been pulling my hair trying to figure out what's going wrong but with no result.

Project started long time ago in VS 2005 Pro, now I want to add some Crystal Reports so I just went on my dev machine and add a report, write a page to load the report and display it in browser. This is where it breaks, System.Runtime.InteropServices.COMException: Access is denied.

rep = New ReportDocument

rep.Load(Server.MapPath("SampleRpt01.rpt"))

All I have here is a page.aspx, page.aspx.vb and a SampleRpt01.rpt.

If I move these pages into a new folder RepFolder outside of my project and I create a virtual folder on RepFolder (including a web.config for adding Crystal references) everything would work perfect, data is loaded and displayed on the report.

Why doesn't work when included in my other project ???

Consider that I have re-created a new virtual folder MyNetProject and upload my existing project on it, just to make sure no permissions are missing and still doesn't work.

What I mean is: create 2 virtual IIS folders, one pointing on my older project, the other one pointing on RepFolder.

RepFolder will display the report but the other one will come up with: System.Runtime.InteropServices.COMException: Access is denied. That is also "Failed to Load the report" error or something similar.

Thanks

I've been pulling my hair trying to figure out what's going wrong but with no result.

rep = New ReportDocument
rep.Load(Server.MapPath("SampleRpt01.rpt"))

All I have here is a page.aspx, page.aspx.vb and a SampleRpt01.rpt.

Why doesn't work when included in my other project ???

Consider that I have re-created a new virtual folder MyNetProject and upload my existing project on it, just to make sure no permissions are missing and still doesn't work.

What I mean is: create 2 virtual IIS folders, one pointing on my older project, the other one pointing on RepFolder.

Thanks

Crystal report in lanscape

DesertRose83 — Thu, 19 Nov 2009 04:44:04 GMT

Hi All,

How can I show a crystal report in landscape mode. I can print it in landscape mode, but I also have to view this as landscape. any help really appreciated

Unbound Fields in Crystal Reports

sepid — Mon, 16 Nov 2009 18:37:00 GMT

Hi,

Could You please recommend me any code tutorial (video or text ) about Unbound fields in crystal report.

Thanks in advance,

Sepid

Passing String Date to Stored Procedure from C# Web Page

ssstars — Fri, 09 Oct 2009 02:12:17 GMT

Help! Pleeeeeeese! Okay, I have been struggling with passing parameters to Crystal Report.

Here is the situation...
My report is using a simple stored procedure that needs two variable as input parameters ("@FROMDT" and "@TODT")
The report runs without problems with I enter the parameters MANUALLY - It's run without problems in Crystal Reports OR if I run it via Button1_Click on my Web page (and when prompted... @FROMDT = 01/01/2009 and @TODT = 10/01/2009) Note the dates are NOT within quotes.

The problem is with I attempt to PASS parameters dynamically as per the code below.
I can tell you that the "first" parameter a string (Report Title) is okay... it get passed without any problems and shows up on the report.
The TWO parameters for the stored procedure is blowing up...

When I run the code as below... it will prompt for ReportTitle and @FROMDT (NOT @TODT). It seems as @TODT is being passed on ... but in the wrong format.
Because, in this case even when I enter the correct ReportTitle and @FROMDT I will get an error.

Failed to retrieve data from the database. Details: [Database Vendor Code: 241 ] Failed to retrieve data from the database. Error in File DirectRecruit {7DAE5E65-22D7-483C-9FB7-0E5E2D1AD979}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 241 ]

I am not sure what else to try. Could it be the format eg... "10/01/2009" (with quotes causing the problem???)
Please note: the stored procedure is expecting a nvarchar. So passing in a STRING should work.

Anyways, I am desperate for any help.
Thanks in advance.

ALTER PROCEDURE [dbo].[RS_SP_Report_DirectRecruits]
(
@FROMDT nvarchar(20),
@TODT nvarchar(20)
)
etc...

protected void Button1_Click(object sender, EventArgs e)
    {
        //Passing the parameter at run time
        ParameterFields PmFields = new ParameterFields();
        ParameterField PmField = new ParameterField();

        ParameterDiscreteValue myDiscreteValue1 = new ParameterDiscreteValue();
        ParameterDiscreteValue myDiscreteValue2 = new ParameterDiscreteValue();
        ParameterDiscreteValue myDiscreteValue3 = new ParameterDiscreteValue();

        PmField.ParameterFieldName = "ReportTitle";
        myDiscreteValue1.Value = "crParameterField does not exist in the current";
        PmField.CurrentValues.Add(myDiscreteValue1);

        PmField.ParameterFieldName = "@FROMDT";
        myDiscreteValue2.Value = "01/01/2009";
        PmField.CurrentValues.Add(myDiscreteValue2);

        PmField.ParameterFieldName = "@TODT";
        myDiscreteValue3.Value = "10/01/2009";
        PmField.CurrentValues.Add(myDiscreteValue3);

PmFields.Add(PmField);
CrystalReportViewer1.ParameterFieldInfo = PmFields;

        CrystalReportSource1.Report.FileName = Server.MapPath("~/DirectRecruit.rpt");

  //specify all the database details
        CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName = "TESTNFS";
        CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "myUserId";
        CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "myPwd";
        CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = "FSB";

CrystalReportViewer1.ReportSourceID = "CrystalReportSource1";
}

failed to create the crystal query engine

dmarek — Wed, 18 Nov 2009 21:12:33 GMT

I am setting up an application on a terminal server for users to access. I can run the application fine but users get the following message trying to run it.

failed to create the crystal query engine

The users can run the application fine if I add them to the local administrators group on the terminal server. They get the error as power users.

What I would like to know is what permissions need to be set for the user group so that they can run the program without having administrator access on the server.

Thanks

How to change old table to a new table and keep the fields? (Mapping to the new table)

Mubarak_100 — Thu, 12 Nov 2009 20:40:53 GMT

Hi
I have created a report with fields from one table (A), but now I need to replace this table with table (B) that have most of the field names, but few new fields that I will need to use. I would like to be able to map to table B, without having to re-drag the fields to the report.

In other words, I will lose all the report
fields where the old table fields refers. how to map the fields to the new table and also have the table name change?

thanks

Passing value from subreport to main report in crystal report

PakXoxer — Mon, 23 May 2005 09:18:33 GMT

Hi, i have designed a report that consists of a main report and a subreport
now i need the sum of a valueon the main report that is only present on subreport
plz give me any idea how can i pass a value from subreport to the main report.

rgds,

Danish

Displaying Subreport field in main report

masterpage1 — Wed, 18 Nov 2009 14:27:16 GMT

I have a main report that has a subreport added to it but i need to copy the values of a field from the subreport into the mainreport i tried the following Created two formulas

Main Report formula

whileprintingrecords;
Shared numbervar mytotal;
mytotal

Subreport Formula

whileprintingrecords;
Shared numbervar mytotal:=Count ({mytable.myfield)

however; i am not able to show the data in my main report it shows Zero and when i click on the subreport the values are there

if anyone knows how to get this work please respond.

best regards.

Dynamically setting connection string to a report

pkrishnan — Wed, 18 Nov 2009 06:57:38 GMT

Hi,

I am using asp.net 2.0, c# and Crystal Report 2008. I am new to crystal report.

I had a problem while migrating my application and db to production server.

There is error "Database Logon Failed".

I have to dynamically create Word file which is exported from Report document, but without using crystal report viewer.

In .rpt file I created connection using Database Expert->Create New Connection->OLE DB (ADO), where I set local DB account details. I design the report by simply dragging necessary stored procedure and fields.

In .cs File dynamically I set the connection from the connection string using the syntax

ReportDocument1.SetDatabaseLogOn(......);

My question is how can I force the .rpt file to use the dynamic connection which is set at .cs file (SetDatabaseLogOn)?

ReportDocument rptForm1 = new ReportDocument();
string strForm1Path = Server.MapPath("~/temp") + "/form1" + ccode + ".doc";
rptForm1.Load(Server.MapPath(reportPath + "Form1.rpt"));

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(SQLHelper.connStr);

rptForm1.SetDatabaseLogon(builder.UserID.ToString(), builder.Password.ToString(), builder.DataSource.ToString(), builder.InitialCatalog.ToString(), true);
ParameterValues prmsForm1;
ParameterDiscreteValue prmForm1 = new ParameterDiscreteValue();
prmsForm1 = rptForm1.DataDefinition.ParameterFields[0].CurrentValues;
prmForm1.Value = "ct101";
prmsForm1.Add(prmForm1);

rptForm1.DataDefinition.ParameterFields[0].ApplyCurrentValues(prmsForm1);
rptForm1.ExportToDisk(ExportFormatType.WordForWindows, strForm1Path);
rptForm1.Refresh();

How to add crystal report templet in asp.net

jatin.nahar — Wed, 18 Nov 2009 07:30:54 GMT

How to add crystal report templet in asp.net

Passing Parmeter Range to Crystal Reports using VB Code

stretcher25 — Wed, 18 Nov 2009 02:31:23 GMT

I'm trying to pass a range parmeter to Crystal Reports. I have my code that I can pass a discrete parmeter to Crystal Reports which works fine. Listed below is my code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Dim ConnInfo As New CrystalDecisions.Shared.ConnectionInfo
        With ConnInfo
            .ServerName = "MyServer"
            .DatabaseName = "MyDatabase"
            .UserID = "MyUsername"
            .Password = "MyPassword"
        End With


        Me.CrystalReportViewer1.ParameterFieldInfo.Clear()

        Me.CrystalReportViewer1.ReportSource = Server.MapPath("Invoice.rpt")

        Dim ParamFields As CrystalDecisions.Shared.ParameterFields = Me.CrystalReportViewer1.ParameterFieldInfo

        Dim p_InvoiceID As New CrystalDecisions.Shared.ParameterField

        p_InvoiceID.Name = "Invoice_ID"

        Dim p_InvoiceID_Value As New CrystalDecisions.Shared.ParameterDiscreteValue

        p_InvoiceID_Value.Value = Request.QueryString("Invoice_ID")

        p_InvoiceID.CurrentValues.Add(p_InvoiceID_Value)

        ParamFields.Add(p_InvoiceID)


        For Each cnInfo As CrystalDecisions.Shared.TableLogOnInfo In Me.CrystalReportViewer1.LogOnInfo

            cnInfo.ConnectionInfo = ConnInfo

        Next

        Me.CrystalReportViewer1.RefreshReport()

    End Sub

How can I modify this code to work for a parmeter range? I will be passing my two parmeters from a querystring. The parmeters will be invoice numbers, a starting number and a ending number.

Thanks

Putting Sub Reports into one Report

ProgrammingFreak — Mon, 16 Nov 2009 17:56:12 GMT

I have some sub-reports (which are bound to different datasets). I want to put them all in one report as one report,

How to put all reports in one report without using "link" option of sub-reports?

Need help urgently.....

Load Report Failed

Phyxious — Mon, 16 Nov 2009 16:40:29 GMT

I know there are tons of posts on this issue, but I am wondering what the purpose of having the Crystal Report controls if they do not work right when you move the web site to production.

I am trying to work on some Crystal Reports, I create my report, I add the CrystalReportViewer to the asp page, and configure it to point to the report. In order to get it to work in VS, I have to actually click browse and give it the entire path (C:\path to report\report.rpt), even though when I click on the data source it shows the report. Then when I move files to web server, it doesn't work because of the file path. If I change the file path to reflect the path the report will be on the web server, it still doesn't work, and if I try ~/reports/report.rpt, that fails to work. The only way I can get it to work properly on the web server, is on the asp page code behind file by doing:

Imports CrystalDecisions
Imports CrystalDecisions.CrystalReports.Engine
Imports System.Data.SqlClient

Partial Class Reports_Default
    Inherits System.Web.UI.Page
    Dim rpt As New ReportDocument
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        rpt.FileName = Server.MapPath("~/Reports/Report.rpt")
        Dim myConnection As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)
        Dim myCommand As New SqlCommand
        Dim myDA As New SqlDataAdapter
        Dim myDS As New DataSource

        Try
            myCommand.Connection = myConnection
            myCommand.CommandText = "SELECT * FROM Table"
            myCommand.CommandType = Data.CommandType.Text
            myDA.SelectCommand = myCommand

            myDA.Fill(myDS, "ReportData") 'ReportData must be the name of the table in the dataset, in order to work
            rpt.SetDataSource(myDS)
            CrystalReportViewer1.ReportSource = rpt

        Catch ex As Exception
            ErrorLabel.Text = ex.Message
            ErrorLabel.Visible = True
        End Try
    End Sub
End Class

and when configuring the data source for the report I created a ADO.NET DataSets pointing to my Dataset.

This is the only way I can get it to work properly from development to production. If you go by the numerous tutorials online that tell you to create a OLE DB (ADO) connection, and then adding the CrystalReportViewer and CrystalReportSource. The reports will not work properly once moved to the Production web server. Any ideas why, as I thought the drag and drop of controls and then configuring their properties is suppose to make the developers life easier?

Crystal Report

abdulriyaz — Tue, 17 Nov 2009 10:06:16 GMT

Sir iam developing Web Application with crystal reports. My Application is working fine in localhost and when i uploaded my application on server it gives me error that Report Load Failed so please tell the solution iam searching from 2 days please help me sir

Runtime Error on Client Machine after Upgrade

stretcher25 — Fri, 13 Nov 2009 14:43:01 GMT

I have Visual Studio 2008 Professional installed on a Windows Server 2008 x64 machine. I have Crystal Reports created from Crystal Reports 2008 Basic that was installed with Visual Studio 2008. I upgraded Visual Studio 2008 to SP1 and everything works fine. I have a Webpage project. The reports work fine on the server and client computer which is Windows XP Professional x86.

I upgraded Crystal Reports 2008 Basic to the full version. I installed SP1 and the hot fix for SP1. My project runs fine on the server and the reports work fine too. On the client, the project runs fine but the reports are erroring out. Here is the error:

An error has occurred while attempting to load the Crystal Reports runtime. Either the Crystal Reports registry key permissions are insufficient, or the Crystal Reports runtime is not installed correctly. Please install the appropriate Crystal Reports redistributable (CRRedist*.msi) containing the correct version of the Crystal Reports runtime (x86, x64, or Itanium) required.

I tried to install runtime files on the client computer but none of them worked. Does anyone have a solution to solve this error?

Thanks