Learn how to a build a cloud-first strategyRegister Now

x

Crystal Reports

34K

Solutions

14K

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'm a Crystal Reports newbie, I want to write a simple java application that is print my data (using hibernate and jsf).
This is my method in my managebean:

public void print(List<Child> list) {
            
            try {
                  
                  // Instantiate the report object
                  String report_Location;
                  report_Location = "/com/reports/Report1.rpt";
                  
                  // This interface provides a common service point for getting a report source that is used to view and export reports.
                  IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
                  
                  // It is recommended to use the ReportClientDocument to obtain an IReportSource object.
                  // it's also Creates a new reportsource for the report specified.
                  Object reportSource = null;
                  reportSource = rptSrcFactory.createReportSource(report_Location, java.util.Locale.getDefault());
                  
                  // creating a Fields object, populating it with the parameter values then adding that to the viewer.
              CrystalReportViewer viewer = new CrystalReportViewer();
              
              /*
               * Before parameter fields can be set in a report, the fields must first be created and initialized.
               * Individual parameter fields are all stored in a Fields object.
               * The Fields object is simply a collection of different fields that can be passed to the viewer.
               */
              
              // Create a Fields object to store the parameter fields in.
              // Returns an object that contains the parameters in the report.…
0
Free Tool: ZipGrep
LVL 11
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 currently have the resultset as below:

Program                        Rundate              Userid
---------------------------------------------------------------------
P:\Application2.rpt      2017-11-10         john                    
P:\Application2.rpt      2017-11-11         sam                        
P:\Application2.rpt      2017-11-13         sam

P:\Application4.rpt      2017-11-12         john  
P:\Application4.rpt      2017-11-14         sam                  
P:\Application4.rpt      2017-11-15         luna

P:\Application1.rpt      2017-11-14         john                    
P:\Application1.rpt      2017-11-15         luna                  
P:\Application1.rpt      2017-11-16         sam








I need to get the resultset as shown below:



Program                       LastDateRun1   LastRunUser1  LastDateRun2    LastRunUser2  LastDateRun3   LastRunUser3
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

P:\Application2.rpt      2017-11-10         john                    2017-11-11       sam                   2017-11-13         sam
P:\Application4.rpt      2017-11-12         john                    2017-11-14       sam                   2017-11-15         luna
P:\Application1.rpt      2017-11-14         john                    2017-11-15       luna                   2017-11-16         sam
0
I am migrating from an older version to CRS 2013 where I am unable to locate the BVM.  I've gone back in the install package seeing if I missed the install section and didn't see it even in it.  In web searches it shows I should be able to locate it in:  SAP BusinessObjects BI Platform Client Tools, however unable to locate this also.
0
I have written a formula to split peak from off peak time, peak is only Monday to Friday, the result is only returning data for off peak, please see formula below;

  If ( (time({STAT_RM_TRANSACTIONS.TRIPDATETIME})>=timevalue(03,00,00) AND time({STAT_RM_TRANSACTIONS.TRIPDATETIME})<=timevalue(09,29,59))
          AND  (
          (time({STAT_RM_TRANSACTIONS.TRIPDATETIME})>=timevalue(15,30,00) AND time({STAT_RM_TRANSACTIONS.TRIPDATETIME})<=timevalue(17,59,59))
               )  AND      
          datepart("w",{STAT_RM_TRANSACTIONS.TRIPDATETIME}) IN [2,3,4,5,6] //weekdays
 
         ) THEN "Peak"

ELSE "Off Peak"
0
Dear SIr,

I have develop below scenario of crystal reports to drill down the data  by using a hyperlink in first crystal report shown in a preview mode that it opened in a  new tab when calling from the parent web form
then in this first crystal report I add a hyperlink to open a second crystal report that I need to open it also in a new tab
and so on...
Can anybody has any idea?
0
Hi There.
I am creating routing cards for jobs out of JDE and want to put a sequence number on each set of cards.
I am using a repeater table to duplicate the number of cards based on a formula that is how many units per bin. (job = 3000 units, 300 per bin so 10 cards will be printed per operation step.
there are many steps per job. example operation 10, 20, 30 ,40. I am getting 10 of each card in that sequence 10 times.
I want to put a number that represents the group of cards / bin number. eg. first 4 cards will all be 1, second 4 cards will be 2 etc... up to 10. each 4 cards has a 10,20,30,40 in that order.
When the job number changes on the card then the sequence number starts back at 1 again.
Tried running totals but couldn't get it to work
Any ideas?
Cheers

Steve
0
I am having a multiple cross tabs (on page 4 of 4)  in my report displayed below attach image
Issue1.jpgI want to merge the rows for same name list.
As you can see, "Running Time" is repeating twice. I have taken sorting ID to bring the Values in the required format instead of viewing in Alphabetical order.

Below is the location.
https://drive.google.com/open?id=1sH07hjkIqn5JG8G8EsyX6wEe53MzbpDh
0
I had this question after viewing Random Record Selection.

I thought this was working ok
I have 2 sites that need to use this report
One seems to work ok the other only returns 6 records instead of 20
Any ideas
Have included the rpt file
Gordon
Customer-Survey-Data.rpt
0
I have one main report and 4 sub reports. 3rd sub report and 4th subreports are not showing data in main report. But first two sub reports are showing the data. I have linked all reports correctly.I am unable to find the issue, please help me. Based on main report parameters it should display.
0
I have this Formula for Yearly Totals

Shared NumberVar yearlyWages;
Shared NumberVar GrandWages;
GrandWages := GrandWages + yearlyWages;
yearlyWages;
It is placed in Group2 footer(there is nothing in Group1 footer)
In the report footer I have this formula for Grand Total
Global NumberVar GrandWages;
GrandWages

Yearly wages works fine.. it is being reset to 0 in Group header 2.
The GrandWages in the report footer is 0.  It does not have the accumulated value.
What am I doing wrong?
0
Vote for the Most Valuable Expert
LVL 7
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

I'm running a Crystal Report to the screen. On the viewer is a Print icon.

Print icon
But when I click it all I see is the Microsoft XPS Document Writer, it doesn't give me access to any of the other printers available.

print dialog
I'm running Windows Server 2008 R2, but is an issue reported by a customer, I just happen to be able to replicate it on a VM I have built.

I can see that it is defaulting to the system printer:

printers on server
 so if I change the System Printer to "One Note" for example:

change system printer
Then it prompts with that, but ideally I would like it to just allow them to select any printer.

change print dialog
0
Hi,
I want to create a 1 crystal report which shows the Member detail form member section i have to display member records and in spouse section i want to display spouse details and also same for member dependents.i have all details in one table but there are different record for member,spouse and dependents. (e.g for member code OM0582 in database OM0582  01 for spouse OM0582  02 , if member have 3 dependants then OM0582  03,OM0582  04,OM0582  04). i am attaching screen shot of table records of 1 member. i want to display this records in one member form, how can i do this?
error.jpg
0
Hello.

I have Peachtree 2017.2 and there are two reports that have two different sets of data that I need.  The "Invoice Generated Report" and the "Cash Receipt Journal" report.

How can I create a custom report that will show me the information from both in one report.  I need at least the customer number/id and/or customer name, the invoice number, receipt number (from the CRJ report) and the amounts.

Thanks. :)
0
I have vb.net project in VS 2010 and for crystal report i am using framwork 4 but in my pc framwork 4 client profile also be there.
. i have 1 crystal report and 1 form but when i want to create a setup project error message shows. setup file is created even after the error when i run the setup on client pc setup done successfully but when i want to run a application it showes error "exe not working" and progam get exited. Please refer the attached screen shot.
So, please help me i am stucked?
error.jpg
0
I have a requirement where I have to display all the text from RightToLeft (mirrored text).

How to achieve this with crystal report?

Please help me to get the solution for this.
0
Hi there,

I have what I thought was simple suppression criteria for my group but it's not returning the results I need, ;

if {?Days Over Due} = "All Pledges" then FALSE

//less than thirty days overdue but not negative or 0    *this returns negatives as well as values over 29
else if {?Days Over Due} = "Less than 30"
then ({@Days Overdue} <=0
and {@Days Overdue} >29)

//inclusive of 30 and 90 excluding less than 30 and greater than 90 *this returns similar results
else if {?Days Over Due} = "Between 30 and 90"
then ({@Days Overdue} <30
and {@Days Overdue} >90)

//inclusive of all over 90
else if {?Days Over Due} = "Greater than 90"
then {@Days Overdue} <=90

Any help would be appreciated!

Thank you - CS
0
I have two stored procedures in one report. My main stored procedure is procSSFTP_RPT_WorkAndRestDailyReport and 2nd stored procedure name is procSSFTP_RPT_GetCrewComments.

I want to display "Seafarer name" from my 1st stored procedure and "comments" from 2nd stored procedure.

I have multiple rows for the comments against the single seafarer name.

Instead of showing multiple rows of comments for single "seafarer name", I want to display one comment per "seafarer name".

Attached is the report for your reference

https://drive.google.com/open?id=1nb_DOgTVjFD1d-YdRR8jUX2omN5yO8KV
0
Sir,

Would you please help us if we can read default values in a crystal report from VB.net programmatically
or how to add default value in the crystal report in order to read them from the web form

Thank you,
0
Hi Guys,
We are using SAP Version 9.2 PL7
we have setup transactional replication in MSsql 2016 server & works well.
but when we upload all existing crystal reports (After Modified), SAP Rollback the Crystal Report Upload. but it is possible to upload new reports. please see attached error image.
any ideas are greatly welcomed.

thanks.
Untitled.png
0
Free Tool: Subnet Calculator
LVL 11
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.

I have a report that shows sales by department. Within each department, it lists by group the top 5 stores.  I need to pass the store numbers to a subreport after they have all printed to do some other calculations using another table that won't link to this one.  How do I capture those top 5 store numbers? Or is it even possible to send them as a list to the subreport?
0
I am trying to create a report.  I want it to look like the attached:
What I have at the moment is attached:
The cross tab is built as attached:

The formula is:

//Current
if {F_TASKS.TA_STATUS} = 'Assigned'
and {F_TASKS.TA_EST_DATE} > CurrentDateTime
then "Current Open Tasks"
else
if {F_TASKS.TA_STATUS} = 'Assigned'
and {F_TASKS.TA_EST_DATE} < CurrentDateTime
then "Current Overdue Tasks"
else

//This Week
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS}= 'History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-7 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} < {F_TASKS.TA_EST_DATE}  
then "Tasks Completed On Time Last 7 Days"
else
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS} ='History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-7 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} > {F_TASKS.TA_EST_DATE}
then "Tasks Gone Overdue Last 7 Days"
else

//This Month
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS} ='History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-30 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} < {F_TASKS.TA_EST_DATE}
then "Task Completed On Time 7 - 30 Days"
else
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS} ='History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-30 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} > {F_TASKS.TA_EST_DATE}
then "Tasks Gone Overdue 7 - 30 Days"
else

// 6 weeks
if …
0
hi im new on crystal so please bear with me
for example this is my data

EMPID     COMPANY     DEPT
12345          100              22
23456           100             23
34567           200             33
45667           200              34
11111           200              35
11112           200               36
11113           200               37
11114            300              11
11115            300               12
11116            300               13
11117            300                14
11118            300                15

lets say I need to capture empID in company 100 and on 200 I only need dept 35,36 and on 300 I need depts 11,12,13
how will I be able to get that? lets say there are more data in it with lots of departments but I only need specific ones from specific companies
0
All,
 I have VS 2015 Enterprise with CR installed.
Using VB.NET I've developed my CR program.
Now I want to create a setup program that will run the CR .msi first & then continue with installing my program.
Is there any way to add it to prerequisites, or just run the two sequentially?

Russ
0
I would like to create a report (or ultimately a dashboard) that looks at a particular value (a status for a particular record (e.g. "new", "in process", "completed")).  There is no data of the status at any particular time so all I can query is how many records are in each status at any given snapshot in time, but I would like to know where we stand and how these are changing over time.  Is there a way to automatically run the report (e.g. daily) and have all of the prior results be part of the most current report?

I hope I explained this well.

Thank you,
Bruce
0
I have formula filed f1 do (field1-feld2) during tow dates
then how to use something like this in my c# code
DB db = new DB();
            DateTime StartDate;
            DateTime EndDate;
            StartDate = Convert.ToDateTime(dtpfrom.Value.ToString("yyyy-MM-dd"));
            EndDate = Convert.ToDateTime(dtpto.Value.ToString("yyyy-MM-dd"));
            FrmViewer fv = new FrmViewer();
            crtunderMedicineRoof rpt = new crtunderMedicineRoof();
            string sql = "";
            sql = "  {View1.MedicineDate}in #" + StartDate + "# to #" + EndDate + "#";
            param = "سقف العلاج للفترة من  " + " " + dtpfrom.Value.ToString("yyyy-MM-dd") + " الي" + " " + dtpto.Value.ToString("yyyy-MM-dd");
                        //
            if (ckb_overRoof.Checked == true)
                sql += "and  View1.f1<0)";//using formula field here
            rpt.SetParameterValue(0, param);
            //rpt.SetParameterValue(1, p);
            rpt.RecordSelectionFormula = sql;
            rpt.SetDatabaseLogon("cost", "cost");
            fv.crystalReportViewer1.ReportSource = rpt;
            fv.Show();
0

Crystal Reports

34K

Solutions

14K

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
>