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

We have started to get this error recently when our SQL application generates a PDF document, from crystal reports. It generates some but throws the error on others. First I thought it was throwing the error for larger files, but using Firefox and Adobe 11, I could generate a 28 pages pdf but failed to generate a 10 page PDF.

Using Chrome and IE, I cannot generate the PDF's that Firefox can generate. Overall, nothing is consistent. I have tried the trick mentioned on the link below, but it did not work.

http://thenubbyadmin.com/2012/04/13/solving-the-error-the-file-is-damaged-and-could-not-be-repaired-when-opening-a-pdf-in-internet-explorer/
0
On Demand Webinar - Networking for the Cloud Era
LVL 9
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

I downloaded Crystal Viewer from SAP. In particular I needed 2011. I installed this on my target server. I have some Crystal RPT files which are reports I created. I need to be able to run those from ASP. I'm using Sage CRM which used to support Crystal Viewer, but for reasons unknown, doesn't any more. The ASP code that you code in is server side javascript using the COM API for CRM.

If I have an RPT file, how can I run that report and pass in parameters. Ideally I would be able to run the report by simply hitting a URL like you can in SSRS but for that I think you need full Crystal Enterprise and that is not an option.

If I wanted to call a report and have it show in the Crystal Viewer in a pop up, how would I do that? Can I then export to PDF or Excel from the viewer? I tried converting the reports to SSRS which would be perfect except I cannot control the grouping the way you can in Crystal, probably because I don't know how rather than the program can't do it.
0
I need to have both a combination of cascading prompts (State -> Product -> Pack Size) and the option to select ALL at each level as well. I'm still fairly new at this and better understand real actual work than watching videos and reading books so be forgiving if this seems an easy request. And year be inputted in statically. How can I do this? Thanks for your help!
0
We picked up a copy of Crystal Reports 2011 (version 14.0.4.738 RTM) to produce a specific report that included data from 4 different spreadsheets and a couple of formulas. Crystal reports is installed on a Windows 7 pro 64 bit machine. MS office is not installed on that machine, (if that matters). Crystal reports refused to work when I tried using "xlxs" files. I had no problems getting results using Excel 97-03 workbooks (.xls). Now I have a new project that has a little twist. One of my data sources is a spreadsheet that is split up into a series of worksheets (one sheet for each letter of the alphabet), because if it were all on one sheet it would exceed the number of rows allowed by the 97-03 version of Excel. I of course want to insure I use a data source that is compatible with Crystal reports 2011. The project would require that the data be refreshed (reloaded and re-imported) every week or so. Would my best bet be to import the individual sheets into an Access (version 2003) database?
0
Hello guys,

I've found a page that supply font code 128 and there is an example for crystal report.

How can I use it? Can you help me with this?

this is the link

http://grandzebu.net/informatique/codbar-en/code128.htm

Thanks a lot
Regards
Alex
0
Hello Guys

I am trying to find where could I download font code 128 to use in my Crystal reports.

regards
Alexandre
0
Hello.  I am running a report to capture a particular cost center.  When I include this cost center from the MMDIST table, along with less than a  year as a time parameter, the results are enormous! I'll get over 100 lines of identical information down the last detail.  How can I minimize this to just one line per item? I am running a report for 9/1/2016 to present for all purchases under 18050 cost center.   I'll get the same line, same PO number, same everything for over 100 lines before it changes to the next item.  Any way to minimize it to just one line per item?
0
We run Crystal Reports (rpt) from within the software programs we produce at our company, and we typically display the results using the Crystal Reports Viewer from within our own app.

Many reports have a main report and a subreport.  For instance, I will often have a person's name followed by multiple arrest reports or incident reports in which the person is named.

When I get the report data back, I can click on hyperlinks in the main report that take me back to OUR software, displaying data details for the item in the hyperlink, like the person's name.  Clicking on the name will bring up person detail in OUR application.

I also have hyperlinks in the subreport, that should bring up the detail for individual items, like arrests or incidents.  

When I use PDF output, all the hyperlinks work, both in the main report and the subreports, and clicking them opens the appropriate detailed view in OUR application.

However, when I run the reports using the Crystal Viewer version, only the hyperlinks in the main report work.  The subreport is seen as one big element, and I can't click on the hyperlink text.

I've tried unchecking all the "Keep Together" options, but I can't get the hyperlinks to work from the subreports.

What option do I need to use? Thanks.
0
Hi Experts

I have a large data set (2.5 million records).  What I need to do is to find the latest transaction, which isn't the problem, but also to have it be not only the latest transaction but ONLY if the latest transaction code is "VAC1" OR "VAC2".  If the last transaction is anything other than one of those two codes, then don't include it.

Any help would be greatly appreciated.  

Andy
0
Hi EE,

Can anyone guide me that How do I print two copies of A5 paper size report on single A4 Paper?

Regards,
D Patel
0
[Webinar] How Hackers Steal Your Credentials
LVL 9
[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.

I have an SSRS report. It selects data from a view and the single parameter is used as the where clause. Without trying to explain things explicitly, the report is essentially a quote form. So, I pass in a reference number and it generates the quote. Basic stuff like company name in the report header, company address, then in the body, the quote items list. Assume the quote will always be a single page. As the same quote is being sent to more than one company, the quote header has the company name and address, then the quote items duplicated on each page in the report body. The footer contains the count of companies the qujote is being sent to so they know how many people are in the running for the quote. I've got everything working except the company name and address in the header doesn't change.

I have the exact same report in Crystal and that works because instead of apage header, I put what is essentially the page header into a group header. This allows me to change the name and address as the group changes. How do I do the same in SSRS?
0
I've converted HTML text with the Crystal formatting feature text interpretation, but some of the tags remain.  Example file is attached.  Is there anyway to remove these characters from the text in Crystal?  I've considered a replace formula, but I don't know how to get Crystal to recognize the dagger and double dagger.  Any help is very much appreciated.
Using Crystal Reports 2013.
76228--Progress-Note--12202016__exp.docx
0
Hello,

In the attached report, is there a way to suppress group header 1a if 1b is suppressed?

Thanks.

hardware-EE.rpt
0
Hello,

I use Crystal Reports 2011 and 2016.  

I have attached an xls file to illustrate my tables.  Table_A is a real and accessible table.  It has the Color codes as listed on the spreadsheet.  There is no such thing as a physical Table_B as I have illustrated.  I need to create it somehow.  I need to join Table_A, Field_48 to Table-B, Field_1.  Then I want to put Table_B, Field_2 into the Parameters when I runITables.xls the report.  I am not sure how to do this.  The company I work for has data which is not in a physical table.  I am pretty new to Crystal Reports.  Thank you in advance.
0
0
All,

I have limited knowledge of reporting in general, however, I have been tasked to migrate Microsoft Access reports to Crystal Reports.

For this question, I was hoping to find out how to suppress values that show up from the parameter selection when a report runs.

On report run, I am prompting the user to selection a location code via qSel, which is setup and working fine. On the parameter values selection prompt, however, I want to limit the user's choices from the original data table.

Crystal Reports value prompt
CAMPUS_CODE
CHS, CLT, DCE, DEN, MIA, NOR, OFF, ONL, PCE, PDC, PHC, PHD, PHH, PVD, VAL

Only want to show locations for CLT, DEN, MIA, ONL, PVD in parameter selection

Is this possible and if so, how? Thanks in advance!
0
Is there anything Telerik Reporting can do that SSRS (2005) cannot?

Specifics: We're looking to migrate our current Reporting infrastructure from in-house ASP NET + Crystal (VS Edition) to something else.

Ignoring the cost factor (we have a Telerik license), is there any pros or cons to going with Telerik over SSRS?
SSRS
Key elements we need are:

generate reports from a custom ASP.NET application
schedule reports
email reports on demand or on a schedule
pdf output, drilldown html
massage the dataset in C# before passing it to the rendering engine
Any experiences or sites that point out advantages or limitations (with either engine) would be greatly appreciated.
0
Hello,

I need to sort the records after all the group headers.  So the end result of the attached would be:

I-14960
  999806
  141
     Record
     Record

I-314
  999824
   312
     Record
     Record
     Record
     Record
     Record
     Record
     Record
     Record


Thank you,
Joel

GlassTest3.rpt
0
Hi,

I am migrating an old Crystal Report to an alternative Dashboard application.
My crystal report (which works very well, shame I have to migrate) reads from a table of monthly stock sales history.

e.g.

STOCK CODE   MONTH1UNITS   MONTH2UNITS   MONTH3UNITS   MONTH4UNITS   MONTH6UNITS   MONTH7UNITS
ABC123            100                         87                          69                          93                          108                        111
ETC
ETC

My Crystal Report had a parameter to prompt the user for number of months to report on.
A calculated field in the report registered all 60 of the month columns into an array and then looped through the correct number of months based on the user parameter for number of months to aggregate for each stock record in the report.
This solution was simple, elegant and worked very well.

I don't have the facility of arrays in the alternative Dashboard app.
Can anyone suggest an alternative way of achieving similar through SQL in Stored Procedure?  I'm struggling...

Hope i've explained clearly enough?

Thanks in anticipation...
0
Free Tool: SSL Checker
LVL 9
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Have a table called Questions which contains all questions on a form. It runs from a stored procedure in sql and creates a temp table #_tQst like this:

QID (Question ID varchar)
TabSeq (tab sequence number)
QDes (Question text)
Etc…

Have a table called Answers which contains all answers client gave to form questions above. It runs from a stored procedure in sql and creates a temp table #_Ans like this:
DocId (unique number created when form answers are given)
QID same as above
Val (answer given -text)
DatIn (date form given to client -date)
CplDat (date form completed -date)
Adm (Client ID – number)
Name ( text)
Branch      (branch – number)
Etc…

I need to see all the questions on the form with any answers given by the client.   Problem is only questions that are answered are stored in a table indexed on the DocId.  Would like to see:
Name      QID                   QDes                  Val      
Bob        1                   Age                  55
Bob        2                  Married            Yes
Bob       3                 weight                        (no answer given)

Bill             1                 Age                        (no answer given)
Bill            2                Married            yes
Bill            3                Weight                  175

Mary      1                Age                  65
Mary      2                Married            No
Mary      3                Weight                        (no answer given)

All questions and any answers given for each person (DocID)

The report is run based on parameter fields that are stored ONLY in the Answer table namely DatIn (range of dates), Branch number, etc.
Best I have come up with is Main report based on …
0
I am creating a crystal report, which is new to me.  It is a Bill of Lading report.  The top of the report is filling in OK, it's when I get to the rows in the detail section, so for example if I am shipping 3 items, I get the main report without any detail, the I get three pages of the grid one page per item shipped.  I have attached the first page and one page that follows, I would have 3 other pages each page is filled with each items data.Page1.JPGOtherPages.JPG
Here is my code.

cry.Load(Server.MapPath("~/Reports/BOL.rpt"));
SqlDataAdapter da = new SqlDataAdapter("PrintBOL", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@BOL", SqlDbType.Int).Value = B;
da.SelectCommand.Parameters.Add("@Supplier", SqlDbType.Int).Value = C;
da.SelectCommand.Parameters.Add("@Carrier", SqlDbType.Int).Value = S;

var dt = new DataTable();
da.Fill(dt);
cry.SetDataSource(dt);
//crv.ReportSource = cry;
cry.PrintToPrinter(1, false, 0, 0);
0
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3
0
Hi,

I am pretty new to Crystal reports and am currently working with version 11. I have a report that uses a date range parameter for the primary report data. This report has a sub-report that I am trying to link to this parameter so that the data is pulled for the same date range without having to input the dates twice. I have tried a couple of solutions that I found online, but after entering the links I lose the sub-reports data. So obviously I am missing something critical. Any advice would be much appreciated.

Thank you,
0
Hello, I have created a simple report and created some basic parameters but when I run the report is blank
0
I am using Crystal report 2013,and visual studio 2017. but how to deploy on client machine.For Data Source in crystal report I using ODBC. i Already create proper ODBC ,and i download report distribution package from sap and install but still report not working.
and mypc project path shows as my attached image show. sir please help...... because your help save my reputation.thanks advance.
errr---Copy.png
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