Crystal Reports

Crystal Report runs query multiple times on page change

2013-05-24T06:53:29.127-04:00

I have written the code for crystal report in the page_init() and it runs fine, but I have just noticed that when I switch report page index, means when I want to load second page of the report, the control again goes to the page load and whole report query runs again.

I have made a switch case and from query string I take the name which report is to be loaded, is there a way by which when I can minimize the report load time?

Is session a better idea?

If I write the code in (!Ispostaback), then only first page is loaded, when I try to switch second page, it shows no resource is available error.

protected void Page_Init(object sender, EventArgs e)
    {
        try
        {
            String test = Request.QueryString["ReportType"];
            ReportDocument report = new ReportDocument();
            switch (testCondition)
            {
                   case "Report":
                    var rpt1 = new LenderCompanyActionReport();
                    String lcarParam1 = Request.QueryString["Param1"];
                    String lcarParam2 = Request.QueryString["Param2"];
                    String lcarParam3 = Request.QueryString["Param3"];
                    String lcarParam4 = Request.QueryString["Param4"];
                    String lcarParam5 = Request.QueryString["Param5"];
                    List<Reportclass> lst2 = new ReportMethod().GetReport(lcarParam1, lcarParam2, lcarParam3, lcarParam4, lcarParam5);
                    rpt1.SetDataSource(lst2);
                    CRReportViewer.ReportSource = rpt1;
                    break;
}

CRystal report populated at run time

2013-05-13T13:36:24.583-04:00

Hi,

This is the first time I'm working with crystal reports. What i am trying to do is crating a single crystal report which populated at runtime using with select command therefore I write the code onload event of page My code is-

try
{
ReportDocument cryRpt = new ReportDocument();

cryRpt.Load(@"C:\Users\Avi\Documents\Store backup\1Apr\store\Bill.rpt");

con.Open();
adp = new SqlDataAdapter("Select * from Store_Purchasebill where Bill_no=" + bill + "", con);
DataSet ds = new DataSet();
adp.Fill(ds, "Store_Purchasebill");

if (ds.Tables[0].Rows.Count > 0)
{

cryRpt.Load(@"C:\Users\Avi\Documents\Store backup\1Apr\store\Bill.rpt");
cryRpt.SetDataSource(ds.tables[0]);// here i get error

crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();

}

}
catch (Exception se)
{
MessageBox.Show(se.Message.ToString());
}

The error it show is report has no tables. I added a blank Crystal report if i need to add another type of report then plz tell me how to add that.

Thx in advance.

Multi Page

2013-05-23T14:29:19.17-04:00

Hi All,

Actually my report is, i have to print 30 values for 1000 members. But Per page i should print oly 25 members as well 10 values per person. Here values should come as horizontal. and members should align as vertical.i can do it for single page til 25 members using "format multi column".But don know how to show all of them.
Thanks in advance

How to pass value from Report Footer to Report Header in Crystal Report

2010-01-14T06:35:10.03-05:00

Dear All

I am using crystal report which comes with VS 2008. In my report I have a column called Status. My status can be Active,Inactive and Closed. Our Client needs the summary as

No. Of Active Fleets:

No. Of InActive Fleets:

No. Of Closed Fleets:

ON THE PAGE HEADER OF THE REPORT.

For this I have used count function in the Report Footer which works fine.But I need in Report Header. Is there any trick to pass the value from Report Footer to Report Header??? It's really killing me like anything.......please help

Crystal Report Error

2013-05-22T11:32:30.193-04:00

Hai all,

Crystal report show an error after publishing

5/22/2013 4:47:28 PM Report Viewer Page Load :-CrystalDecisions.Shared.CrystalReportsException: Load report failed. ---> System.Runtime.InteropServices.COMException: Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.
at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
--- End of inner exception 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 Peppers_Head_Office_App.ReportViewer.Page_Load(Object sender, EventArgs e) in E:\Applications\Peppers Application\SVN Peppers\Peppers_Head_Office_App\Peppers_Head_Office_App\ReportViewer.aspx.cs:line 52

pls help me

thank u

syam

Help needed with CR 12

2013-05-21T05:13:44.47-04:00

Hi everyone,

I want to do reporting in CR 12 since my web server supoorts only CR 12.

I tried to do the reporting using VS 2010 but the output is in CR 13 version.

I tried VS 2008 but the output is in CR 9

Can anyone point me to the right way to get CR 12 version ?

Thanks.

Updating existing formula causing issues with unrelated formula

2013-05-22T23:41:36.323-04:00

Hi all

have a weird issue here. I am currently running Crystal Reports 2011. I have a multiple totals fields which totals up different payment types. I updated one of these payment type totals and now it has affected a number of other payment type totals.

The only thing they have in common is the running sum variable sitting within those 2 formula are sitting in a Calc_all formula and to fix this issue i had to remove the specific payment types running sum code from my calc_all formula and then save the formula. Open the calc_all formula and re-copy the exact code in and re-save it. This would fix the issue.

Has anyone come across this type of issue before? i am planning to do code changes in the future and it is affecting multiple payment types as this is a huge report, subtotals and grand totals for these fields. Its very random as well so i dont really want to do the above fix everytime as i would need to reconcile each total and only target that specific code only. I cant delete all the code within Calc_All, save and repopulate and save again, I need to specifically target only that running sum formula.

thanks

How to pass query to sub report of Crystal report from asp.net

2013-05-15T10:34:58.347-04:00

I have written code for passig query to sub report from asp.net,c#.but the query displays all the records even if i give where cluase in sql query

Please refer the code below

protected void Button1_Click(object sender, EventArgs e)
        {
            TableLogOnInfo crTableLogOnInfo = new TableLogOnInfo();
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            CrystalDecisions.CrystalReports.Engine.Database crDatabase;
            CrystalDecisions.CrystalReports.Engine.Tables crTables;
            ReportDocument doc = new ReportDocument();
            doc.Load(Server.MapPath("CrystalReport1.rpt"));

            crConnectionInfo.ServerName = "newserver";
            crConnectionInfo.DatabaseName = "";
            crConnectionInfo.UserID = "";
            crConnectionInfo.Password = ";
            crConnectionInfo.Type = ConnectionInfoType.SQL;
            crConnectionInfo.IntegratedSecurity = false;
            crDatabase = doc.Database;
            crTables = crDatabase.Tables;
            string sqlCon = ""
            SqlConnection conn = new SqlConnection(sqlCon);
            conn.Open();
            string sql123 = "select * from jobs where JobNumber=" + TextBox1.Text + "";
            SqlCommand cmd = new SqlCommand(sql123, conn);
            cmd.CommandType = CommandType.Text;
            SqlDataAdapter adpt = new SqlDataAdapter(cmd);
            DataSet dataSet = new DataSet();
            adpt.Fill(dataSet, "Customers");
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
            {
                crTableLogOnInfo = crTable.LogOnInfo;
                crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogOnInfo);
            }
            doc.SetDataSource(dataSet.Tables[0]);
            conn.Close();
            sqlCon = "";
            conn = new SqlConnection(sqlCon);
            conn.Open();
            string sql1234 = "select * from JOBSDOCUMENTS where JobNumber=" + TextBox1.Text + "";
            cmd = new SqlCommand(sql1234, conn);
            cmd.CommandType = CommandType.Text;
            adpt = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adpt.Fill(ds, "Customers1");

            doc.Subreports["CrystalReport2.rpt"].SetDataSource(ds.Tables[0]);
            
            CrystalReportViewer1.ReportSource = doc;
        }

Thanks

chandran

Get Crystal Report data in session

2013-05-21T14:23:31.25-04:00

I have noticed that crystal report runs the Linq query once again when the page index is changed, means when we load second page from first page? So just wanted to know if we can get which page is loaded so that we can keep values in session.

Just a hint is required as I am not getting the desired results from Google.

Update: I am sorry in a hurry I just clicked on a wrong tag. So the problem is like:

This is my code below which I use fr running my crystal report:

var rpt = new Result();
List<class> lst1 = new DALMethod().Get();
rpt.SetDataSource(lst1);
CRReportViewer.ReportSource = rpt;

When I switch from page one to two or more, this method in DAL is called again taking the same time it took first time to load, so I just want to have the data in session when query runs first time, and next time when I get the page index, then I will show data from session.

Is there a way around by which I can get the page index in this c# code?

Cross Tab report

2013-05-20T07:52:52.18-04:00

Sample/Example step by step report for Cross tab

show decimals exactly as they are

2013-05-12T04:42:21.433-04:00

Hi,

is there any way to show decimal numbers exactly as they are?

for example I want to show 169.50 not 170

and 0.2589

exactly 0.2589

Thanx

To hide a section of Crystal Report Programmaticaly

2011-03-22T06:40:50.86-04:00

I wanted to hide a sectionof crystal Report progarammatically using a formula. How is it possible?

How to print all page in RDLC report using JAVASCRIPT? or any other way

2013-05-16T09:18:47.623-04:00

Hi all,

I am using ReportViewer in ASP.net 2.0. It was a local Report and bind data from Dataset. It was workd well . But , My problem was, when i need to go print , i cann't do it. I searched google and found solution using Javascript.

Get Html code by using document.getElementbyID(controlname).innerHTML().

Write that code to New window. And then print page by using window.print() function.

But , the problem is it only prints first page, Not all pages. If my report goes to more than one page, Print first page only. Can you help me please?.

(OR)

How to print report in reportviewer. It should be worked in IIS or client machine.

Thanks in advance...

Crystal report not viewing after publish asp.net page

2013-05-09T05:15:06.01-04:00

hai,

Crystal report not viewing after publish asp.net page

i am using .net framework 4.0 vs2010 sap crystal report

i nstalled CRRuntime_32bit_13_0 on my machine

pls help me to clear this error

thank you..

syam

creating a dynamic crystal report with asp.net 2.0 i.e., VS 2005

2012-02-15T22:17:01.7-05:00

Hi,

I have a procedure where the number of columns in not constant. It changes based on the search criteria.

Now i need to build a crystal report based on the result of that stored procedure.

I am never created dynamic report. Can someone help me in this

Thanks in Advance

crystal report issue after print

2013-05-12T15:49:54.28-04:00

Hi,

I am from hyd,i am working on asp.net application with crystal reports,when I generate button,crystal Report is generating success fully,

then i am pressing print button button,now print window is genarating and print is coming successfully,then my issue is,now i want to cancel

my crystal report,now crystal report is not working properly,cancel is not working after print is completed,

can any one guide me pls,how to work with crystal report after print

Crystal Reports - forcing next page

2013-02-16T06:13:53.077-05:00

Hello everyone;

I have a crystal report in my program (using VS 2008, SQL Database) to print a corporate check (standard STUB/CHECK/STUB format). On the STUB, it prints out all of the invoices that the check is for. This is done in a subreport and it works fine. What I would like it to do it is if the number of invoices exceeds 12, force it to a second page because only 12 invoices fit on a check stub. The second page would be a VOIDED CHECK (XXXX.XX) but would print the remaining invoices over 12 on the stub. For example, if my check batch had a vendor where I selected 20 invoices to pay with one check, on page one it would list the first 12 invoices on the check stub, total all 20 invoices and create a check for the full amount, then on page two, print the remaining 8 invoices on the stub and void the check on the second page. Right now my program and the crystal report works fine if you print 12 or less invoices on a stub - no more than 12 invoices fit on a stub. If I have more than that in my check batch, the check prints correctly but only the first 12 invoices will print out on the crystal report in the space provided on the stub. I need to force it to print to a second page so that the remaing invoices print out on the stub so that I can mail one check (totalled correctly), with two check stubs (from page one and page two). Can anyone give me some insight?

Thank you.

Todd

Display image in crystal report.

2013-05-10T07:50:36.283-04:00

I have to display image in crystal report. Image is strore in image folder and path is store in database.

How to create a Crystal Report on a Single Page?

2013-05-07T13:47:12.84-04:00

Sorry to ask this silly question, but I'm a newbee to .NET Environment, I know how to call a Crystal Report in ASPX using C#, but the problem is, I want to pass @Parameters to the report from the Page, like Date (From, To) and Combo Box values. I've searched a lot for this, but didn't found a solution which I can easily understand.

Kindly, if any body can provide some sample code to call Crystal Report on a Single ASPX Page.
Thanx in Advance!

My rdlc report doesn't show Print Button

2013-05-08T08:17:05.51-04:00

Hi,

my rdlc report doesn't show print button though I have showPrintButton properties True

<rsweb:ReportViewer ID="ReportViewer1" runat="server" BorderColor="#0066FF"
        BorderStyle="Solid" BorderWidth="1px" Width="800px" Height="700px"
            ShowPrintButton="true" ShowRefreshButton="False">
        </rsweb:ReportViewer>

pls solve me