[Webinar] Streamline your web hosting managementRegister Today

x

Crystal Reports

34K

Solutions

15K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi All, today I encountered an error on my crystal report saying "database logon failed". This report has been using for all the staff for a couple of months already and no errors were encountered. For today when I tried to access the report I got this "Database Logon Failed". Please help why I'm getting this kind of error.
0
Free Tool: IP Lookup
LVL 11
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

In Crystal Reports I'm wanting to make a report which pulls different information from are database, I needs to use two dynamic parameters, but I'm having trouble. For example, I'm wanting the fist parameter ask for a Job number, then when the user enters the Job number they are shown a selection of Sub jobs linked to that job number which they then choose the correct one and the information is placed on the report.

Is this possible and how would I do it.

Thanks
0
Crystal report custom links?

Hello,
I have a two sql tables.

1: thickness (id, id, thickness_up_to)

id     thickness_up_to:
1       5
2      10
3      15
4      20

2: price (id, thickness, price)

id  thickness  price
1   3                 20
2   5                 25
3   10               50

Problem is that I cannot make a link directly to thickness_id. I must create multiple criteria
if real thickness from table 2 is lower than thickness from table 1 then use price for 3mm thickness (20)
it real  thickness from table 2 is somewhere between fields from table 1 then use price for that period.
if it real  thickness from table 2 is above all fields from table 1 then use price for maximum thickness.

I think you understand what I need?

I know how to do it in VB net but problem is that I must do it in crystal report report directly.
I am also thinking about views in sql server directly to create new view and use it in crystal report?
I would like to do it just for this custom report, not to change anything in the database.

While linking table there is no option between in crystal reports?

Is this possible?
Tnx
0
How to have a total for each year on a Crosstab with Year({Date.field}) and Month({Date.Field}) with 2 Years of Data?  example.. 2016 Totals and 2017 Totals.  Currently 2016 and 2017 is added together.
crystal.PNG
0
Getting error 'A String is required here'

The Parameter (?StandardComments) is setup as a string.. with multiple values

1.Line1 has been chosen
2.Line2 has been chosen
3.Line3 has been chosen
4.Line4 has been chosen

I have created a Formulas based on the parameter

if {?StandardComments}
startswith '1.' then cstr(mid({?StandardComments},3,100))
else if {?StandardComments}
startswith '2.' then cstr(mid({?StandardComments},3,100))
else if {?StandardComments}
startswith '3.' then cstr(mid({?StandardComments},3,100))
else if {?StandardComments}
startswith '4.' then cstr(mid({?StandardComments},3,100))

Why won't this work.. It will work without multiple values
0
Crystal Reports - I am trying to total a formula (GroupPayrollHours) in a group and as a grand total on a report.  Below is the formula I am using in the detail section of the report that needs to be totaled.

if Not OnFirstRecord
AND
{Attendance.Work_Date} = previous({Attendance.Work_Date})
and {Attendance.Regular_Minutes} = previous({Attendance.Regular_Minutes})
then 0
else {@Payroll Time}

Any help would be appreciated.

Thank you
0
I have a Crystal report that I need to copy a parameter field from one report to the other.  They are almost identical.  Not sure how to do this.  I will attach screenshots that will show what I mean.  I will label each screenshot with what is going on.  I'm not an expert on Crystal so bear with me.
Screnshot of the report launcher in our accounting systemScreenshot of parameter that worksScreenshot of the edit window of the parameterScreenshot of FIND IN FORMULAS for the parameterScreenshot of the parameter I copied for the report I want to use the parameter onScreenshot of windows that shows up when I click on FIND IN FORMULAS  (how do I add the formula?)
0
Hi, my report is showing incomplete total.  I have a Budget assigned to a control account and I have PO assigned by Package:

The po VALUE shows correct account, and the budget has with two control account (see attached) as follows:

P31.9140.2C00 - 9,000
P31.9140.2C00 - 190,800

In the PO the budget used is only P31.9140.2C00 the other was not used.

On the attached form, I should show the total budget of 199,800  and it doesn't matter if I assign or not assign the budget in the PO.  But I can't show the total of 199,800 it only show the amount of the account code I assign, and even if I include the other code with the 9,000 budget it will not show the full budget amount.  I suspect I missing additional Link.  I can't use the sum ((Account.Cost_BAC Approved})  it will just show weird total $1,335,600.

The above data comes from table Account and Field Cost_BAC_Approved

Current Commitment and Total Commitment comes for PO_ITEM.Cost which is assigned by PO_ID coming from table PO_item.

Please let me know if I am missing some links or I need another formula or groupings.

and in relation to the above,

I am getting this result in a table report how do I correct this (see attached file "Table"):
Crystal-Capture.PNG
Table.PNG
0
The following formula provides correct results for counting using the Group Sum function except for the fact that I need to add DistinctCount to eliminate duplicates.  I cannot seem to get DistinctCount to work in this formula and don't really know where to put it. I tried using the DistinctCount in the Group summary but that did not give me the right results.

If
({table1.field1} = 1 and
{table2.field2} = 2)

then 1

else if

({table1.field1} = 1 and
{table2.field2} = 3)

then 1

else if
({table3.field1} = 1 or {table3.field1} = 2

then 1

Else 0

Thanks for your help.
0
In Crystal Reports, I need a formula  to change CurrentDate from mm/dd/yyyy to mm-dd-yy without changing Options/Fields/Date.
0
Free Tool: SSL Checker
LVL 11
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I am trying to write an application that will output a Crystal Report to PDF format and then e-mail the resulting PDF. I would prefer to do this in Microsoft Access because I am most comfortable there but I keep reading that the VBA/ActiveX integration is deprecated. I don't want to start something today that I know doesn't have a future. Does anyone know if this is true?

Assuming that I cannot do this in Microsoft Access my second choice would be to go to VB.net. In this case I need some basic guidance about how to integrate an external application like Crystal into this environment.

Thank you.
0
hello,

I want to create in such a way that, there is no need to set printer preferences manually. Is there is any way in C# to set such thing
0
Set Drill Down effect in Sub report to show the Detail Data
DrillDown.png
0
I am the IT Director and have not coded in years.  Lost a key person on staff to heart attack and am in a pickle over a few reports that are either terribly slow or won't complete at all.  Please treat this as coming from a non Developer for as I stated... have not coded in years.

Experts can you please look at this Accounting bucket report and help me eliminate bottlenecks or design a more efficient fetch via cursor or?????  Need help as auditors will be snooping around doing their deeds in new week or so and Accounting needs this  report.

thank you in advance.
0
I have start date of an agreement and their total sale. I’m trying to build a report to show 1st year and show their count. Like if the agreement started in 2012 it is it’s first year and if it is started in 2015 it is its first year. Can some one help me how to write that formula ?? Thank you
0
I had this question after viewing Using a Do While loop to step through each row in a database.

I have created a Crystal Report to display the total number of patients in care. I have both Start Date and End Date parameters. If I enter both date parameters, I get an accurate count for any day. Now, my problem is that my customer wants the ability to enter 2 different dates (day, week or year) and display the average of the two numbers. I have to run my report 2 times to get 2 different dates. What do I need to do to get the report to display the count for the 2 or more days for which the average is needed? I have Crystal 10

So my data looks like this:



Date                  Count

01/01/2018        4200

01/22/2018        4800

Average:           4500
0
We have upgrade our system to Windows 10. Since this upgrade, Crystal Report displays reports incorrectly when a “can grow” field (Description) does take up more than one line. All sections are fixed height up to and including the Page Header Section 3. Section 3 has a minimum height set. The Data Section 3 is set to Print at Bottom of Page. This appears correct when each field in Section 3 is one line or the report is generated on a Window 7 system.
CR_Layout.PNG
CR_Result.PNG
0
How to bind existing crystal report file (report.prt)  to report viewer in asp.net
thanks in advance
0
Using Crystal v.14.1.1
I've created older reports that now need to be modified.
When I go back in to add a field, I'm seeing the detail information is running off the right hand side of the page?
I can't seem to figure out how to fix it.  
I'm attaching a screen shot of what I am seeing.
Thanks for the help.
Doc1.docx
0
Take Control of Web Hosting For Your Clients
LVL 11
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

I have seagate crystal report 8 in the system. It was already in used by another employee who is now retired. I am unable to understand one thing that a query is already made and when I run it then it shows total figures (summarized figures in a table format), which is set on different parameters but when I try to save it then it takes lots of time plus does not save the summarized position as it is visible on screen instead it saves total records as well as total figures in the bottoms (which is not desired). I just want to have summarized position in the table format when I save it in excel format. Is there any setting or any other options in which I can make changes, so I can have my desired data only in a shortest time and not the whole database information?
0
Hi,

I have installed oracle instant client in c drive and oracle full client in d drive.I have updated the environmental variables path with d drive oracle client.

Now i dont need instant client in C drive,I need help in cleaning oracle instant client in C drive.Crystal reports should only look for D drive oracle client using OLE DB.

Thanks,
Vikram
0
Today I have a application that was made using webforms and I need to migrate to ASP.NET CORE.

This application uses Crystal Reports to generate many reports in PDF format.

I need a solution to migrate this reports, I intent to migrate this solution to a Linux server, then if I can migrate this reports to a solution that run in linux is better.

I've tried iTextsharp, but this don't work in ASP.NET CORE with Linux.
0
I have a request to create a report with data from 4 tables for a specific month grouping the data by the user that is logged in EITHER the created_by or modified_by fields for each record.  This is supposed to be an audit report that can be run and then tested to ensure that the user had the authority to make the transactions.

The table data can not be linked and so therefore I am assuming that I have to create 4 subreports.  

The data in the first table is a Users table that we are ensuring that additional records have not been created by users already in that table.
The data in the second table is a Contractors table that we are ensuring fictitious contractors were not created.
The data in the third table is a list of Projects that we are ensuring fictitious projects were not created.
The final table is the actual financial transaction that we are ensuring fictitious financial transactions were not created.

All 4 tables have the same 4 data fields...
Created_by
Creation_date
Modified_by
Modified_date

I wanted the report to run a separate section of the transactions for the 4 tables for each user that is identified from the Users table and initially I need to hard code the month date range to run this for prior months, but moving forward have the auditor be able to run the report at the beginning of the month to get the prior month's transactions.

Do I need to put these tables in subreports or is there a better way and how do I ensure that if there …
0
I have vb.net project in VS 2010 and for crystal report i am using framwork 4 but in my pc framwork 4 client profile also be there.
. i have 1 crystal report and 1 form but when i want to create a setup project error message shows. setup file is created even after the error when i run the setup on client pc setup done successfully but when i want to run a application it showes error "exe not working" and progam get exited. Please refer the attached screen shot.
So, please help me i am stucked?
error.jpg
0
I'm new to crystal report. I'm facing an issue that my report show no data although the dataset showed it did have data during debugging. I noticed that everything went wrong after the line " m_rptViewReport.SetDataSource(ds); ", it showed "HasRecords = Function evaluation disabled because a previous function evaluation timed out. You must continue execution to reenable function evaluation crystal reports" Basically, I'm trying to export the data to xls file using push method. I'm using VS2015 and my crystal report assembly version is 13.0.3500.0

Pls take a look at my code
 public bool ExportToFile(DataSet ds,string fileType)
     {
         try
         {
             object obj = null;
             char[] split ={ '.' };
             CrystalDecisions.CrystalReports.Engine.ReportDocument m_rptViewReport = null;


                 if (File.Exists(Request.PhysicalApplicationPath + "\\" + this.ReportFile))
                 {
                    try { 
                     m_rptViewReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                     m_rptViewReport.Load(Request.PhysicalApplicationPath + "\\" + this.ReportFile);

                        ds.WriteXml("D:\\testfile.XML", XmlWriteMode.WriteSchema); //the output XML file does have data
                        m_rptViewReport.SetDataSource(ds);//something went wrong after this line
                    }
                    catch (Exception ex) //nothing happened here
                    

Open in new window

0

Crystal Reports

34K

Solutions

15K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.