[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

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 have a report that is using  calculated member in a cross tab.  The "insertion formula" is making it show up after a specific column
"GetRowGroupIndexOf(CurrentRowIndex) = 1 and GridRowColumnValue("glaccnttype.glaccnttype_id") = "Overhead Taxes - Income""

Problem is this Row of Data  "Overhead Taxes - Income"" is not in all reports depending on date range ran.
This is an income statement and depending on the date ranges there are variable numbers of Rows of data.

How do I write the insertion formula to simply have it display at the end of the report?  
My three calculated members are below and each has the exact same insertion formula and show up when the account "Overhead Taxes - Income"" displays

Total Revenue
Total Expense
Net Revenue
0
Learn SQL Server Core 2016
LVL 12
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

I had this question after viewing Append all database values in Parameter not bringing in all data..

I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database.  If I create an "ALL" selection and run the report it does bring in all sites.  Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.

It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing!  Not sure if this has an effect.

I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.

I have come to the end of any other solutions?

Any help is much appreciated!
0
This is in Crystal Reports 11.0
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
               TVS123      tuition Fees      90.00
               TVS356      tuition Fees      75.00
               TVS255      tuition Fees      55.00
               TVS285      tuition Fees      65.00
        Group3(Fee_type)- Other Fees
               L342 extras fees      2.00
               L852 extras fees      7.00
Group-2 NULL
      Admin Fee      100.00

In the above scenario, I have created, Group 2(sp_code) and Group 3(Fee_type).  My Group-3 is in specified order.  Group-2 is in ascending order.  
My issue here is, I want to display Admin Fee in “Other Fees” group like  below.  When Group-2 became NULL, it is displaying Admin Fee as a different Group-2 section, I don’t want to display Admin Fee as different group section.  I want to display as below.
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
                   TVS123      tuition Fees      90.00
                   TVS356      tuition Fees      75.00
                   TVS255      tuition Fees      55.00
                   TVS285      tuition Fees      65.00
        Group3(Fee_type) - Other Fees
                     L342 extras fees      2.00
                     L852 extras fees      7.00
                   Admin Fee              100.00

Is that possible at all to display Admin Fee under Other Fees? Can anyone please help me?
Thanks in Advance.
0
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
               TVS123      tuition Fees      90.00
               TVS356      tuition Fees      75.00
               TVS255      tuition Fees      55.00
               TVS285      tuition Fees      65.00
        Group3(Fee_type)- Other Fees
               L342 extras fees      2.00
               L852 extras fees      7.00
Group-2 NULL
      Admin Fee      100.00

In the above scenario, I have created, Group 2(sp_code) and Group 3(Fee_type).  My Group-3 is in specified order.  Group-2 is in ascending order.  
My issue here is, I want to display Admin Fee in “Other Fees” group like  below.  When Group-2 became NULL, it is displaying Admin Fee as a different Group-2 section, I don’t want to display Admin Fee as different group section.  I want to display as below.
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
                   TVS123      tuition Fees      90.00
                   TVS356      tuition Fees      75.00
                   TVS255      tuition Fees      55.00
                   TVS285      tuition Fees      65.00
        Group3(Fee_type) - Other Fees
                     L342 extras fees      2.00
                     L852 extras fees      7.00
                   Admin Fee              100.00

Is that possible at all to display Admin Fee under Other Fees? Can anyone please help me?
Thanks in Advance.
0
I have created a report that runs as planned in crystal reports 2016 SP4 and through the proprietary software using  Crystal Reports runtime 2008 SP5.  On another computer using the proprietary software using  Crystal Reports runtime 2008 SP5 the report will give me different data each time it is run.  When I first ran the report it showed only data where all the linked fields matched, which is not correct( attached file called incorrect.pdf.)  Then I ran it again and it gave me the correct information,(attached file called correct.pdf).  
The report has 6 tables Customer, Sales rep, Order, Dr, and customer type and are left outer joined, not enforced from customer to the other tables.

The Data base is MySQL

It is the same report  Incorrect ran first, then ran correct right after and different results.  
incorrect.pdf
correct.pdf

Thanks in Advance
0
Visual Studio 2005 crystal reports only shows half of print preview, The right half is faded out...
See attached.

Any ideas?
CR-Report.pdf
0
Crystal report not open more then 75 times
0
when i print crystal report more then 75 times then it give error
0
I need help with doing a Crystal Reports Label. I have messed with this so much this morning and cannot seem to get this to print as I need. I get one label print and then it spits out 7 additional labels. If someone can help and attach a file with the 3 basic values (I can rewrite my SQL) for this dimension, I would forever be grateful. I just need it to print one label and it keeps printing the additional labels.

The Zebra Label Printer is LP2824 Plus.
https://www.zebra.com/us/en/support-downloads/printers/desktop/lp-2824-plus.html

The label dimension is 2 and 1/4 by 1 and 1/4.

I need on the label the following:

Name
Address
City State Zip
0
Here is my data:
country  category   description
US       9          dvfbwrtbrt sd rd
US       9          zdf s tbr t bs th sd
US       9          fdbwrt yr ns t s
CZ       9          tyjnd tyn etyn
US       11         xcbf dg erg
IT       11         far vwer  hade h

Open in new window


In Crystal Reports I am trying to create a box label that has "Box 1 of x" but in the DETAILS section of the report.
The number of boxes is determined by the count of the category field

So for example, the first 4 line items are all category 9.
There are 4 records so there will be 4 boxes
The next 2 records are category 11, so there will be 2 boxes.

When the value of 'category' changes, the total resets.

And so the labels will print like this:

dvfbwrtbrt sd rd
Box 1 of 4

zdf s tbr t bs th sd
Box 2 of 4

fdbwrt yr ns t s
Box 3 of 4

tyjnd tyn etyn
Box 4 of 4

xcbf dg erg
Box 1 of 2

far vwer  hade h
Box 2 of 2

I am able to create a label that shows the "Box 1 of N" but the only way it works for me is if I place that in the group footer section of the report. I want it to be in the details section. (the header and footer are empty).
0
Become a Certified Penetration Testing Engineer
LVL 12
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

When I do a parameter field and choose the list of values to be dynamic, it only shows a certain amount of the list when the user runs the report. How did I get the entire list of values to return rather than only a certain amount?
0
I have a .Net windows app.  It creates a Crystal Report in word.  It pulls data from a datasource and displays it in the report.  Sometimes the field is null and a textbox isn't created in the word document.  Is there a way to create the textbox even if the field is null?

Thanks
0
I have two groupings.  Student i.d. and detail code.  Some detail codes are the same amounts, which is an User error so my dollar amount is in my GF2 section.
I want to sum all amounts by i.d
What is happening when I sum is that I am seeing the wrong amounts because it is summing what I am trying to supress.
What am I missing?
Word doc. attached.
Thanks!
0
Hi All,

I want to decommission a file server that crystal reports server 9 saves it's report too.

Does anyone know where I can find the UNC, so it can be updated to a new file path

Phil
0
In Cr 2008 I have main report (just container for sub reports) and two sub reports that are based on same command.
I am passing Run_Date parameter from main report to those two sub reports.

In each sub I created Run_Date parameter same name as in main report.
Report run but no showing any records empty.
I assume that problem is with my date filed in command:
Part of SQL  command script:

Declare @Run_date Date
Declare @Edge_date Date


Set @Run_date ={?Run_Date}
Set @Edge_Date = DATEADD(YEAR, -2, DATEADD(DAY, DATEDIFF(DAY,0, @Run_Date),0))  


-- Range 1:
-- Range1 is range from Run_Date parameter back to previous YTD beging January 01. To Current Parameter full month date e.g. Sep.26.2018
-- Range will be from 2017-01-01 to 2018-09-31.

--Range 2:
-- Range 2 is range from laset YTD relating  to Current Run_Date Parameter full month e.g. if Run_Date parameter is Sep.26.2018
-- Range2  will be from 2017-01-01 to 2017-09-31.

Declare @Start_date_Range1 Date
Set  @Start_date_Range1 =  DATEADD(YEAR, DATEDIFF(YEAR,0,@Run_date)-1, 0) -- beginning of previous year

Declare @End_date_Range1 Date
Set @End_date_Range1 = DateAdd(mm, DateDiff(mm, 0, @Run_date) +1, 0)  -- End of Run_Date month this year

Declare @Start_date_Range2 Date
Set  @Start_date_Range2 =  DATEADD(YEAR, DATEDIFF(YEAR,0,@Run_date)-1, 0) -- beginning of previous year

Declare @End_date_Range2 Date
Set  @End_date_Range2 = DATEADD(YEAR, -1, DATEADD(DAY, DATEDIFF(DAY,0,@Run_date),0))…
0
I have a couple of my date time fields in my report.

I need to highlight the field background in red if any of the dates are blank/null

I have tried

if isnull(datefield) then crred else crwhite
if isnull(datefield) = true then crred then crwhite

Both have failed

I need to keep the datatype for the field as date time

Any help appreciated
0
Hi All,

My windows application  (VS2013) crash (stop and report to Microsoft) before it shows CR Report.
I have installed CRRuntime_64bit_13_0_2.msi.

What is the problem ?

Thank you
0
I want to know how i can build drill down reports in crystal reports. For example i have report with following details

Invoice No |   Invoice Date   |  Customer Name |   GST No  |  Total Amount
-------------------------------------------------------------------------------------------------------- ---
123                   01 Jan 2018        John                            xxxxx                       80.00

Now when i click on invoice number (123) i want show another report (another rpt file) which shows the invoice details as below

Serial No    |  Item Code    |   Item Name    |   Rate     |    Quantity   |    Amount
-----------------------------------------------------------------------------------------------------------------
1                      IT567                 Pen                          10.00              2                   20.00    
2                      IT586                 Book                        20.00              3                   60.00  
-----------------------------------------------------------------------------------------------------------------
                                                                                      Total Amount                   80.00
0
i have develop Asp.net application With Crystal Report in Visual Stdio 2010...
Application Working Fine in local..
but i public application in IIS server application working fine 1- 2 hours..
after 1 hour application Not Display Crystal Viewer...



Please Help me...
1
OWASP: Avoiding Hacker Tricks
LVL 12
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Please have a look at the image attached:

here is how my flow is
 1. Database server
 2. Application server and application server can establish connection with database server) (here the crystal report will run fine)
 3. Local system (and client will establish connection with the application server) (here the report is not working)
Image01as i'm not able to connect to database server directly, how i will open crystal report from client system.
for now i'm getting error "access to server is denied"
0
I AM TRYING TO GET THE LAST MONTH RESULTS WITH OTHER CONDITION LIKE I HAVE THREE GROUPS IN MY REPORT I WANT LAST MONTH RESUlTS FOR GROUP 3 IN CRYSTAL REPORT  2008. Can some one help me.
0
Hi,

I need help please to find out the  average time for a fitter on his jobs
Start time       End time           Time spend
 11:14:26         11:17:11            00:02:45
 14:17:00         09:58:17            19:41:17
 08:51:39          09:45:24           00:53:45

Please can you help me as I need to find the average time spend in crytal reports
0
I want create account Statement crystal report in visual c# but my transaction table have debit credit fields. please see attached sample file and suggest me...
0
Hi EE,

is there a way to change tons of Crystal reports connection dynamically or with a software ? without going one by one ?
We are changing and upgrading our SQL server and we have about 500 crystal reports (they may not be all used, but who knows) as soon as I change the server, I believe all of them will stop working.

Of course if we go one by one to change the connection inside it will work, I was wondering is there is a faster way ?
0
This is probably a strange request as most want to suppress duplicates, I on the other hand want to duplicate a record based on number of occurrences per year.  So if the activity is weekly I should see 52 records with a generated due date based on frequency code and the last  duplicated records calculated due date.

I am trying to forecast a preventive maintenance activity based on frequency code such a YR, MO, DY, WK, etc.

WhilePrintingRecords;
DateVar NextDt;
StringVar IntervalType;
NumberVar Interval;

Interval := ToNumber({FREQUENCY_UNIT});

if {FREQUENCY_UOM} = 'YR' then IntervalType := 'yyyy';
if {FREQUENCY_UOM} = 'MO' then IntervalType := 'm';
if {FREQUENCY_UOM} = 'WK' then IntervalType := 'ww';
if {FREQUENCY_UOM} = 'DY' then IntervalType := 'd';


NextDt := Date(DateAdd (IntervalType,Interval,{@Due Date}));

NextDt;

Hopefully this makes some sense.
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
>