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
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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
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
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
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
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
The 14th Annual Expert Award Winners
LVL 7
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

How to I align different types of numbers, decimals and currencies in the same column in crystal reports?
0
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
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
Hi There
I have written a report that uses gantts and have an issue with the standard date format it is using
The format printed is MM/DD I want it to be DD/MM
the date fields in the detail section are DD/MM but it is displaying MM/DD in the chart. Can find any options to change it
How can I change this?

Cheers
Steve
0
I am using VB.Net with crystal report with SQL Server 2008R2. I have a stored procedure and call it to use in my crystal report, and on my crystal report i have a formula field that sum from many field, so i want to use the final value of my calculated formula field to supply the parameter of Store procedure.

Thanks in advance.
0
What would be the best way to display a value while suppressing it in another section where it would normally show in Crystal Reports.

This image shows a column called contract amount. Currently showing a field called Approved Amount. $44,755. The value at the top....which is not correct. The value should be $505,000 which is displayed far below in the bottom of the column next to the Code on the right with "QU-00547". The record is in the details of another field.
Since I need to post the record $505,000 currently at the bottom of the details column (where the code next to it....starts with "QU") at the top. Where the $44,755 is currently.
total displays in details section when I need it as a total at the top of the column.
Since I have to suppress records that start with "QU" in the details section but display them at the top of the report next to the Contract Amount.....which is what is approved. Is the best solution a shared variable or something else and is there a more efficient formula over another. Since this is going to be repeated over many many contracts.? Examples welcomed.
0
How to add serial numbers in a crosstab in crystal report

I have made a crosstab in crystal report for employees daily project locations having multiple branches. I have grouped each employee based on their branches and I need to add serial numbers into this report and serial numbers for each branch (group). I need the report output like shown below, One serial number continuous fro the report and another column serial number for each branch. I am also attaching the report for your reference.
SampleEmployee-Projects-per-day.rpt
0
I want to add 1st value of group header 1 and 1st value of group header 2 and display as first value in group header 3 .. can you help me how to do this ?
0
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

I have CR2011. I want to create a Line Chart that shows me quantity of help desk tickets for the different priroities: Low, Medium High. I want a line representing each priority. How can I make it do that?
0
Hi Experts,

I have a table 'tblmyTest' which has three columns as below :
SELECT RemarkID, RemarkDesc, GroupID FROM tblmyTest;

Open in new window



And another view 'vwRemarks' which contains the following values :
SELECT ID, GroupID, RemarkPoints FROM vwRemarks group by GroupID;

Open in new window



Desired Output :
When I write query like this,
select RemarkID, RemarkDesc, GroupID
from tblmyTest 
where RemarkID in (27,38,40,42,43,44,45,46,57,61) and
	  GroupID='pnlAng'
group by RemarkDesc;

Open in new window

I get the desired output as follows :


I want to use this in crystal subreport and for that I rewrite the query :
select RemarkID, RemarkDesc, GroupID
from tblmyTest 
where RemarkID in (select group_concat(distinct RemarkPoints) from vwRemarks group by RemarkPoints) and
	  GroupID='pnlAng'
group by RemarkDesc;

Open in new window


P.S. RemarkID represents integer datatype whereas RemarkPoints is of String data type.

It returns only single row as below:


Please help me to get the "Desired Output".

Regards,
D Patel
0
We are trying to format a string field in crystal reports to 2 decimal place.  We are not able to do from SQL as the code is copy written therefore we are having problems.  The fields is a number example 802.35000000, we would like to truncate the ending zeros.  We have tried to use TOTEXT but it only comes back with to many arguments for function.   We tried the below a   Nothing is working

If IsNull({Rpt_JournalTransactionSp;1.TcDebit}) Or
   InStr({Rpt_JournalTransactionSp;1.TcDebit}, " ") = 0 Then
   "0"
else
 TOtext({Rpt_JournalTransactionSp;1.TcDebit},2)
0
VB 6 and 8.5 crystal
I am using  . recordselectionformula and have this in the code
Dim rs1 = {atable.afiled}=" & num & ""
Report.RecordSelectionFormula = rs1
 .ExportOptions.FormatType = crEFTPortableDocFormat
 .ExportOptions.DestinationType = crEDTDiskFile
 .ExportOptions.DiskFileName = FileN
'Report.View
.ExportOptions.PDFExportAllPages = True
.DisplayProgressDialog = False
 .Export (false)
end with


in the crstal report I have this in record selection
{sametable.samefield}={@num}

I also have a SQL query that calls all the fields I need for the report
when I hard code each the SQL query and the recordselction formula in the editor my report pulls the correct data- when I use the code above to try and send the @num the report pulls up with no data.
how do I test or do I need to set the record selection formula and oir SQL QUERY?
THANK YOU
kURT
0
Time field in crystal report contains, an integer value along with time. I used function, Time to get only time from that field but its giving error bad time format error
0
Crystal Reports - adding a trendline to a multi-series line chart

I have a multi-series line chart (example attached) that I want to add trendlines to.  I have set the setting to add the trendlines but my graph doesn't change

Am I doing something wrong?
Example.pdf
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
>