[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Crystal Reports

35K

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

Need help with a Crystal Formula. I would like to get the details line shown in red to summarize the quantity shipped when the lot number is the same, regardless of the bin location (shown in black next to it). I tried adding a group for the Lot Number, but then it messes with the quantity shipped per Line Seq. Maybe this is best handled by a conditional suppressio formula?

Example attached.
Scan.pdf
0
Learn Ruby Fundamentals
LVL 12
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

I'm trying to use the Running Totals in Crystal Reports 8.5 to get the minimum value of a series of fields.

Ex.:

A - 500
B - 300
C - 400


I need to get the B - 300 line.

Is there anyother way to figure this is out without using the Running Totals?

Thanks in advance
0
I want to be able to create a crystal reports cross tab week comparison from last years order sales to this year order sales for a specific month.
Eventually I want to compare more then 2 years but for now I want just two. The schema should look something like this.

                           MONTH OF SEPTEMBER COMPARISON
            1st week                2nd week      3rdweek                 4th Week
2017     $3,000                  $3,200                $3,000                    $4,000                
2018     $4,000                  $3,500                $3,500                    $4,100
0
BarCodes in Crystal reports:
I am trying to make my barcodes wider when using Crystal to print them.   I tried messing with the Character Spacing Exactly but anything other than 0 makes them smaller.  
My Font is an IDAutomationC128M

I am not a Crystal person and have been looking around on how to make them wider?
Any ideas would be appreciated.
Thanks
0
I have an issue with the link between VB.net and Crystal reports.

I want to produce an invoice for a customer.  I have produced the invoice on crystal reports and I have produced all data needed on VB.net but how do I send information from VB.net to Crystal reports.  Obviously I need to pass data per invoice number and client using the software. example companycode ="XC029" invref = "1500"

       Dim directory As String = My.Application.Info.DirectoryPath.Replace("\bin\Debug", "").TrimEnd()
        Dim cryRpt As ReportDocument = New ReportDocument()
        Dim InvRef As String
        Dim showMsg As Boolean

        cryRpt.Load(directory & "\rptSalesInv.rpt")
        InvRef = txtSIInvRef.Text
        cryRpt.RecordSelectionFormula = "{vwSalesInvDistinct.InvRef} = '" & invRef & "'"

        Dim crtableLogoninfos As New TableLogOnInfos
        Dim crtableLogoninfo As New TableLogOnInfo

        Dim CrTables As Tables
        Dim CrTable As Table
        Dim s As String = ConnstringSQL

        Dim parts As String() = s.Split(New Char() {";"c})

        Dim crConnectionInfo As New ConnectionInfo()
        With crConnectionInfo
            .ServerName = parts(1).Split(New Char() {"="c})(1)
            .DatabaseName = parts(2).Split(New Char() {"="c})(1)
            .UserID = parts(3).Split(New Char() {"="c})(1)
            .Password = parts(4).Split(New Char() {"="c})(1)
            .IntegratedSecurity = False
        End With

        CrTables = …
0
I'm trying to create a new report using Crystal Reports 2008.
The issue I'm having is that the main link in an oracle db is string format and the other db has the field I need as a number.
Is there a way I can use the cast command to link the 2 fields?
If there is a different way, I'm open to suggestions.
0
We have created a cross-tab report in Crystal Reports 14.1 pulling sales data from our Epicor P21 data, summarized annual sales by customer.  It currently sorts by total overall sales after displaying columns of annual data.  This results in a report which looks like this:

                        Year      Year     Total
Customer      Data      Data     Greatest
Customer      Data      Data     ...
Customer      Data      Data     Least

We would like to sort on the current year rather than the total.  We can't seem to find a way to do that.
0
I have to prepare a report, in which it contains nested subreports...i know that nested subreports is not possible in Crystal Reports. can some body tell me how to proceed with this issue.
I have Main Report which contains a subreports, which internally contains a subreport in it.
please help me with this!!
0
Hi All,

I have a crystal report designed in XI version. It is connected to ADO.Net source data . The data set is based on the DB from MS SQL Server. This data-set has the tables with different fields, along with table having blob field. The crystal report previews data for all the other fields properly, other than Blob field . When I try to preview the crystal report, the blob field shows the image (.jpeg) one time. if we close and open the same report once again, the blob field is showing blank.
Please refer the example from the attachment. On the right side is the preview of CR with the image and on the left side is CR without image when i closed and opened the preview.

Can anyone suggest , the possible reason and a solution for the issue ?
Many thanks in advance.

Regards,
0
does anyone know where I can get a copy of Crystal reports 8.5 or how I can change the font on an old crystal report.

I have a REALLY old application that only works with 8.5, and after this version the file format changed, I need to edit the reports but editing in a later version means the reports are no longer compatible with my application.  I have no option to upgrade the app.
0
Microsoft Azure 2017
LVL 12
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

I have a crystal report, in which there are many sub-reports.

Based on the Report selected on the screen, the corresponding reports only should open and the others which are not selected shouldn't be visible.

please help me with this.
0
Crystal Reports - Cross Tab total for Credit Rebills.  I can't get the formula right to get the total % to work out.  

I need the total columns to take the total credits divided by total Invoices.  Right now the field is adding the total percentage across and the amount is not correct.  Example attached. Picture with example
See example attached.  I have also attached the .rpt saved with data.

Thank you.
AR_CreditRebill_LFW_Exchange.rpt
0
Crystal Reports 2016

I am trying to generate a report to display stock which has been received more than one - all will be unique items which have a "receipt" and a "despatch"

what I'm after is reporting those which have been received despatched then received again (those with simply a receipt despatch can be ignored.

the result being a small list of items

the actual history database is huge so I am only looking to search a smaller amount but do need to consider if items have been received prior to my date range (ie 90 days)

any suggestions appreciated

thanks
0
I have a report that is using  calculated member in a cross tab.  The "insertion formula" is making it show up after a specific column
"GetRowGroupIndexOf(CurrentRowIndex) = 1 and GridRowColumnValue("glaccnttype.glaccnttype_id") = "Overhead Taxes - Income""

Problem is this Row of Data  "Overhead Taxes - Income"" is not in all reports depending on date range ran.
This is an income statement and depending on the date ranges there are variable numbers of Rows of data.

How do I write the insertion formula to simply have it display at the end of the report?  
My three calculated members are below and each has the exact same insertion formula and show up when the account "Overhead Taxes - Income"" displays

Total Revenue
Total Expense
Net Revenue
0
I had this question after viewing Append all database values in Parameter not bringing in all data..

I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database.  If I create an "ALL" selection and run the report it does bring in all sites.  Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.

It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing!  Not sure if this has an effect.

I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.

I have come to the end of any other solutions?

Any help is much appreciated!
0
This is in Crystal Reports 11.0
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
               TVS123      tuition Fees      90.00
               TVS356      tuition Fees      75.00
               TVS255      tuition Fees      55.00
               TVS285      tuition Fees      65.00
        Group3(Fee_type)- Other Fees
               L342 extras fees      2.00
               L852 extras fees      7.00
Group-2 NULL
      Admin Fee      100.00

In the above scenario, I have created, Group 2(sp_code) and Group 3(Fee_type).  My Group-3 is in specified order.  Group-2 is in ascending order.  
My issue here is, I want to display Admin Fee in “Other Fees” group like  below.  When Group-2 became NULL, it is displaying Admin Fee as a different Group-2 section, I don’t want to display Admin Fee as different group section.  I want to display as below.
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
                   TVS123      tuition Fees      90.00
                   TVS356      tuition Fees      75.00
                   TVS255      tuition Fees      55.00
                   TVS285      tuition Fees      65.00
        Group3(Fee_type) - Other Fees
                     L342 extras fees      2.00
                     L852 extras fees      7.00
                   Admin Fee              100.00

Is that possible at all to display Admin Fee under Other Fees? Can anyone please help me?
Thanks in Advance.
0
I have created a report that runs as planned in crystal reports 2016 SP4 and through the proprietary software using  Crystal Reports runtime 2008 SP5.  On another computer using the proprietary software using  Crystal Reports runtime 2008 SP5 the report will give me different data each time it is run.  When I first ran the report it showed only data where all the linked fields matched, which is not correct( attached file called incorrect.pdf.)  Then I ran it again and it gave me the correct information,(attached file called correct.pdf).  
The report has 6 tables Customer, Sales rep, Order, Dr, and customer type and are left outer joined, not enforced from customer to the other tables.

The Data base is MySQL

It is the same report  Incorrect ran first, then ran correct right after and different results.  
incorrect.pdf
correct.pdf

Thanks in Advance
0
Visual Studio 2005 crystal reports only shows half of print preview, The right half is faded out...
See attached.

Any ideas?
CR-Report.pdf
0
Crystal report not open more then 75 times
0
Become a Certified Penetration Testing Engineer
LVL 12
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

when i print crystal report more then 75 times then it give error
0
I need help with doing a Crystal Reports Label. I have messed with this so much this morning and cannot seem to get this to print as I need. I get one label print and then it spits out 7 additional labels. If someone can help and attach a file with the 3 basic values (I can rewrite my SQL) for this dimension, I would forever be grateful. I just need it to print one label and it keeps printing the additional labels.

The Zebra Label Printer is LP2824 Plus.
https://www.zebra.com/us/en/support-downloads/printers/desktop/lp-2824-plus.html

The label dimension is 2 and 1/4 by 1 and 1/4.

I need on the label the following:

Name
Address
City State Zip
0
Here is my data:
country  category   description
US       9          dvfbwrtbrt sd rd
US       9          zdf s tbr t bs th sd
US       9          fdbwrt yr ns t s
CZ       9          tyjnd tyn etyn
US       11         xcbf dg erg
IT       11         far vwer  hade h

Open in new window


In Crystal Reports I am trying to create a box label that has "Box 1 of x" but in the DETAILS section of the report.
The number of boxes is determined by the count of the category field

So for example, the first 4 line items are all category 9.
There are 4 records so there will be 4 boxes
The next 2 records are category 11, so there will be 2 boxes.

When the value of 'category' changes, the total resets.

And so the labels will print like this:

dvfbwrtbrt sd rd
Box 1 of 4

zdf s tbr t bs th sd
Box 2 of 4

fdbwrt yr ns t s
Box 3 of 4

tyjnd tyn etyn
Box 4 of 4

xcbf dg erg
Box 1 of 2

far vwer  hade h
Box 2 of 2

I am able to create a label that shows the "Box 1 of N" but the only way it works for me is if I place that in the group footer section of the report. I want it to be in the details section. (the header and footer are empty).
0
When I do a parameter field and choose the list of values to be dynamic, it only shows a certain amount of the list when the user runs the report. How did I get the entire list of values to return rather than only a certain amount?
0
I have a .Net windows app.  It creates a Crystal Report in word.  It pulls data from a datasource and displays it in the report.  Sometimes the field is null and a textbox isn't created in the word document.  Is there a way to create the textbox even if the field is null?

Thanks
0
I have two groupings.  Student i.d. and detail code.  Some detail codes are the same amounts, which is an User error so my dollar amount is in my GF2 section.
I want to sum all amounts by i.d
What is happening when I sum is that I am seeing the wrong amounts because it is summing what I am trying to supress.
What am I missing?
Word doc. attached.
Thanks!
0

Crystal Reports

35K

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.

Top Experts In
Crystal Reports
<
Monthly
>