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

Hello,

Are you able to help me change the following report:

•      In the Product Code and Product Description columns where it says “text” I need this to be italics (text only though, please see screenshot attached)
•      Are these ‘text’ line able to print before the product code lines rather than after?

It has been saved with data.

Thank You.
CustomerOutstandingOrders.rpt
Untitled.png
0
Hello,

I’m hoping you can help me with the attached (saved with data) backorder report?
The report is currently only showing remaining to deliver (or what is on backorder) quantities.
I am wanting to change the report so it shows all line items regardless of the delivery or invoiced status.
Are you able to assist?

Thank you.
CustomerBackorders.rpt
0
I created a Cross Sell report - for every Fuel Customer we sell Lubes to - I need to count the customer in that Group and use the number in a formula for our score card.

In Crystal Reports - I have a field for Lube Sales  -I want to count any of the Lube sales in GF3 if the total is not 0.  I need to have the Count in GF2 to use in a formula.  I have tried several formulas and running totals and it is not working.  

Can you help?  I attached a screen shot of the report.

Thank you!
0
I have a formula
if (isnull ({MembersDetails.Medical Conditions})) then 'None recorded' else ({MembersDetails.Medical Conditions})

But is does not work
The field in the database is completely blank, so is the problem that I am saying 'isnull'
How do I correct this?
Gordon
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 my CR 2008 report I have main report as container for two sub reports that are created- based on the same sql command.
I am passing two parameters in each sub report.
 First parameter is ?Run_Date and I am using formula @CustomerNum to pass second parameter ?ListOfCustNum.
In each sub report I created sub report parameter named:
 ?Run_Date and ?CustomerNum – Name is the same as formula in main report.
 In sub report  parameter ?CustomerNum is number type and I did not checked Allow multiple value.
My formula in main report :
@CustomerNum
Numbervar Counter;
Stringvar display;
For counter := 1 to count({?ListOfCustNum}) do (
Display:= display + ToText({?ListOfCustNum}[counter], 0 , ””) +  ”,  “);
Left(display,len(display)-2);

I made links from main to subreport ?Run_Date and @CustomerNum.
I am getting proper date but not passing list of customer numbers in.
In sql command I have in Selection statement something as : Select ….where i.CustomerNum in ({?CustomerNum})
0
I have a crystal report
With some fields that do not contain data
I would like to suppress these and move other data up in it's place
Ie
Address 1
Address 2
Town

so I may not have any data for address2 so rather than a gap, can I then see, with no gap
Address1
Town

Gordon
0
I am looking for some direction in creating a Crystal Report using Crystal Reports 2016 and a SharePoint 2010 list as a datasource.
0
In Crystal Report 2008 .
I am working on one my old report that calculating rolling amounts from customer that have orders from different suppliers.
Columns that I need to compare are: Month, Three Months and Year (6 columns)
-      Full selected month this year to the same month previous year;
-       Three months back from selected month this year to the same three months in previous year
-      Current YTD up to full selected month to previous year to date.
Condition is that only Customers should be included that have orders from suppliers which are older than two years from selected date.
One customer can have several suppliers and one supplier can have several customers.
It means those customers have to have order older that two years from parameter date but they can have beside those  at the same time orders that are not older that two years too.
I need grouping on Suppliers and then their Customers and calculating those values for each customer with total for supplier.

Customer which do not have any orders (amounts) in previous year column should not be included in calculation and should not be shown in report.
I have problem how to restrict and not showing customers which do not have orders in previous year(even they could have in this year).

I created one Main report and two subreports (rpt_Main; rpt_SubMainA; rpt_SubMainB).
In rpt_SubMainA I presented every Supplier with their customer and do those calculation in columns.
In rpt_SumMainB I show only final …
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
What connection type to i use to connect Crystal Reports to an SQL express database?
Gordon
0
Hello,

Can you please help me modify the attached report so it sorts the Quantity field from largest to smallest?

I am also wondering if it is possible to add a 'drill down' to the report on the header record and the drill down would show the child record?
An example of this in the report is:

10000.white.06
10000.white.07
10000.red.01

Header record would be:
10000

Drill down would then show:
10000.white.06
10000.white.07
10000.red.01

I have saved the attached file with data.

The existing drill down feature (To show Customers) can be removed if need be.

Thank you.
SalesByProductByCustomerSummary.rpt
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
Hello,

I’m wondering if I could please get some help with my Crystal Report?
The 5th column in from the left called “LYSales” is not calculating the correct last year sales values and I am unsure why.

The sales financial period in Australia is from July to June.

I have saved the report with data.

File attached.
MatrixSalesByProduct12Months.rpt
0
I am running sql server 2016 on a new server.  I have views that convert binary blob fields to text that I can use in Crystal Reports.  For some reason, when I bring them into my crystal report, it only show the very first character of the converted field.  If I look at it in SQL Server, it show the entire text in the converted field.  Anyone have any ideas why it's doing this and how to fix it???
0
Hi,
I am working with crystal reports in VB.NET 2008.  I need to understand that how can I insert a page number in the details section.  Please note it has to be in the details section. I've tried the traditional way of placing the special field "page N of M" in the details section but while printing multiple pages for a single record, it only appears at the end of the record, while what I need is that it should appear on each page and get reset for a new record.  Will I have to create a formula to accomplish this.

Thanks in advance.
0
Hi there,

I have a  report that has several columns but have just been asked to add a notes field which means that the lines used to create columns will appear in the notes as well, dividing the text.  Is there a way to retain the clarity provided by the lines but if there is a note for the lines to "suppress" or "disappear" when a note is present? - Perhaps overlay? But I can't figure this out - thanks so much in advance,

CS

 *Crystal 11 is the product I am using
0
I have 4 simple formulas that evaluate different statuses from a single table/field and display in columns client names depending on what status they are currently in. Currently my report displays as shown in the attachment. I want to have the results line up in a single row across the four columns without the blank areas in the report. I can do it in a text object using database fields, but that method does not seem to work with formulas. I need to use formulas to get the right results.
Sample1.docx
0
How can I write a conditional suppression formula to suppress the repeated word "Color"? I can't use the suppress duplicate feature for this field since we use it for other things that must be repeated. I have the Test#200 suppressing because that one has to be suppressed all the time. In some cases Test#177 has to show the word "Color". In this case, there is a Test #116 present and when this test is present along with #177 and #200 the word "Color" field = {LabMethods_ReportedName} should only show for Test ID#116 and suppress for #200 and #177. I tried to do a conditional suppression on the Duplicate Suppression but it didn't work for me. Maybe I did that incorrectly.
RP_CofA_Form.rpt
Example.docx
0
I have a Crystal Report and in it a File Path that links all of a patients records to scanned in PDFs. This will be used in a secure environment, so not a risk. What i need to have happen is when I click on the file path in the report, it opens the document. Is this possible, click on a file path and open the PDF associated to that file path address?
0
I wish to format currency in my report to make large amounts appear as following:
$1,200,000   would appear as $1.2M
$400,000 would appear as $400K
$10,000 would appear as 10K

My numbers do not get into billions  :)
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
Need a crosstab of % of payments to charges with discharge date on vertical and payment date on horizontal.  See attached sample.

In crystal, I have created a formula for total charges, total payments, and %_Paid (Charges/Payments), but they don't seem to work in the crosstab the way I need them to.

Any help would be appreciated.  I must be missing multiple steps.

I have attached an excel sample file of the way it should look when completed
and a screenshot of the way I have my crosstab set up currently.

I have a sequel query that has fields for payment month and year, discharge month and year.  Attached is a word document which shows the crosstab setup - not the way I like it - so hoping someone knows how to set this up the way I need it.
Cross_Tab_Setup.docxReserving_Payment_Lag_draft_BJE.xlsx
0
I have several fields i wish to concatenate and display as a single string within a detail section.  

a. Is there a limit on the number of fields that can be concatenated?
b. Is there a limit on the length of the resulting string?

When I run the report in SAP BusinessObjects XI 3.1 I get the following cryptic error when I try to go to the next page.
message: Syntax error
description: Syntax error
number: -2146827286
name: SyntaxError

However; when the report is ran in Crystal Reports 2008 it works fine.
0
I am trying to create a Parameter in Crystal Reports that lets users enter a {numeric value} that shows all values both Positive and Negative or could show only positive values or of course only negative values. Using a number entry only. Is this possible or do I have to use string values to enforce the greater than 0 (or some unique value) , less than 0 (or some unique value), equal to 0 (or some value) , or all values? I am drawing a blank here and cannot remember how to do that or if it is possible?
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
>