Crystal Reports Forum : Self-Publishing

Adding multiple fields in a group

Fri, 02 Oct 2020 05:39:00 GMT

I know that this is old, and for someone looking for the answer, the simplest way that comes to mind for me is to create a formula that concatenates the fields that you want to group on, and use that as the grouping condition.

There is probably other ways as well.

HTH

Adding multiple fields in a group

Thu, 14 Dec 2017 12:18:51 GMT

I have a SQL
Select Name,address,sum(salary)
from abc
group by name,address
How do I handle group by in Crystal

how to set DB details from CMC in report with 2 DB

Mon, 12 Dec 2016 03:45:46 GMT

When you set the database configuration, you have to set it for both databases. Depending on which version of Crystal Server/BOE you're using, you'll either have a list of database connections on the left or a drop-down list toward the top of the screen.

Set the information for one connection, save, then set the information for the other connection and save.

-Dell

how to set DB details from CMC in report with 2 DB

Mon, 12 Dec 2016 01:25:24 GMT

Hi..

Can any one help me in this Topic.

I am using Crystal 2013. I have a report created with two database. One sub report from SQL source and another from Oracle.

I am able to run the report from Crystal application and get the output. But when I moved the report in CMC and tried to set Database Configuration details but it doesn't work.

Can any one tell me if I am missing something or there is another way to set this.

Thanks in advance.

Edited by Myth - 12 Dec 2016 at 1:26am

Paging in Crystal Report

Fri, 25 Apr 2014 17:43:57 GMT

Hi,

I am using Crystal Report in one my web based .net application. We are using XSD for creating crystal report and from .net code we are calling crystal report and assigning data to it. The issue I'm facing is about paging. Now we store data in session variable and use the data from session whenever next page is clicked.

Can you please advice on the same.

License and Maximum Report Processing Jobs Limit

Tue, 18 Mar 2014 09:57:54 GMT

Based on the various discussion and forums , not getting the correction solution close and dispose the objects. if anybody can help i would like to give awards since due to this issue i am loosing my project amount.

This is my challanges : how to close the pending files form temp folder? . Sometimes its clearing however i am seeing everyday two three files keeping pending in tmep folder

Below my code

Setp 1 :

// page load

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

ShowPOPrint ();

}

else

{

if (Request.Params["__EVENTTARGET"] != null)

{

if (Request.Params["__EVENTTARGET"].Equals("CLOSE_REPORT_OBJECT"))

{

string ret = Request.Params["__EVENTARGUMENT"];

status = true ;

}

Step 2

// function for initialize the

private void ShowPOPrint()

{

DataSet Temp = new DataSet();

ReportDocument objrptdoc;

if (Session["REPORT_KEY"] != null)

{

objrptdoc = (ReportDocument)Session["REPORT_KEY"];

objrptdoc.Close();

objrptdoc.Dispose();

Session.Remove("REPORT_KEY");

Session.Remove("REPORT_NAME");

}

// Create a new report object

objrptdoc = new ReportDocument();

objrptdoc.Load(Reportclass.RptFileName);

Temp = Reportclass.DataSetReport;

objrptdoc.SetDataSource(Temp);

Session["Objrptdoc"] = objrptdoc;

Session.Add("REPORT_KEY", objrptdoc);

Session.Add("REPORT_NAME", Reportclass.RptFileName);

crptReport.DisplayGroupTree = false;

crptReport.ReportSource = objrptdoc;

crptReport.DataBind();

crptReport.DisplayPage = true;

Temp = null;

}

Step 3 : //

// using for paging

protected override void OnInit(EventArgs e)

{

if (Session["Objrptdoc"] != null)

{

objrptdoc = (ReportDocument)Session["Objrptdoc"];

crptReport.ReportSource = objrptdoc;

}

Step 4 // closing the report form and calling post back event to dispose the object

protected void Page_Unload(object sender, EventArgs e)

{

try

{

if (status == true)

{

if (this.crptReport != null)

{

this.crptReport.Dispose();

this.crptReport = null;

}

if (objrptdoc != null)

{

objrptdoc.Close();

objrptdoc.Dispose();

GC.Collect();

}

catch(Exception ex)

{

}

//-- SCRIPT IS USING TO CALL THE POST BACK EVENT TO TRIGGER THE PAGE UNLOAD AND DISPOSE THE OBJECT

window.onbeforeunload = function () {

__doPostBack('CLOSE_REPORT_OBJECT', '');

confirmComplete();

//alert("Report Generate PDF/Closing");

};

function confirmComplete() {

// alert("confirmComplete");

var answer = confirm("Are you sure you want to continue");

if (answer == true)

{

return true;

}

else

{

return false;

}

</script>

Thank you ,
jomyoxive@gmail.com

Complex Date Formula

Fri, 19 Apr 2013 09:38:32 GMT

How much data do you expect to be going through in this report? I'm concerned because using a Crystal formula for this type of filter will probably cause Crystal to pull ALL of the data into memory and then apply the filter instead of pushing the filter to the database for processing. This means that lots of data will be travelling over the network and into the memory of the computer where the report is running where Crystal will process it to potentially return just a few rows. So, this will slow down your report.

However, there are a couple of ways around this. What type of database are you connecting to? How are you getting the data - are you linking tables in Crystal, using a universe, using a command or a stored procedure?

-Dell

Complex Date Formula

Thu, 18 Apr 2013 10:29:50 GMT

So I have a dillema, I'm trying to create a Crystal Report that will return records based on a specific date function. So what I'm trying to do is return results on invoices that have early pay discounts due in 3 "Working" days. So I have an InvoiceDate field that represents the start of the discount count, i.e. 10/NET 30. So in order to get the early pay discount you need to pay by 10 days from the InvoiceDate. But I want to be alerted 3 working days before that date, so if that date would happen to be a Tuesday then I would want to be alerted on Friday (excluding weekends). In my DB I have the InvoiceDate, the early terms are defined in a DB field called DiscountDays which would have 10 for example in it.

So basically I want the report to give me everything that is due in 3 days to make the early term discount.

InvoiceDate + DiscountDays = DiscountDueDate
DiscountDueDate - 3 (excluding weekends) = When I want it to show up on the report, if it's due 3 days from when I run the report. Not concerned with holidays or anything.

Thus far I can create a formula that gives me a comparison date that is 3 working days from now...

if WeekDay(currentdate, crMonday) < 3 then currentdate + 3
else if WeekDay(currentdate, crMonday) > 5 then currentdate + 3 + (7 - WeekDay(currentdate, crMonday))
else currentdate + 5;

I'm not sure what else I need to do to make this compare to the DiscountDueDate to get the result. Not sure what to do next. Thanks for any help.

How to purchase license for SAP Crystal Reports fo

Mon, 01 Oct 2012 10:17:20 GMT

See the documentation here for Crystal Runtime Licensing: http://scn.sap.com/docs/DOC-21575

-Dell

How to purchase license for SAP Crystal Reports fo

Tue, 11 Sep 2012 22:56:30 GMT

Hi,

How to purchase license for SAP Crystal Report version for Visual Studio 2010?

We have developed Embeddable Crystal Report to give to Clients. They wants to Modifying reports.

We have designed that application in Visual Studio 2010 Embeddable Crystal Report Designer Control Library 11.5.

Now we planned to purchase License.

Is SAP Crystal Report version for Visual Studio 2010 license enough or need to get separate license for Embeddable Crystal Report Designer Control Library 11.5?

then while deploying Merge Modules also need to get license.

Is this license use for Visual Studio 2005?

could you please tell me how to get License for
SAP Crystal Report version for Visual Studio 2010,
Embeddable Crystal Report Designer Control Library 11.5,
Merge Modules ?

Thanks in Advance.