Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

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

Hello,

I'm trying to sum up a field from a sub-report and am not sure how.  This report is a list of steel profiles, then for each profile, it has a subreport that gives a list of what needs to be cut in that profile.  For each elevation listed, I want to tally up how may profiles I'll need.  

I've attached a PDF and the report so that it's easier to explain.

 EE---Cut-List4.rpt
cutlist.pdf

Thank you!
0
Ask an Anonymous Question!
LVL 10
Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

I had this question after viewing Split function in Crystal Reports.

Hi,

i have modifiers:

Fresh Veggie Garden(v) Modifiers:, green leaves, tomato, onion, cucumber, carrot, house aioli

separated with ,
there is not fixed amount of array of strings after split. it can be 1 or it can be 5 or 10 strings after it splits.
i want all in a new row,
green leaves
tomato,
onion,
cucumber,
carrot,
house aioli

please i need all these printed.
Thanks.
0
I have a dbf table that acts as a audit table and captures info when ever someone changes a field for any customer record. But it doesn't just capture the fields that were changed. When one field in a record is changed, all fields in that record are written to the audit table. The audit table captures the state of the record data before the person made the changes.

So what is the best way to compare each field in the audit table to identify which fields are different/changed from the previous instance? For example, the way the audit table is configured now is that if a customer record was modified and saved three separate times in the main database the changes will be written to the audit table, but instead of just capturing the changed fields, it captures all of them...and there is no way to quickly identify which field in the audit record was the one that was modified.
0
I have a c# program that is using crystal report and have a few questions.

1. i want to build this program to install on other computer but when i build it it cannot find the report. where can i put the files that the program can find the report. The report is in the same folder.

2. how can i have it that the user does not have to type the password in every time?

the code is below

 cryRpt.Load("C:/Users/Ron/Documents/Visual Studio 2015/Projects/MarrhvilleMeat/MarrhvilleMeat/Accounting.rpt");
            cryRpt.SetParameterValue("@StartDate", begDate);
            cryRpt.SetParameterValue("@EndDate", endDate);
            crystalReportViewer1.ReportSource = cryRpt;
            crystalReportViewer1.Refresh();
0
Hi there,

I have a report that prints out a simple ID and name - but the ID needs to be part of a magnetic stripe.  I have tried several options - one being using OLE, linked to an external RTF file.  The external file contains ~SP:M:L:1: {CnMem_1.CnMem_1_Membership_ID}?

It triggers the printer to identify that mag stripe coding but cannot identify what to do with the membership field. The printers displays a read/write error.  

I had tried several other options but the same issue, it cannot identify what to do with the membership field,

Does anyone have any ideas? Thanks very much - CS
0
Hi all,

We have a bit of a strange issue after an upgrade of SAP Crystal Reports for Visual Studio. All applications have build issues after the upgrade because all of the "CrystalDecisions" DLL's seem to have disappeared after the upgrade.

We were running Version 13.0.10.1385 and all was fine with the DLL's all being located and available for referencing. We upgraded to 13.0.21 and all of the DLL's no longer exist on the machine, and all applications using Crystal Reports now have build errors due to the fact that the CrystalDecisions.CrystalReports.Engine.dll, CrystalDecisions.ReportSource.dll, CrystalDecisions.Shared.dll have all disappeared!!

I tested further by removing the new version and replacing the older version and all the issues went away and all was good again. I then reinstalled the new version and the issues come back. There is no error from the install, and it claims that all was successful. I have searched the entire machine and there are no CrystalDecisions DLL files anywhere, so it's not that they have moved them.

It is all very strange ...

Steve
0
Hi There

I have added a picture in the detail section of a report and add the following into the graphic location, on the format editor
"E:\Data Bases\Small DB's\Images"+ GroupName ({F4101.IMLITM})+ ".jpg"

The picture is coming through as a static image only and will not change. The pictures have been named the same as the group name records.

What am I doing wrong?

Cheers

Steve
0
Hi

I had this question after viewing https://www.experts-exchange.com/questions/28963434/Passing-Linked-Array-Values-to-SubReport-in-Crystal-Reports.html URL

I am facing similar problem. Could you please provide the detail steps of creating the global variables as well as the linking parameters as i was unable to follow the given steps without reference report.

Thanks in advance.
0
I want to make a bill like slip using crystal report. Problem is, rather than showing the items bought, it shows all the items in the database.

Rather than the report showing this
---------------------------------------------------------------
qty | unit | particulars| unit cost | amount
 ----------------------------------------------------------------
1        A01    book                 10             10
2       A02     pencil                2               4



it shows
---------------------------------------------------------------
qty | unit | particulars| unit cost | amount
 ----------------------------------------------------------------
1        A01    book                 1                   10
2       A02     pencil                2               4
3       C01     uniform            6                18
1       D02     eraser                1             2
0
dear all

i have a web application where i have created a webform where i dragged and dropped inside a  crystal report viewer Version=13.0.2000
in order to load a report.
i need to know the time that takes a crystal report to load the report
i am using the below command:
 With CrystalReportViewer1
                .ReportSource = CrReport
                .ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None
                .ToolbarImagesFolderUrl = "~/Images/ReportToolbarImages/"
                .ToolPanelWidth = 0 'to hide parameter panel, do not open group tree
                .HasCrystalLogo = False ' to remove log sap crystal report from the viewer
            End With
how can i trace the performance of crystal report viewer.
0
Free Tool: SSL Checker
LVL 10
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.

Hello My requirement is i have to create sub report using hyperlink with another report element option. When i read the document i didnt understand much as it says source and the targets report to be added...but where? I am using crystal reports 2014.

my requirement is when i click a field in the main report it should open the details in the second report.
Another-element-in-hyperlink.png
0
Using SQL server 2012 and Crystal 2013 SP 7 version 14.1.7.1853.

Have a sql table with 2 fields a DocId  (unique, string) and FilCtn (varbinary (max)) nulls not allowed.  When I bring these fields into Crystal the 1st field shows fine.  The FilCtn comes into Crystal as field type Picture but no picture shows on the report.  These were pdf files converted and put in sql field and client would like to see them on a report.  Image a report like Employee data and employee photo.  Have tried different types of ODBC connections (Sql server, Sql Native 10, etc) but that didn't work.  Any help would be appreciated.  BTW are points still being awarded on some criteria based on the Priority level or can I declare number of points?
0
STDSTKNBR      SYSPARTNBR            VENDORNBR
12                      3659                     909
59                      2851                     0
12                      1695                     0
59                      02659                   909
17                      32698                   909

I have a data table with the above data sets.  I m trying to build a filter or formula that will show me the SYSPARTNBR (part number) which has a VENDORNBR (Vendor Number) of 909 but also is associated with STDSTKNBR (Standard Stock Number) 59.  The part may be associated with multiple Standard Stock Numbers (each of which should be associated with Vendor Number 909) but Standard Stock Number 59 will never have any Vendor 909 association.

The attempts I have made have simply removed items not associated with Standard Stock List 59.  I basically need the formula that will show me all parts associated with Vendor 909 AND are associated with Standard Stock List 59 as well as any other Standard Stock List.  Any ideas?  Thanks!
0
Please see image i want a remove line after summary of amount please help me.
0
We use a cloud based finance system, and as part of this we use Crystal reports.  I have recently established that whilst the application and database servers are our own dedicated servers, the Crystal RAS is shared with other cloud provider clients.

I have a few issues, 1 – I know what Crystal does but don’t know the details of how a RAS server works, especially when multiple clients are using one server which will of course be pointing to numerous databases and; 2 – because of point 1, I not sure if I should be concerned about our data being accessed by other clients, for example how is our data/reports segregated from other clients?).

Can anyone help with my understanding of the technical details behind the workings of a Crystal RAS server is this type of environment and what controls we should be putting in place, getting evidence of from the provider to ensure that our data is still secure from unauthorised access?

Many thanks.
0
Hi,

I read the previous thread on this error and am getting a similar problem, the only difference being that sometimes it works and sometimes it doesn't - the  only consistency is that it fails when running to the remote apps server over a slow internet connection whereas if the connection is relatively quick, the error goes away.  Could the speed of the network have a bearing on the problem, bearing in mind that the application and CR run-time are both installed on an apps server and the users connect via RDP?

We don't have the option of migrating to a new version as our application is written in VB6 and uses the Crystal hook at run time.

Any assistance or suggestions (clean!) would be greatly appreciated.
0
I am using crystal XI.  I am trying to determine the easiest way to do the following report. Here is the data that I have: Student ID, School, Student Name, Date i.e. 09/27/2017 and Attendance Code i.e. Present.  

The state is asking for the report like this.
M/D  01 02  03   04
JUL    1A       NS   VA
AUG  AB

Sample report
I have the formula written to convert the attendance codes, I have the formula to separate days and months.  I have 2 groups: Group1: School (sort alpha order) Group2: Student ID (sort ascending). Where I am struggling is determining the best way to create the grid, any advice/help is greatly appreciated.  One thing to note I only have front end access to the database, so I export fields using the front end export functionality of the database.
sample-attendance-report.JPG
0
Trying to use crexport on a crystal report within SSIS and receiving an error, "Error in File, Failed to retrieve data from the database"
I have other reports working fine from the same SSIS job
It doesn't work from the command line, either, so I am assuming it's something in the report
It DOES work from crystal reports, and doesn't have a stored procedure, only 3 tables

Any ideas on what I can check?
0
I inherited some web application that seems to be using some reports within aspx pages. I am trying to migrate them to new server. When page in question is browsed on new server it pops up with windows username and password dialogue box.
Has anyone encountered this before?
0
Free Tool: Site Down Detector
LVL 10
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Dear Experts,

My report has Three Page Footer Section (a, b, & c).

Find the attached report file.

While printing the report the page footer b's : (which is printed only at last page.) space are eliminated and page footer c is printed. So there some blank spaces under footer c section.

I want to print the page in that way that other sections other than footer are expanded till blank and page footer a and c printed.

crystalpage.png
pdf-print.png
Please Help.

Regards,
D Patel
Sample.rpt
0
hello, our aging hotel software fidelio suite8 is running reports from an old Crystal Report ver 8.5 / 2012 runtime also (?).  I can send simple formatted email / reports made from Crystal in *.rpt format.

I would however like to use the latest (or at the very least, modern) newsletter formats with css etc. I would like to find out whether this be possible? Inline? or html?

My bottom line is to send a welcome letter / goodbye letter - the email format / structure will not change much. The email server is in-house.

Thanks for helping, Clifford
0
I have a Crystal Report that is pulling account, subaccount and subaccount descriptions (income statement). The subaccount name has been updated in the main system of records but the crystal report is pulling in the historical subaccount name. Updates have been made to other subaccount names and the changes are being reflected correctly in the crystal report. There is just 1 subaccount name that will not update. The formula used to pull the subaccount is: {view_GLBalance.DescriptionOf}. Has anyone experienced issues where some accounts don't update?
0
I get the error "Hour must be between 0 and 23" when a report I generated is run for a specific date range, it appears like there's a corrupted "Time" in the period given thus the error, I tried the solutions in your post  ID: 40590344· dated 2015,02,04, but the various solutions / approaches posted there created "bad date format" error. Your thoughts.

My formula is basic HHMM_to_Time(myTime)  and it works when all the times are in proper form, but it crashes and produces the error mentioned when the report is run for that specific period, and when I close out of the error I get the following;
Time_Error
Thx
0
sap Crystal server 2016, how to run and check, how to connect to Oracle, how to call the reports which is published in crs server using visual studio
0
Hi,

I've a problem that I'm unable to solve, here is the problem: Under Delphi and ussing VLC for Crystal XI, I want to read the configuration of printer in the report, and if I have, initialize a TPrintDlg with the read printer, the dialog initialize well but when I use the response I've an AV, here is my code (one of them). This code run when the user clic on the printer setup button on Crystal Viewer.

procedure TdmlReportServices.crpMainwOnPrintSetupBtnClick(WindowHandle: HWND; var Cancel: Boolean);
var
  PrintDialog : CommDlg.TPrintDlg;
  InitializeDeviceMode, ReturnDeviceMode: PDeviceMode;  // Hay que usar dos, una para inicializar y otra para devolver config, si no error de punteros

  sName, sDriver, sPort: String;
  PrintDlgInitialized: Boolean;
  hInitializeDeviceMode: HGLOBAL;
begin

  // Si la versión del componente de la VCL es el 11
  if crpMain.Version.Crpe.Major = 11 then
  begin
    PrintDlgInitialized := False;

    // If the report has some printer configuration
    if crpMain.Printer.RetrieveFromReport(sName, sDriver, sPort, InitializeDeviceMode) = True then
    begin
      // Se ha podido recuperar la impresora del report
      if Assigned(InitializeDeviceMode) then
      begin
        PrintDlgInitialized := True;
        PrintDialog.hDevMode := HGLOBAL(InitializeDeviceMode);
      end;
    end;

    hInitializeDeviceMode := 0;
    Cancel := True; // Cancelamos el cuadro de diálogo por defecto de Crystal (Preparar página)…
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
>