Crystal Reports

34K

Solutions

14K

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

We have VS2008 application using crystal reports.
This was deployed on windows server 2008 r2.
This was working well and we don't have any issues.

We deployed the same application on windows server 2016.
We are having issues with the crystal reports. I installed the crystal reports redistributable for VS2008 on this new server.
Whenever, i try to access the reports, i am getting the following 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.  Please go to http://www.businessobjects.com/support for more information.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: 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 …
0
Free Tool: ZipGrep
LVL 11
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hi

Just a general question we are looking at using stored procedures and using them instead of SQL commands just wandered what the advantages/disadvantages of doing this - i.e. for such things as parameters, performance or anything else?
0
I am inserting sub report into the main report, sub report group footer and report footer and I am displaying and suppressing sections on the conditions of different event types, the problem is when the field is blank it displaying both the sections group footer and report footer.
What I need to do is: if field is blank suppress the sections other wise it has to evaluate event type conditions and according to that suppress or display the sections.
Thank you
Venu
0
I'm a Crystal Reports newbie, I want to write a simple java application that is print my data (using hibernate and jsf).
This is my method in my managebean:

public void print(List<Child> list) {
            
            try {
                  
                  // Instantiate the report object
                  String report_Location;
                  report_Location = "/com/reports/Report1.rpt";
                  
                  // This interface provides a common service point for getting a report source that is used to view and export reports.
                  IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
                  
                  // It is recommended to use the ReportClientDocument to obtain an IReportSource object.
                  // it's also Creates a new reportsource for the report specified.
                  Object reportSource = null;
                  reportSource = rptSrcFactory.createReportSource(report_Location, java.util.Locale.getDefault());
                  
                  // creating a Fields object, populating it with the parameter values then adding that to the viewer.
              CrystalReportViewer viewer = new CrystalReportViewer();
              
              /*
               * Before parameter fields can be set in a report, the fields must first be created and initialized.
               * Individual parameter fields are all stored in a Fields object.
               * The Fields object is simply a collection of different fields that can be passed to the viewer.
               */
              
              // Create a Fields object to store the parameter fields in.
              // Returns an object that contains the parameters in the report.…
0
I am migrating from an older version to CRS 2013 where I am unable to locate the BVM.  I've gone back in the install package seeing if I missed the install section and didn't see it even in it.  In web searches it shows I should be able to locate it in:  SAP BusinessObjects BI Platform Client Tools, however unable to locate this also.
0
I have written a formula to split peak from off peak time, peak is only Monday to Friday, the result is only returning data for off peak, please see formula below;

  If ( (time({STAT_RM_TRANSACTIONS.TRIPDATETIME})>=timevalue(03,00,00) AND time({STAT_RM_TRANSACTIONS.TRIPDATETIME})<=timevalue(09,29,59))
          AND  (
          (time({STAT_RM_TRANSACTIONS.TRIPDATETIME})>=timevalue(15,30,00) AND time({STAT_RM_TRANSACTIONS.TRIPDATETIME})<=timevalue(17,59,59))
               )  AND      
          datepart("w",{STAT_RM_TRANSACTIONS.TRIPDATETIME}) IN [2,3,4,5,6] //weekdays
 
         ) THEN "Peak"

ELSE "Off Peak"
0
Dear SIr,

I have develop below scenario of crystal reports to drill down the data  by using a hyperlink in first crystal report shown in a preview mode that it opened in a  new tab when calling from the parent web form
then in this first crystal report I add a hyperlink to open a second crystal report that I need to open it also in a new tab
and so on...
Can anybody has any idea?
0
Hi There.
I am creating routing cards for jobs out of JDE and want to put a sequence number on each set of cards.
I am using a repeater table to duplicate the number of cards based on a formula that is how many units per bin. (job = 3000 units, 300 per bin so 10 cards will be printed per operation step.
there are many steps per job. example operation 10, 20, 30 ,40. I am getting 10 of each card in that sequence 10 times.
I want to put a number that represents the group of cards / bin number. eg. first 4 cards will all be 1, second 4 cards will be 2 etc... up to 10. each 4 cards has a 10,20,30,40 in that order.
When the job number changes on the card then the sequence number starts back at 1 again.
Tried running totals but couldn't get it to work
Any ideas?
Cheers

Steve
0
I am having a multiple cross tabs (on page 4 of 4)  in my report displayed below attach image
Issue1.jpgI want to merge the rows for same name list.
As you can see, "Running Time" is repeating twice. I have taken sorting ID to bring the Values in the required format instead of viewing in Alphabetical order.

Below is the location.
https://drive.google.com/open?id=1sH07hjkIqn5JG8G8EsyX6wEe53MzbpDh
0
I had this question after viewing Random Record Selection.

I thought this was working ok
I have 2 sites that need to use this report
One seems to work ok the other only returns 6 records instead of 20
Any ideas
Have included the rpt file
Gordon
Customer-Survey-Data.rpt
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.

I have one main report and 4 sub reports. 3rd sub report and 4th subreports are not showing data in main report. But first two sub reports are showing the data. I have linked all reports correctly.I am unable to find the issue, please help me. Based on main report parameters it should display.
0
I have this Formula for Yearly Totals

Shared NumberVar yearlyWages;
Shared NumberVar GrandWages;
GrandWages := GrandWages + yearlyWages;
yearlyWages;
It is placed in Group2 footer(there is nothing in Group1 footer)
In the report footer I have this formula for Grand Total
Global NumberVar GrandWages;
GrandWages

Yearly wages works fine.. it is being reset to 0 in Group header 2.
The GrandWages in the report footer is 0.  It does not have the accumulated value.
What am I doing wrong?
0
I'm running a Crystal Report to the screen. On the viewer is a Print icon.

Print icon
But when I click it all I see is the Microsoft XPS Document Writer, it doesn't give me access to any of the other printers available.

print dialog
I'm running Windows Server 2008 R2, but is an issue reported by a customer, I just happen to be able to replicate it on a VM I have built.

I can see that it is defaulting to the system printer:

printers on server
 so if I change the System Printer to "One Note" for example:

change system printer
Then it prompts with that, but ideally I would like it to just allow them to select any printer.

change print dialog
0
Hi,
I want to create a 1 crystal report which shows the Member detail form member section i have to display member records and in spouse section i want to display spouse details and also same for member dependents.i have all details in one table but there are different record for member,spouse and dependents. (e.g for member code OM0582 in database OM0582  01 for spouse OM0582  02 , if member have 3 dependants then OM0582  03,OM0582  04,OM0582  04). i am attaching screen shot of table records of 1 member. i want to display this records in one member form, how can i do this?
error.jpg
0
Hello.

I have Peachtree 2017.2 and there are two reports that have two different sets of data that I need.  The "Invoice Generated Report" and the "Cash Receipt Journal" report.

How can I create a custom report that will show me the information from both in one report.  I need at least the customer number/id and/or customer name, the invoice number, receipt number (from the CRJ report) and the amounts.

Thanks. :)
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 have a requirement where I have to display all the text from RightToLeft (mirrored text).

How to achieve this with crystal report?

Please help me to get the solution for this.
0
Hi there,

I have what I thought was simple suppression criteria for my group but it's not returning the results I need, ;

if {?Days Over Due} = "All Pledges" then FALSE

//less than thirty days overdue but not negative or 0    *this returns negatives as well as values over 29
else if {?Days Over Due} = "Less than 30"
then ({@Days Overdue} <=0
and {@Days Overdue} >29)

//inclusive of 30 and 90 excluding less than 30 and greater than 90 *this returns similar results
else if {?Days Over Due} = "Between 30 and 90"
then ({@Days Overdue} <30
and {@Days Overdue} >90)

//inclusive of all over 90
else if {?Days Over Due} = "Greater than 90"
then {@Days Overdue} <=90

Any help would be appreciated!

Thank you - CS
0
Sir,

Would you please help us if we can read default values in a crystal report from VB.net programmatically
or how to add default value in the crystal report in order to read them from the web form

Thank you,
0
[Webinar] Cloud and Mobile-First Strategy
LVL 11
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Hi Guys,
We are using SAP Version 9.2 PL7
we have setup transactional replication in MSsql 2016 server & works well.
but when we upload all existing crystal reports (After Modified), SAP Rollback the Crystal Report Upload. but it is possible to upload new reports. please see attached error image.
any ideas are greatly welcomed.

thanks.
Untitled.png
0
All,
 I have VS 2015 Enterprise with CR installed.
Using VB.NET I've developed my CR program.
Now I want to create a setup program that will run the CR .msi first & then continue with installing my program.
Is there any way to add it to prerequisites, or just run the two sequentially?

Russ
0
I would like to create a report (or ultimately a dashboard) that looks at a particular value (a status for a particular record (e.g. "new", "in process", "completed")).  There is no data of the status at any particular time so all I can query is how many records are in each status at any given snapshot in time, but I would like to know where we stand and how these are changing over time.  Is there a way to automatically run the report (e.g. daily) and have all of the prior results be part of the most current report?

I hope I explained this well.

Thank you,
Bruce
0
I have formula filed f1 do (field1-feld2) during tow dates
then how to use something like this in my c# code
DB db = new DB();
            DateTime StartDate;
            DateTime EndDate;
            StartDate = Convert.ToDateTime(dtpfrom.Value.ToString("yyyy-MM-dd"));
            EndDate = Convert.ToDateTime(dtpto.Value.ToString("yyyy-MM-dd"));
            FrmViewer fv = new FrmViewer();
            crtunderMedicineRoof rpt = new crtunderMedicineRoof();
            string sql = "";
            sql = "  {View1.MedicineDate}in #" + StartDate + "# to #" + EndDate + "#";
            param = "سقف العلاج للفترة من  " + " " + dtpfrom.Value.ToString("yyyy-MM-dd") + " الي" + " " + dtpto.Value.ToString("yyyy-MM-dd");
                        //
            if (ckb_overRoof.Checked == true)
                sql += "and  View1.f1<0)";//using formula field here
            rpt.SetParameterValue(0, param);
            //rpt.SetParameterValue(1, p);
            rpt.RecordSelectionFormula = sql;
            rpt.SetDatabaseLogon("cost", "cost");
            fv.crystalReportViewer1.ReportSource = rpt;
            fv.Show();
0
Hello,

Since 2 weeks I am facing a problem while generating crystal report. It is giving error.

Error:

Error in File C:\Windows\TEMP\Report1 {906DF369-197B-4021-81E4-EBE3DB5275FF}.rpt:
Failed to create the Crystal Query Engine.


Exception Details: System.Runtime.InteropServices.COMException: Error in File C:\Windows\TEMP\Report1 {906DF369-197B-4021-81E4-EBE3DB5275FF}.rpt:
Failed to create the Crystal Query Engine.


Note that, my application is in Visual Studio 2008 and windows server is 2008 R2.

Please advise how to solve this issue. It will be highly appreciate if can suggest the solution in step by step.

Thanks in Advance
0
Hi Experts,
I use Crystal Reports in my C#.Net Windows Service.
When I run my app, I get the error below:

ERROR
The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception.

Could not load file or assembly 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies.
The system cannot find the file specified.



I do see CrystalDecisions.Shared.dll in my Windows bin folder.

How can I resolve this issue?

Thank you in advance,
mrotor
0

Crystal Reports

34K

Solutions

14K

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.

Top Experts In
Crystal Reports
<
Monthly
>