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

Dear Sir , I am using below mention code for pdf generation from crystal report. But in this process every pdf is opening in the pdf reader. I don't want to open the every file.so please suggest solution.

 Report.ExportOptions.ApplicationFileName = Text3.Text & "\" & nFileName & ".pdf"
                Report.ExportOptions.DestinationType = crEDTApplication
                Report.ExportOptions.DiskFileName = Text3.Text & "\" & nFileName & ".pdf"
                Report.ExportOptions.PDFExportAllPages = True
                Report.ExportOptions.FormatType = crEFTPortableDocFormat
                Report.DisplayProgressDialog = False
                Report.Export False
0
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

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
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
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
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
Cloud Class® Course: Amazon Web Services - Basic
LVL 12
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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
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
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
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 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
I have a WPF MVVM application that I'm porting from a WINFORMS existing app. The reporting of the WINFORMS app uses both SSRS & CrystalReports for reporting.  Looking to convert these report in the MVVM pattern. I want to produce the reporting output on the server thru the Web Service and send back a link to the client ReportViewers. Does anyone know if possible and if so any examples?

Thanks
Chuck
0
I am using Crystal Reports 2016 and Microsoft Sql server 2016 with Always Encrypted on some columns . How can I programatically add to string connection properties
"Column Encryption Setting=Enabled" to enable the report to obtain the info decrypted ?
My actual code is:
 Dim logInfo As New CrystalDecisions.Shared.TableLogOnInfo
 logInfo = CType(_myReport.Database.Tables(0).LogOnInfo.Clone, CrystalDecisions.Shared.TableLogOnInfo)
logInfo.ConnectionInfo.DatabaseName = connParm.InitialCatalogue
logInfo.ConnectionInfo.ServerName = connParm.DataSource
...
  _myReport.Database.Tables(0).ApplyLogOnInfo(logInfo)
0
I want pass paragraph  text in crystal report using parameter or any other option.

For example I have Text like,
I am payal.
I am developer.
please help me..to find my solution.

I want display like in report
Sr no           Name                  description
1                  ACX                      I am payal.
                                                 I am developer.
                                                 please help me..to find my solution.
2                  XXX                      I am payal.
                                                 I am developer.
                                                 please help me..to find my solution.
3                  DFE                      I am payal.
                                                 I am developer.
                                                 please help me..to find my solution.
4                  Acx                      I am payal.
                                                 I am developer.
                                                 please help me..to find my solution.
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
>