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

I have a stored procedure in Oracle that I wish to use for a query in Crystal Reports for visual Studio.

The procedure is as follows - that works fine for dates.  

Dow, If I wanted to create a parameter for, say, StyleNo, however the styleNo could have multiple paramaters OR be null, i.e. Parameter optional in Crystal, how could I go about doing that?

Thanks a million

create or replace procedure pr_TopMerchSales(DateFrom IN Date, DateTo IN Date, prc out sys_refcursor)
is
begin
  open prc for
  select  Dept
      , DIV
      , StyleDesc
      , StyleNo
      , vendor
      , Round((select sum(V.qty) from V_TOP_MERCH_SALES V where V.vendor = I.vendor and I.Dept = V.DEPT and I.DIV = V.DIV and I.StyleNo = V.StyleNo and V.CREATED_DATE >= trunc(DateFrom) and V.CREATED_DATE <= trunc(DateTo)),2) as QtySold
     
from CMS.INVENTORY_V I
where I.ACTIVE = 1
group by DIV , Dept, StyleDesc,StyleNo, I.Vendor

end;
0
Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

I had this question after viewing How to configure crystal reports viewer activex so that I can open a crystal report from within access..

How to open crystal report 11 with form access 2016 ( code VBA ACCESS )
Thanks
0
I have a string field of high school gpa which is 4 characters long, i.e., 4.00
I created the tonumber formula on the field.
I need to pull a range from 2.31-2.40 so I say @hsgpa is between 2.30 and 2.41.
It is pulling students with a high school gpa of 2.41 and I don't know why?
0
Gurus,

I have a report with 3 detail sections (so I can best format variable subreports).  The main detail section contains a few fields and detail A contains a subreport and detail B contains a subreport.  I am suppressing sections A and B if the subreport is blank but I need to suppress the main detail section if BOTH are blank.

What's the best way to do that?

Thanks in advance!
0
I have a crystal report with decimal number in it (.34) as it is in the report but I want to display it like this (.3400).


Note: I Edit Format Object in  Number Tab to (-1,123.0000) but still NOT working, I still have (.34)  .
0
I am trying to remove the Aging Basis parameter from the below statement.  
Can anyone tell me why I'm unable to remove the parameter from BooleanVar field?  I don't understand what's defining how many parameters there are...
Thanks!  
 
WhilePrintingRecords;
Global BooleanVar CustomerWillShowDetail := tsarCustomerDetailWithRetainage({@tsDataFolder}, {@tsFileName(ARA)}, {@tsFileName(ART)}, {ART_CURRENT__TRANSACTION.Customer}, {?Aging Date},{?Aging Basis}, {?Include Retainage?}, {?Unpaid only?}, {?Include Finance Charges?});
0
In a crystal report I'm wanting to suppress a group header and footer if the results of the total debits, credits and Ending Balance is equal to zero on all three fields as shown in the highlighted in yellow example attached.  you can see where the totals for these accounts in the debit, credits and Ending Balance are all zero, hence I would like to suppress the header and footer from printing.  If I use the following crystal syntax formula Sum ({tglTranRptWrk.AcctEndBalHC}, {@groupo1})) = 0 when I attempt to run the report I receive the following error  "There must be a group that matched this field"
0
In a crystal report I'm wanting to suppress a group header and footer if the results of the total debits, credits and Ending Balance is equal to zero on all three fields as shown in the highlighted in yellow example attached.  you can see where the totals for these accounts in the debit, credits and Ending Balance are all zero, hence I would like to suppress the header and footer from printing.  If I use the following crystal syntax formula Sum ({tglTranRptWrk.AcctEndBalHC}, {@groupo1})) = 0 when I attempt to run the report I receive the following error  "There must be a group that matched this field"
0
Hi

I have a date field in a report which I need to highlight yellow when the field contains no date. The field must retain its date format and not be changed to text for instance.

I have tried the following with the following report optuions ticked

Convert Database NULL Values to Default
Convert Other Null Values to Default

I have used the following in Format Field > Border > Background

If isnull({Command.draft}) = true then crYellow
else if {Command.draft} = date(0,0,0) then crYellow else crwhite

Using the above it still stays white instead of yellow

Thanks
0
We have several SQL tables we need to reference for a Crystal Reports report.  There is a join we need to make between two tables where the leftmost 5 characters of field A in table AA need to be joined to field B in table BB.  This same statement needs to also join to table CC to grab field C.  Tables BB & CC share a common primary key (PK).  All of this needs to be done in a Command due to odd indices.  CR doesn't like the following SQL:
SELECT LEFT(AA.A,5) AS match, CC.C
FROM AA LEFT JOIN [match]=BB.B
INNER JOIN CC.PK=BB.PK
Assistance would be greatly appreciated as I am tearing my hair out over this.
0
Cloud Class® Course: Ruby Fundamentals
LVL 12
Cloud Class® Course: 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 wonder if I can get some help migrating a VB6 project with Crystal 8.0/8.5?  These are windows' 10 PCs.

The reports are working in the development machine but the production machine keeps having problems with an 20599 error.

I checked the ODBC 32bit connection and that is connecting fine.
0
Hello Experts,

I had prepared a cross tab report for Purchase Quotation comparison, on which I need to have the total of Best price as the column total. But I cannot make the calculation as column value and total value is taking the same formula. (Min and Sum).

Can anyone suggest the solution for the attached report. I am pasting my requirement as below.

1) I need to have total of line total of best prices
2) Total for each supplier prices

Comparison SheetPurchase-Quotation-Comparison-New-Am.rpt
0
I have a report that has a group by region. The first group and details extends to 2nd page but I want to have 2nd page blank and want to have it printed on 3rd page. I need to print on an odd page on a one-sided special paper (I must not print on back of special paper ). Means, my first page should print on special paper page1, extended group should print on page3. Another new group should start on page5 of special paper since page 4 is blank.

Means, I need to print page1, page2 blank, then page3, page4 blank, then page5. I also need to print every new group on a new page.

I cannot control from Visual studio programmatically. Please advise it from Crystal.

I tried lot of things already, Added this formula too. Nothing worked. Please help.

Remainder(PageNumber,2) <> 1. Thanks in advance.
0
Im getting the value like 2hrs 122 min and i need the solution like 4hr 2min what formula i need to try?
0
I am trying to create a crystal report. I have customers, work orders and the date enter for that work order. I am trying to show the new customers in past 3 years. I can't just exclude date enter below 2015 and show customers above the year 2015. if a customer been using us from 1990 and still using us will also appear if I exclude date enter below 2015. since some work orders are there for that customer after 2015. I want to see the minimum date enter and exclude those customers whose minimum date is less than 2015.
 Problem with that is I can do filters on summarized values like sum, max, min in the crystal.
Is there any other approach for this?
0
I need to extract the ten spaces after MAGNESIUM ALLOY: from the comment text field. Below is an example of one record from the comment text field.

Plate Number: 1                                                      
MAGNESIUM ALLOY:         Type: 6% Mg Fe- Si                          
SILICON RAISER:          Type: Low Ca & Al - 75% FeSi                
IN-STREAM INNOCULATION:  Amerinoc        SETTING:   5 (gram/sec.)    
TEST BAR REQUIREMENT: Daily
0
I am trying to get the Head, Subhead and Body fields to appear on the same page. With the current report design, the Head, Subhead appear on one page and the Body field appears on a separate page. I worked with the Keep Together feature in the Section Expert without success.

Please help me resolve the problem.
DesignCover_EE.rpt
0
I am trying to write a formula that will suppress records that have a null value for the Task_Date field but I get an error. Please help me resolve the error.

I created the following formula for null date values but I get a "a number, currency amount, boolean, ..." error.
Formula: if {Task.Task_Date} = NULL then 1 else 0

In the screen shot, I only want to display the Task 1 record, which has a 1-1-18 date.
DesignReport
0
Hi.  I've created a report in Crystal reports Developer 11.5 that includes a few grouping levels, in case this makes a difference...  I have one column of data that happens to exist in grouped data that displays in CR print preview but does not print on the physical report.  This data did print at one time but has not been printing for some time.  Not sure when it actually stopped.  I included a screenshot of my design view to show as example.  Red square shows column of data that shows up in preview but not on actual report.   What might be  causing this?
CRRpt_0518.docx
0
Cloud Class® Course: Microsoft Exchange Server
LVL 12
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

hi

I want to build a chart in crystal reports that will show 2 lines on a line chart for the different years for a set of data

Line 1 represents 2017
Line 2 represents 2018

the columns are the weeks for each year

see attached for a sample of the data and also a sample of how it looks in excel


thanks
Mike
sample.jpg
sample-excel-chart.jpg
0
Crystal reports Server 2013 suddenly lost contact with CMS data.  That also took out the administrator's password and access.  How to resolve short of reinstalling
0
Hello,

I am wanting to create a crystal report where a User can select various data fields from a table called PRODUCTS, (EG Product Code, Sales Info) then have a field to display the counted characters on the second field. So you would have:

Product Code     Sales Infor                           Counted Characters of Sale Info
ABC123                Is product is sold online    25

Can this be done?

Thanks.
0
LastDate04/16/1804/23/18LastTime5327834142LastUserTGIBBRMPCOMHERRRMPCOPkgcode26

Need to split the above string field into multiple records:

LastDate 04/16/18 04/23/18
LastTime 53278 34142
LastUser TGIBBRMPCO MHERRRMPCO
Pkgcode  26
0
Hi,

I've installed Crystal Report for Visual Studio on my Windows 10 laptop but it doesn't allow me to use the editor.

Hope someone can help me with my problem

thanks
0
Crystal Reports Data Connection.  I have 2 tables (Dynamics GP in SQL) in the same database one the Current Year (GL20000) and the other the History Table (GL30000).  I need to pull them onto the same report to do percentage comparisons.  I have another table that is being used for each of them that has the description information for the Location.  I can seem to get this setup properly.  I get the Current all setup and it brings over the data I expected.  Then I pull the summary field over to the report for the History and it severely distorts the numbers.  Causing records to be counted several times?  Please help me figure this out...hopefully without using a subreport.

Thanks
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.

Top Experts In
Crystal Reports
<
Monthly
>