Improve company productivity with a Business Account.Sign Up

x

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

Im trying to open crystal report in  crystal report designer tool using process

below  is method im trying:

button_clickevent()
{
                            OpenDesigner(@"C:\MyReports\Report01\myrpt.rpt");
}

  static void OpenDesigner(string file)
        {
            ProcessStartInfo startInfo = new ProcessStartInfo();
            startInfo.FileName = @"C:\Program Files (x86)\Business Objects\Crystal Reports 11.5\crw32.exe";
            startInfo.Arguments = file;
            Process.Start(startInfo);
        }

It opens Crystal Report Designer but fails to open "myrpt.rpt" , Gives the following message [CANNOT FIND THIS PATH, VERIFY THE CORRECT PATH AND FILE NAMES GIVEN]

But the path is correct as well as the file name.

Kindly advice
0
Free Tool: IP Lookup
LVL 12
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

how to print duplicate data in 1 page
0
Attached is the Powershell error I am getting when I try to run a Crystal Report from Powershell.

Can someone tell me how to fix this error?  I am getting the script from a google blog.

Thanks

Glen
PwrShl_Error.txt
0
Crystal Reports 2016
SQL 2017

I am using individual running totals that are based on a value called "Categories" that are used to count all matching records for the category.  The issue I have is a customer can have any number of categories and that means each of them would need a customized report just for them.  What I want to do is have the running totals dynamically change based on the number of "Categories"


Example Categories found in

Customer A:  Database                     Customer B: Database

{ListFruit} = 'Apples'                           {ListFruit} = 'Apples'
{ListFruit} = 'Oranges'                        {ListFruit} = 'Oranges'
{ListFruit} = 'Cherries'                        {ListFruit} = 'Grapes'
{ListFruit} = 'Grapes'

So the display would look like this.

Apples    100                                        Apples       20
Oranges   40                                        Oranges      2
Cherries    20                                       Grapes    100
Grapes        6

As you can see above Customer B does not display any running total for the category Cherries because that category does not exist in their database.
0
Crystal - Need to return all data that is Left, 6 of the string.

Example:  227800kc04142

I want to return "KC04142"

I have found several MID functions but non based on length.
0
0
I want  sum of QuantityPerPallets,Pallets,NetWeight,GrossWeight according to group by  ContainerNo , Departmentseal, LinesealNo wise in crystal report .I have attached the table script.


Table Script : PackingLIST_SQL.txt
0
I want to print QR Barcode using VB 6 and crystal report 8.5 report designer, What is best QR Barcode is available for download? How to print QR barcode in 1 inch x 1 inch format?
what is special requirement for above provision.

Thanks
0
I am trying to exclude certain records from the report using the select record expert in CR, but when ever I set up the query like this (see bold part of query),

{investor.holdings} and
(not ({receiver.r_ussname} startswith "NON-USS:") and not ({investor.iaccountid} in ["35048"])) and
{trade.mdate_i} > {?Start Date} and
{trade.settle_i} <= {?Start Date} and
(not ({trade.icobbill} in ["B", "P"]) or {trade.iaccountid} = ["10107","12462","15227","10119","19331","10301","32051","32013","32109"])

CR keeps changing the query structure to this:


{investor.holdings} and
not ({receiver.r_ussname} startswith "NON-USS:") and
not ({investor.iaccountid} in ["35048"])
and
{trade.mdate_i} > {?Start Date} and
{trade.settle_i} <= {?Start Date} and
(not ({trade.icobbill} in ["B", "P"]) or {trade.iaccountid} = ["10107","12462","15227","10119","19331","10301","32051","32013","32109"])

and what happens is that it processes the augments separately instead of inclusively.

I am trying to use (not ({receiver.r_ussname} startswith "NON-USS:") and not ({investor.iaccountid} in ["35048"])) as a way to tell CR not to return records where both the receiver.r_ussname begins with "NON-USS" and the accountid begins with "35048". In otherwords, dont return any records where it is both "NON-USS" and "35048".

Not sure why this is happening, but there are two different tables that I am trying to query against in that statement, maybe that is the issue? If …
0
Hello Experts,

I need to generate a separate page that prints out before each page in a report. I'm using Crystal Reports version 2013, and I was going to insert a new page header section, move it up so that it is the first page header section, and then on the paging tab in the Section Expert check New Page After, but I see that the options to select New Page Before or New Page After are grayed out on the Paging tab in the Section Expert for the Page Header section of the report. Is there any way to accomplish this?
0
Free Tool: ZipGrep
LVL 12
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

I have a 5.5 inch x 8.5 inch Crystal Report document that links to a database. There are 15,000 records. The records are sorted sequentially by Label ID and the report is saved as a PDF file. The PDF file now has 15,000 pages, and the Label ID that prints at the top right corner is sequential.

In the print dialog box of Adobe Acrobat, I can print these labels 2-up on an 8.5 x 11 sheet. The printer driver handles this automatically.

So 7,500 sheets of paper come off the printer, the sheets are cut in half so now I have 2 stacks, but they are out of order.
Why? Stack 1 contains labels 1, 3, 5, 7, 9... etc
Stack 2 contains labels 2,4,6,8,10 ... etc

I want the labels to print so that when the 8.5 x 11 sheet is cut in half, the first stack has all of the labels from 1 to 7.500 and the second stack has labels 7,501 to 15,000.

In order to do this, I assume I'd have to redesign my Crystal Reports layout so that instead of one label, I have 2 labels on a sheet (8.5 x 11).
But Crystal Reports would have to put record 1 at the top, and then record 7,501 on the bottom. Then on page 2, record 2 would be at the top and 7,502 on the bottom. And so on.

Is there a way to accomplish this in Crystal Reports? I am using version 2013.
0
It does not appear like my code is fully evaluating the criteria. There are blanks where "N" should appear

The way it should evaluate is it should look for the CPT_CODe first, if a match is found then look to see if any of the DX codes exist in any position (DX1-DX6) then it will look to see if COPAY Due is > 0.00 and COPAY Collected is > 0.00. If all is true then "Y".    If anything past the CPT_CODE is not true then "N"

Preventive Y/N column - The blanks appear to be False after the CPT_CODe because no other criteria is found but do not indicate "N" they appear as Blanks and not sure why. See attachment for data.

Using formula Editor - Crystal  

if {Command.CPT_CODE} = ["44388", "44389", "44392", "44393", "44394", "44401", "45300", "45305", "45308", "45309", "45315", "45320", "45330", "45331", "45333", "45338", "45346", "45378", "45380", "45383", "45384", "45385", "45388", "74261", "74262", "74263", "G0104", "G0105", "G0106", "G0120", "G0121", "G6019", "G6024"]
and
(
{Command.DX1} = ["Z01.89","V10.00","V10.05","V10.06","V12.72","V12.79","V16.0","V18.51","V70.0","V72.31","V76.41","V76.50","V76.51","V76.52","792.1","Z00.00","Z00.01","Z01.411","Z01.419","Z12.10","Z12.11","Z12.12","Z12.13","Z80.0","Z83.71","Z85.00","Z85.038","Z85.048","Z86.010","Z87.19","R19.5"]
or {Command.DX2} = …
0
data exampledata examplePlease see attached,

My question is, What's the best way to get the sum of ALL hours by the pay sum group and by employee for all the per end date combined?
so for 10187 should have the total of 82.75 for Pay sum group 100 and for 300 should have 75.25
and so on.
0
Hi all.

I'm trying to create a Crystal Report (2011) that displays the AccountNumber, ProductLine and Sales from myTable based on the following criteria:

(1) SalesDate >= {parameter.StartDate} and SalesDate <= {parameter.EndDate}
(2) The AccountNumber can not have already had a sales for the ProductLine one year before the parameter.StartDate

So if the parameters are: StartDate = 02/01/2018 and EndDate = 02/28/2018
Then the ProductLine must have a SalesDate falls between 02/01/2018 and 02/28/2018 AND can not have a SalesDate fall between 02/01/2017 and 01/31/2018. The table (myTable) contains all sales records for each AccountNumber.

Any idea how I can do this Crystal Reports? This report used to be an Access report that used a couple of queries to get the final records but I'm clueless as to how to do it in Crystal Reports, specifically criteria 2.

Thank you in advance!
0
Hi there,

I ran a Crystal Report (V 11) through a system that has a viewer so that the user does not have to have crystal on their system to view the report.

I've never had the attached appear and before I approach the product vendors who will take ages to respond, has anyone seen this in their history of working with Crystal? It works fine when I run it within the program - but when I attach it this pops up -

thanks - CS
0
I need to store 2 values in a subreport to pull into my main report.  The first value is the cost from the prior day the second is the value from the current day or most recent day.

For example:

The subreport stores Product Cost by Date, Time and Product.  I have stored the last record to updated to the file.  What I need to do is grab the prior day or prior date price.

NL - 4/2/18 - 1.828
NL - 3/29/18 - 1.892

I need 1.892 for Prior stored and 1.828 for Current Cost stored.

In the Main Report I will pull Prior day and Current day based on time.
0
Working with an Oracle database and Crystal Reports.

I have to get a series of values from a common field and put them in column "buckets" so to speak.
As seen in the Excel spreadsheet.
If the field {TableName.Labor_Code} = "FMG" then {TableName.Total_Cost}  else 0
If the field {TableName.Labor_Code} = "HNG" then {TableName.Total_Cost}  else 0
If the field {TableName.Labor_Code} = "SUP" then {TableName.Total_Cost}  else 0
For all Type Codes = FMG, HNG, SUP, FIN, CLN.....you get the point!

My question is would it be more efficient to build these columns in an individual formula like above
or use a Running Total from Crystal Reports to generate the columns so that they are totaled at the right interval.
Example---Sheet1.pdf
0
How to I align different types of numbers, decimals and currencies in the same column in crystal reports?
0
Hi all.

I have a Crystal Report (v. 2011) that displays: customernumber, invoicenumber, invoicedate, itemnumber, productline, sales

At the report footer I have running total for the sales column that I display in the report footer. But now we want to break that total down by productline. So if the report has 3 product lines then show 3 totals and the grand total (which is already there).

Note, I don't know how many productlines will appear on the report, sometimes the report will display 3 productlines, sometimes it may display 5 or 1. It all depends on the parameters (invoice start date and invoice end date).

How can I do this in Crystal Reports? Should I do a subreport just with the product line sales?

Thank you in advance!
0
Free Tool: SSL Checker
LVL 12
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.

Hi There
I want to create a report that buckets dates in fortnightly amounts. across the page so will be separate formulas
What formula can I use to create the first 14 days?
I would then use another formula to add 14 days to top of each one This is not a group heading
currently use this formula for start of current week (dateadd("d",7-dayofweek(currentdate)+2,currentdate))-7
Can I use a similar one for fortnight?

Cheers

Steve
0
I need to develop a report that uses a Users table to compare against the Created_by and Modified_by fields in another table to report a list of the records that were Created_by or Modified_by each user in the Users table.  

In other words, the Users table has a userid that an application inserts into the Created_by field or the Modified_by field for every transaction inserted into the Transaction table.

I am not sure how to cycle thru every user to either show the transactions that the user created or modified or state "No transactions entered for this user."

Any guidance on how to set this up would be greatly appreciated.
0
Hi ,

I have a windows application .net 2005 with crystal reports. I have upgraded this app to vs 2012. In may machine, everything is fine but on production, it always show database login window without database name and password although i passed them.

i have already installed Crystal report run-time with SQL server client on production machine

From scratch i build a new app in vs 2012 with new reports, it's running fine in both development and production machines.

i guess the problem is with upgrading reports developed with crystal reports old version ( which comes with .net 2005) to run with new version.

Thanks.
0
How do i get the percentage from the "total votes"

SELECT
    D.CONTESTID, C.CONTESTNAME, D.CANDNAME,
    NVL(D.VOTES_EV, 0) + NVL(D.VOTES_AB,0) + NVL(D.VOTES_ED,0) + NVL(D.VOTES_EPROV,0) + NVL(D.VOTES_PPROV,0) "TOTAL VOTES",
    NVL(D.VOTES_EV,0), NVL(D.VOTES_AB,0), NVL(D.VOTES_ED,0), NVL(D.VOTES_EPROV,0), NVL(D.VOTES_PPROV,0)
FROM
    ERUSER.RES_CAND D JOIN ERUSER.RES_CONTEST C ON D.CONTESTID = C.CONTESTID
0
I am working with Crystal Reports 9 and have created a report with multiple headers and details. Each header, aside from the one used as the title of the report, is linked with a specific detail below. However, all the headers are grouped together and all the details are grouped together. My question is, Is there a way to design the report so that the linked detail is directly below the header, or can they only exist in these groups? I have been tackling this problem for a while, but haven't come across any solution.
0
I am using Compulink Advantage version 12.  I have previously successfully created and added custom crystal report to the menu.  Two reports are giving me problems.  They will not launch.  They are visible on the menu.  However, when I launch the reports I receive message, "Unable to Locate Report: [report title]".  Has anyone experienced this problem?
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
>