Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

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

Hello Experts

I have old Crystal Reports version 4.0 Pro developed by the ton and they are most of them called from old VB3 program and worked fine ever since.

Today one of my staff reported that they keep getting the Error 20500 Out of Memory on a specific report under specific criteria selected. They run Win 7 32 bits. We tried an other chap at the office and they got the same error too on the same report. Mind you all other reports works fine and this report is not memory hungry. What it does is when you launch the report from the VB program you get the preview window and the records starts rolling up to a point when you get this error. I ran it a couple of time to see if it is related to a specific record but NO it throw the error every time at a record count different.

I thought that maybe I should increase the MaxbufferSize of Jet in the registry under Jet 2x but this did not help, any clue here ???

I tried the same report on my machine Win 7 64 bits (under the Virtual Machine running XP) and the report ran fine with no error whatsoever.

I have been all day checking all about this error on the Net and have done all possible but can't find anything that fixes it.

The database used in the VB3 is MDB Access 1.0 or 1.1 or 2.0
0
How to Use the Help Bell
LVL 10
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

I have a report that contains a cross-tab with a row for a surgeon and a second row for procedure.  I want to suppress the total that is generated for the surgeon when there is only one procedure.  In the example, I want to suppress the entire total row for surgeon 12345 as it is not necessary as there is only one procedure.  Is this possible?
Example1.jpg
0
Hello Experts,
I am using CR version 14.2.4 and attempting to make a sort of 'heat display' in a crosstab by conditionally highlighting the cells. I tried putting the formula below into the formula editor on the Border tab in 'Background', but it did not display a highlight,  which didn't surprise me because there are two conditions to reference - the hour and the day.

if distinctcount({CAD_Data.CALL #},{@Hour Start DT}) >= 35
then silver else nocolor

I attached a sample of the crosstab I am working with, and a screenshot of what I am trying to do. Do you know of a way I can use Crystal Reports to create this sort of chart?  If Crystal Reports can't do this sort of 'heat' display, can you recommend a graphing software?

Thank you for your help.
Respectfully, ChopSampleDataCFS.pdfThis is the type of display I need to create
0
Have two fields {receipt-date} & {receipt-time} that i need to combine so I can use date\time conditon in running total.

Running total formulas needs to say the following:
receipt-date-time  between currentdate-1 <=4:00pm to currendate between 12:00am-8:00am
0
I am new in this Crystal Reports thing and I have problem, since my coworker usually doing this stuff is sick at home I need to figure it out my self. I have 2 tables.

First is like this:

Article.ID    Article.name Article.buyingprice
1              aa           2.00
2              bb           1.00
3              cc           3.50
4              dd           4.20
5              ee           2.00

And second is like this:

Income.ID Income.article  Income.date  Income.number Income.quantity
1          2               79100        P1            2.00
2          1               79100        P1            3.00
3          4               79101        P2            2.00
4          3               79101        P2            1.00
5          1               79101        P2            4.00
6          5               79101        P2            1.00
7          2               79103        P3            15.00

What I need is formula for selecting Income.quantity from the latest Income document. For example for article aa it will be 4.00 and for article bb it will be 15. Please save my job folks :)

Report is grouped by article.name.
0
I have a string value {dbo.CharConfidence} field that typically has 7 values separated by a comma (82,81,81,85,93,67,8) I am looking for a formula that will count the individual 'instances' separated by a comma. the example mentioned in bold  = 7
0
i have a cross tab report with 2 values ex LL -1.75
                                                                      US 1.75

i need to have the below result LL -1.75 IN RED
                                                     US  1.75

HOR TO DO THAT
0
I have a database that has UNIT_COST as a MEMO field.

I am building a report using Crystal Reports X1 and I want to calculate the On Hand Cost using the formula:
{topsmods_tbl.on_hand}*{topsmods_tbl.unit_cost}

however I am getting the message that a 'number or currency amount is required'

How do I convert the Memo Field to a number in Crystal Reports?
0
hi , i have a crystal report designed as below :
***************************************************
account1
         Supplier1   Currency1
                            Currency2
        Supplier2    Currency 1
                            Currency 3
                            --------------------------------
                            Sum currency 1
                            sum currency2
                            sum currency3
***************************************************
i need to know if crysta report for visual studio 2015 have a feature that do that.
thank you
0
I have a "comments" column that contains a simple comment, I want to check this comment to see if it appears in 5 other columns. If match is found then Yes, If not then No.     See attachment example.   This is what I have so far but of course not working.

In formula workshop I created:  this dosnt look right to me can someone fine tune it or is it correct?

if {Command.COMMENTS} like {Command.SVC_LVL_EOB_1}
and
(
{Command.COMMENTS} like {Command.SVC_LVL_EOB_2}
)
and
(
{Command.COMMENTS} like {Command.SVC_LVL_EOB_3}
)
and
(
{Command.COMMENTS} like {Command.SVC_LVL_EOB_4}
)
and
(                
{Command.COMMENTS} like {Command.SVC_LVL_EOB_5}
)

 then  "NO" Else "Yes"
Image-sample.jpg
0
Important Lessons on Recovering from Petya
LVL 10
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

i have developed vb.net application in visual studio 2010 using crystal report version13.0.20.2399 ,
its working fine in my developers pc but its giving problem for crystal report in clients pc plz suggest and help me the solution
0
I'm able to display a report name on crystal reports with the following and it saves me a lot of time:  
//This is the formula name
StringVar Array File:=Split(filename,'\');
NumberVar i := Ubound(File);
File bracket i bracket;


I'd like to also display the "database location" (usually a stored procedure) on the report as well.  Does anybody know how to do this?  We have crystal reports 9.0.

Thanks!
0
Hi Experts,

While viewing the output in crystal report viewer currency symbols are displayed correctly.
But after converting to PDF its showing 'Square' in place.

Crystal Viewer :
CrystallViewer.JPG
PDF :
PDF.JPG
Please suggest the solution.

Regards,
D Patel
0
Hi Experts,

I have formatting issue with text which is formulated using formula and HTML Text Interpretation.

The text cannot get aligned into horizontal center.

Present Output :
formating.JPG
Formula used :
ToText("(" & {table1.sCurrencyName} & " " & {table1.sCurrencySign} & ")")

Open in new window


Settings Done :
HorAlignment : crHorCenterAlign

Desired Output:
The text highlighted in image needs to be displayed in horizontal center of that column.

Please help.

Regards,
D Patel
0
Hi,

Can I separate the same column name two times?

Please refer below screen shot for better understanding.

If a single supplier is having two ports (As shown in image), then the supplier name is shown once. Can it be displayed twice
crosstab-supplier-name.jpg
0
Hi,

When a crystal report has a sub-report, then a tool tip is displayed on the report.

How to hide that tool tip?

Attached image is for more reference
Tool-Tip.jpg
0
How would I do a distinct sum in crystal? Say the records returned would be 1-1-1-2-2-5-1-1-1-1-1-1-5 and I wanted the total to be 8? The records don't repeat consequtively. There is distinct count but not distinct sum. Thanks
0
I have a group based upon a field we can call the {TestID} field. However, I need that group to sort according to a different field in that table, the {SortOrder} field. How best to make this happen?
0
In a sales report I want to enter a date range from two DB fields used in a formula and then list two columns of results that list the results from the date range entered, as well as a comparison column of data from exactly one year previous. I'd like them to be listed side by side. Would I use a Subreport for the comparison data? And if so, how would I take the entered date range and have the Subreport use data from the previous year? I want only one prompt for a date range and have the report handle pulling data from the previous year for the comparison.

For example:

LEAD SOURCE CURRENT DATE RANGE:                                               LEAD SOURCE ONE YEAR AGO:
Lead Source: (formula 1)       Sales TTL: (formula 2)                          Lead Source: (formula 1)       Sales TTL: (formula 2)

I hope this is clear enough to follow, and thanks for the help!
0
Free Tool: Site Down Detector
LVL 10
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi,
Thanks!
Am using crystal report 13.0.0.99 and VS 2010.
Am trying to print the reports using CR. All my report data in details section. There is no data copied to report section. But when i print the pdf , i see blank pages (Report footer and Page Footer). How to avoid printing blank pages.

Kind regards,
Pooja
0
i can't able to access and install  crystal report in visual studio 2017 community edition in OS 10
0
I am trying to use "Suppress If Duplicated" on the cross tab's non summarized fields, but it is not working.

Attached is the screen shot for reference.
DuplicateValues.jpg
0
Can you please suggest me on can grow functionality w.r.t cross tab. For example, if the data in one cell is large, then it gets trimmed off instead of wrapping it and enlarging of cell.
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?
While exporting to excel, I select Following steps to export crystal report cross tab to excel:
  • Export Report
  • Microsoft-Excel (97-2003)
  • In Excel Format Option I select "Show Gridlines" field
PurchasingExportAnalysisTabReport_34.xls
0
I have a crystal report that uses the "Ship Date" on the X asis.  It currently display as mm\dd\yy but I want to display as mm\dd\yy weekdayname

example:  9/7/17 Thursday

I cannot find an option to format.  Can you tell me how to create a formula that does this format and i can then refernce it in the chart data?
0
Hello,

I am trying to achieve the conditional highlighting of a summarized fields in cross tab.

Basically, I want to compare which has the least value.

Attached image will give better understanding highlight-cross-tab.jpg
How can I find out which summarized field has the least value.
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
>