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

This is probably a strange request as most want to suppress duplicates, I on the other hand want to duplicate a record based on number of occurrences per year.  So if the activity is weekly I should see 52 records with a generated due date based on frequency code and the last  duplicated records calculated due date.

I am trying to forecast a preventive maintenance activity based on frequency code such a YR, MO, DY, WK, etc.

WhilePrintingRecords;
DateVar NextDt;
StringVar IntervalType;
NumberVar Interval;

Interval := ToNumber({FREQUENCY_UNIT});

if {FREQUENCY_UOM} = 'YR' then IntervalType := 'yyyy';
if {FREQUENCY_UOM} = 'MO' then IntervalType := 'm';
if {FREQUENCY_UOM} = 'WK' then IntervalType := 'ww';
if {FREQUENCY_UOM} = 'DY' then IntervalType := 'd';


NextDt := Date(DateAdd (IntervalType,Interval,{@Due Date}));

NextDt;

Hopefully this makes some sense.
0
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

I have an old version of Business Objects Crystal Report Server Software that we are trying to reinstate for Project Management.  My owners don't want to spend the money for the latest/greatest in similar software.

I have everything running except for the CMC.  As soon as I start it, it falls on its' face and goes right back to a stopped state.  When I go to check the connection for the CMC I get the following pop up:  CMC Generated Error
The event logs list the following, similar, error:  Eventvwr Error
The environment is a virtual Windows Server 2012 R2 with a SQL Server 2016.

I have deleted and added the DSN numerous times with different drivers to no avail. (In the 32 Bit ODBC)

It should be noted that when I set up the DSN, and the connection in the CMC, it successfully connects to the database.  The error only happens when I go back to the connections tab in the CMC.  

The only possible issue I thought about was that this is a 64 bit virtual and the software is 32.  However, I have never had an issue with this in the past on physical servers. (64 vs the CS 32 software)

Is there a way to see what the CMC is submitting for the connection string?
0
Hi Experts,

i have to add some custom code to SAP gui scripting code, we have customized code like the script read the data from the excel.
but we want to add more customization in the code.

If Not IsObject(application) Then
   Set SapGuiAuto  = GetObject("SAPGUI")
   Set application = SapGuiAuto.GetScriptingEngine
End If
If Not IsObject(connection) Then
   Set connection = application.Children(0)
End If
If Not IsObject(session) Then
   Set session    = connection.Children(0)
End If
If IsObject(WScript) Then
   WScript.ConnectObject session,     "on"
   WScript.ConnectObject application, "on"
End If

Dim cnnExcel, rstExcel
Dim strExcelFile
strExcelFile = "C:\Users\kt5775\Desktop\Engie work\SAP info\Tcodes input.xlsx"

Set cnnExcel = CreateObject("ADODB.Connection")
    cnnExcel.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=" & strExcelFile & ";" & _
               "Extended Properties=""Excel 8.0;HDR=NO;"""

    Set rstExcel = CreateObject("ADODB.Recordset")
    rstExcel.Open "Select * from [Sheet1$A1:G1000]", cnnExcel, adOpenStatic

session.findById("wnd[0]").maximize
Do Until rstExcel.EOF or UCASE(rstExcel.Fields(0).Value) = "LAST"


session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").text = "/npfcg"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/usr/ctxtAGR_NAME_NEU").text = rstExcel.Fields(0).Value
session.findById("wnd[0]/usr/btn%#AUTOTEXT003").press
0
Hi, I Used Crystal Report in C# Desktop application. My database is in access and i set Jet Password there.Can you help me to set Jet Database Password dynamically in Crystal Report.
0
I have a VB.Net program that uses CrystalReports to print an ID card (CR80).
The viewer shows a portion of a full-size letter format, with horizontal & vertical scroll bars.
What programming / controls are needed to:
1. Resize margins to CR80 ~ 2.13" x 3.38".
2. if necessary, remove scroll bars.

Thank you,

Russ
0
Hi experts,

I have the following issue

I need to have my data viewed as follows
GH1   Vegetables
D:Carrots
D:Celery
D:Tomato

GH1 Beef
D:Turkey
D:Chicken
D:Beef

GH1:Oils
D:Butter
D:Sunflower
D:Olive

I need the for Each GH1 to have the data displayed as follows in a subreport1
Carrots        Celery        Tomato

I need the for Each GH1 to have the data displayed as follows in a subreport2
Turkey       Chicken     Beef

I need the for Each GH1 to have the data displayed as follows in a subreport3
Butter        Sunflower       Olive

There could be dozens of records in each GH1

Any assistance would be appreciated
0
I have an issue with Crystal Report Viewer 2013 on how it runs under IE11.
I installed SAP Crystal Reports runtime engine for .NET framework on our web server (Win 2008 64-bit) and created simple web test (Login.asp, RunReport.aspx).
Login.asp form submits parameters and pass them in RunReport.aspx where Crystal Viewer is called.
Test works, but when report generates multiple pages, page navigation (clicking "Next page" or "Previous page") courses browser history to grow.
As a result to get back to Login.asp using browser back button as many clicking required as how many pages you visited in the report.
Changing Zoom also generates extra page in history.
I tried to run this test under Chrome and experienced performance I need, visited pages were not added to browser history.
Will appreciate any advice on how to achieve the same effect when using IE.
Thanks.
0
I am trying to share a variable from a subreport with a main report in Crystal 2011. In the subreport we are using the following code;
WHILEPRINTINGRECORDS;
SHARED NUMBERVAR SAVAL := Sum ({PLS_POLICYSUBAGENT.PLS_AMOUNTT}, {PLS_POLICYSUBAGENT.PLS_VERNO})
The main report uses the following code;
WHILEPRINTINGRECORDS;
SHARED NUMBERVAR SAVAL; SAVAL;
 When we put "@SAVAL" in the main report to use in another formula the results are not being displayed. When we try to display "@SAVAL" it is not lining up with the data on the Details line. (See attached screenshot).

Can someone help me resolve this please?
Doc112.docx
0
i  am put Crystal Report Selection Formula  in Report Viewer  ASP.NET  but show error in report


Error:-
"Logon failed. Error in File GDM_Summary_Acc 4876_5784_{94B465AA-E059-4907-BB38-CB4DB4F8BDB8}.rpt: Unable to connect: incorrect log on parameters."

CrystalReportViewer1.SelectionFormula = "{ABC.Group_Name} = '" + G_Name + "' AND {ABC.GM_Date} >= Date(#" + newfromdate + "#)  And {ABC.GM_Date} <=Date(#" + newtodate + "#)";

Open in new window


and Remove this code open report with All Data....

Please Help me...
0
How can I do the following using SAP BusinessObjects Enterprise XI 3.1

a. Publish a Crystal Report. (Done)
b. Schedule the report to run once a month. (Done)
c. Save the report (pdf) to a folder in the root of BOE XI 3.1 (To Do)

The pdf should be available for predesignated group of individuals to view at there leisure.

Is this doable?  Please provide detailed steps to make this happen.

Thanks
0
Cloud Class® Course: Python 3 Fundamentals
LVL 12
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

I am using crystal reports version 13 and Visual Studio 2010. I have exported read only report version of all my crystal report i.e. rptr extension.

Now I am loading report (rptr) in asp.net page and exporting it to pdf. But it says 'unable to load report'
Please help me out.

Regards
0
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
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
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
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
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
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
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.

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
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
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
I have a cross-tab in my report.

In the row selection there are three values, Row #1: Item Name, Row #2: Quantity and Row #3: Price.  

I would like to display only Item Name after Page break horizontally. So, I go to Row #1's Right Click > Row Options  and check Repeat labels on page break.

It works fine. But Quantity and Price labels are also displayed on page break. I don't want to displayed these two labels. I just want to display only Item Name.

How can I explain this problem? Any help suggestions will be highly appreciated.
0
I have a cross-tab in my report.

In the row selection there are three values, Row #1: Item Name, Row #2: Quantity and Row #3: Price.  

I would like to display only Item Name after Page break horizontally. So, I go to Row #1's Right Click > Row Options  and check Repeat labels on page break.

It works fine. But Quantity and Price labels are also displayed on page break. I don't want to display these two labels. I just want to display only Item Name.

How can I explain this problem? Any help suggestions will be highly appreciated.
0
Hello Experts,

I have a problem with deploy a desktop application in a  client machine without installing crystal reports or visual studio.

I searched on the internet and i find a lot of suggestion , but i can't find the correct way ( i can't find the files of runtime for crystal reports)

Thank you.

Regards,
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
>