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

I am trying to avoid using a subreport to display the user's selections from a dynamic parameter.  I set the parameter to Show Value or Description = Description.  Then I created formula, Join ({?Provider Type},',') and put it in the Report Header.  It displays the Values selected, not their descriptions.  Then I pulled {?Provider Type} into the Report Header.  It displays the Description associated with the first parameter selection.  Everything I have read says that the Join should work.  Any suggestions on why this doesn't work?  Has anyone else had this problem?  I was so looking forward to this change in Crystal, but it appears that it doesn't work or there is some trick that I am missing.  Thanks.
0
Hello,

Looking for crystal formula let me find specific text in string field and replace with other text.
I'm looking for CS, should be replace by PL

thanks

henry
0
Client wants me to Develop several Crystal Reports for his company that he will be able to run, refresh and export as pdf file  when he needs.
He has running company network where he has SQL Server database  on  network server.
 I am wondering how is the best to do this remotely.
As I am developer and working from remote site (home) what is the best option to do that.
He has installed Cristal Report 2011 on one of his PC on his network(not server version just one user license), I have on my laptop CR 2008.
I assume that connection should go over VPN.
As it is first time for me to do development  from  remote site. My question is should I have VPN access to his PC which has installed Crystal Report on it and create,run and save report  to server folder.
Or I could connect from my laptop to his database on server create report on my laptop and save it to his shared folder on his company network. In that case not sure how data source location will be when he try to run it, will it be different for him and for me when I was creating report from my laptop. In that case should he reconnect data source first then run report??

Can you give me best suggestion how to do this as this is new for me completely?
0
Guys,

I have a report built in Crystal Reports 11. In one of the sub reports, I have 1 report header section (with Headings), 1 details section (with records) and 1 Report footer section with some text.
When displaying the records in the Details section I use suppression (in the details section) to hide records I don't want to display, which actually could result in some cases where there are no records to display. If this happens and there are no records being displayed, I want to suppress both the report header section (the headings) and the report footer section (with text).
ie. If my suppression results in no records being displayed then I basically want nothing to be display in the entire sub-report.
There are no groups or running totals to complicate matters.

Anyone any ideas on how to do this.

Cheers,
Andy
0
To the experts,

We have an example with two datasources. Both hold revenues and week numbers of two independent businesses, they are based on different tools and the data need to be combined in one crossing table. The main report uses odbc to connect to the 1st source and the subreport in the report header uses odbc to connect to the 2nd source.

We grouped the subreport based on concatenation and created a grouping array and a summary array,

Issue: the crossing table in the main report doesn't show the rowfield and columnfield that were used in the subreport's grouper formula.

What do we have to do?

The table we look for:
-rows: business-1 and business-2
-columns: week numbers (we used a formula based on revenue dates and another formula to convert the numbers to text)
-(sub)totals

Regards, Johnathan
0
Hello,
      I have a formula in a report that gives a “Divide by Zero” error. This is the formula:
if
{@margin} = 0
then
0 else
({@margin}
/
{tcspnm.plistpr})
*
100

One of the fields in the @margin formula is sometimes populated with 0.00. Is this the issue? If so, how can I fix it?

Thank you
0
Hello,
      I have a report that is grouped by Customer, then Engine Program, then Part Number. I would like to suppress everything for the Engine Program and Part Number sections if the Engine Program field is null. In other words I only want to see results if there is a value in the Engine Program field. Can this be done.
I have attached a copy of the report in case it helps.

Thank you
example.rpt
0
Crystal Reports 2013

Is it my installation that is wrong or did SAP get rid of the "Today" option on the js pop calendar for picking parameter dates?
0
i'm checking 2 columns in formula and want to know when there isn't a matching employee id.
i.e.  staff.emp_id = whmis.emp_id
If there isn't match then I want to indicate in formula 'unmatched record'
what is best method ?
0
I have Business Objects 4.1 and one of the reports takes a long time to run and is timing out after 10 minutes. I found a max retrieval time option but changing that had no impact

What options control the timeout high water mark?
0
Any one know of a Crystal Reports formula that would convert decimal time into hours:minutes:seconds?  

I know if I have 13.27 hours that I can do .27 x 60 = 16.2 minutes and take .2 x 60 = 12 seconds which would be 13:16:12  but not sure exactly how to make a formula in crystal reports.
0
I have a report that contains a subreport, and the subreport items appear fine when the whole subreport is on the same page.  If the subreport spans over to the next page it truncates one line (the next item that should appear in sequence on the next page).  I have tried reimporting the subreport, removing the page footer, etc.  I created a new report, and it still truncates the next item that should appear on the following page.
0
I am using the CurrentDate to find out when a report is run.  

Since the reports are being run on a Japan Server, it is 16 hours time difference.  What function can I use, all I want to see on the report is as follows:

Example:

         11:23 am  

This time is West Coast/Los Angeles Time.  

16 hours time difference between japan and Los Angeles, I don't think we can do a date subtraction unless it can account for daylight savings.
0
Gurus,

I have a client that wants to create a "date based report" based on a record that includes a date and duration.

For instance, Record 1 - would include a date 7/11/2015 and a duration of "3 days".  

They want to see a report like this:

Group: 7/10/2015
(Detail) *No records*

Group: 7/11/2015
(Detail) Record 1

Group: 7/12/2015
(Detail) Record 1

Group: 7/13/2015
(Detail) Record 1

Group: 7/14/2015
(Detail) *No Records*


Each time "Record 1" is listed it would include other fields from Record 1, I'm just keeping it simple for display purposes.  Also, there could be other records that would be listed within each "date".

Any way this can be done?

Thanks in advance!
0
Hi,

   I am not able to see one user's tables and views when using crystal report.      

   When browsing Data Explorer->My connections->DatabasePROD can see the schema tables and views of an specific user (USER_A) , but when Data Explorer->My connections->DatabaseDEV i am not able to see that user (USER_A) neither the tables and views.   The same thing happens with others users like SYSMAN, SYSTEM,etc.

  This happens with version 2008 , but with version 2013 i can see the users but not its views.
0
Good Morning!

I have a database which collects time in Zulu time and I have been using the DateAdd function and subtracting 7 or 8 hours depending on the time of year for daylight savings time.  When working within a single year I have been using the following to adjust for DST:

Local DateTimeVar DST_start;
Local DateTimeVar DST_end;

DST_start := DateTime (Year ({E05.E05_03}), 03, 14);

while DayOfWeek (DST_start) <> 1
do
  DST_start := DateAdd ("d", -1, DST_start);

DST_end := DateTime (Year ({E05.E05_03}), 11, 7);

while DayOfWeek (DST_end) <> 1
do
  DST_end := DateAdd ("d", -1, DST_end);

if {E05.E05_03} in DST_start to DST_end then
  Date(DateAdd ("h", -7, {E05.E05_03}))
else
  Date(DateAdd("h", -8, {E05.E05_03}))

What I need now is a formula that will allow me to cover all years since the days DST changes each year.  However, I have found it changes on the second Sunday in March (spring forward) and then reverts back on the first Sunday in November.  Is there anything out there like this?  I have searched EE and just found old posts on the topic.

Thanks in advance,

Task
0
Hello ,
Please help me to use crystal report 11 in vb6.0
i am already install crystal report 11  but
i can't found crystal report 11 active X in component
0
Please Help
   I am using Microsoft Visual Studios 2012 and trying to add Crystal Reports to the project. My problem is that I am not getting the report wizard to assist me with the report. Can someone tell me how to summon the Report Wizard Please
0
Hi.  I have created a calculated field in crystal reports and need to add -2 workdays to it.  Not really sure how to do this in crystal.

calc field is "*EMD2:" +  totext({VMI_WC_PRIO_POS.EARLIEST_DATE}, "MM/dd/yy")  

I tried "*EMD2:" +  totext({VMI_WC_PRIO_POS.EARLIEST_DATE}-2, "MM/dd/yy") but I get weekend dates in some cases. Is there a way to do this?

thanks
0
I created a report using Crystal Reports 2008 that prompts for parameters.  When I publish the report to BusinessObjects Enterprise XI 3.1  the prompts are not shown.  The report runs with the default values.  How do I make it stop that behavior?
0
I have a report from Crystal Reports that is a statement run, i.e. prints hundreds of statements.

However, many statements have a zero opening balance and zero transactions, so I would like to filter them using the Select option.

I have tried to Select Group, and I can filter on the opening balance, but I cannot filter on the formula field that checks if have any transactions.  

I understand the reason, because the formula is calculated  after the select process.  

Other than rewriting the stored procedure that initially collects the data to filter the dataset, is there anyway to achieve this in Crystal Reports?
0
I have a report that I created that is taking over 2 hrs to run.   I am attaching as much information about the report as I can without giving out Patient Information.  

If you need anything else, please let me know.

KR
H--CR-report-Question.docx
0
Hello Experts,

I need to calculate a datediff, but instead of having two distinct fields, I am using a single field.  The goal is to find out how many days passed between arrest dates for a single person.  I have a report that is grouped by persons showing arrest dates.  I want to show the number of days between arrests, per person.  I attempted to make a formula to return the next arrest date value per person to use in a datediff, but it is not working PER PERSON.  It is calculating the difference between dates using the date for the next person...

Can you help me to get the datediff to work using a single field, per person?
~Chop

@NextArrestDate
if {@Client for Group} = {@Client for Group}
and length(totext({Vw_CasesPeopleOffenses_Arrestees.ArrestedOn}) )  >  1
then next({Vw_CasesPeopleOffenses_Arrestees.ArrestedOn})
else CDateTime (0000, 00, 00, 00, 00, 00)


@DateDiff
DateDiff ("d", {Vw_CasesPeopleOffenses_Arrestees.ArrestedOn} ,{@Next Arrest Date} )
0
I think that I am toast, but here is my problem:

I am a payroll company.  Any given employee might work for two or more clients each week.  All of those clients are paid to the employee on the same payroll check.  So, Bob works for client 1234, 4567, and 8912 in the same week.  All of those hours for all of those clients are paid on the same payroll check.

My payroll check print file groups by client company.  Therefore, Bob's check - the exact same check - will appear in all three groups (once for each client).  You can imagine the problems.

Now, I cannot change my groupings - I have to group by client for a variety of reasons.  What I want to do is the following in my selection:

Add a filter that says:  If a distinct check has multiple client numbers, suppress (or simply do not select) everything except the lowest value client.  In other words, in the example above, ONLY select the check (or ONLY group with) for client 1234 (all clients are numerical).

Can this be done?  I have tried everything and I have asked ever CR writer that I know.  You are my only chance at this.

Thanks
Daniel
0
Have the attached report that is in the desired sort order needed for our production scheduler.  The issue I am currently having is that some values are showing multiple times due to the sort order.  Wanted to see if anyone knows of another way to keep the desired sort order but not show repeat values.  I am not sure if there is a way to supress other values if the "Formual" was already processed using some sort of vairable function.  Additionally, if that is possible i also need a way to then not call the sub report as the sub report which are the values represented in white background on the report.
reorder-report-ver3-test.rpt
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
>