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

if I have a parameter called parm1 and the available dropdown options are:
test1
test2
test3
test4
test5

if the user selects <test2> for parm1 then I don't want <test2> in the dropdown for parm2
so my available options for parm2 would only be:
test1
test3
test4
test5

how do I make that happen?  Thanks for anyone that can help me!
0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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
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
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.  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
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
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
[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.

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
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
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
I have date string like "11/05/2017" in db. With CDate i am getting "05 Nov 2017" but it should be "11 May 2017". I am currently using CDate({DateString}).
0
i want to export a report in excel format without open a crystal report could you suggest me that how can be implement this?
0
Hi

 I am working on a crystal report and have a requirement to remove the duplicate(partial/like) match entries from a multiple list parameter.
 So I have a multi value parameter which might contain below value

Accounts

 ABC-12345-000
 XYZ-56982-111
 ABC-98090-222
 UXY-12334-333

 What I required to send a message to a user if there are partial duplicate before first '-' like in this case, there are two ABC entries users choose, and I need to display a message to a user to pick just one entry, from same account like below:

 ABC-12345-000 OR ABC-98090-222
 XYZ-56982-111
 UXY-12334-333

 Thanks, Saif
0
Dear sir,
i have published windows forms application using visual studio 2013 and for reporting used SAP product cristal report 2013 for visual studio  when i run on client machine it installed perfect  but when i click on report form it shows an error:
ERROR: ''crystaldecisions.shared.sharedutils;threw an exception''
cr.png
0
Want to be a Web Developer? Get Certified Today!
LVL 9
Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Dear sir ,
can be Stretch text written with in the text box or in formula field. So the name of the company cover full width of the page.


With Thank
A. K.Saxena
0
I have both Access 2016 via Office 365 and Crystal Reports 2016.  I had the previous version of Crystal Reports and Access and connected fine using the 32 bit Access connection.

Even though I have 2016 versions of both I'm unable to make a connection in Crystal 2016 to Access 2016.
0
looking for solutions how to create interactive surveys whereby at the end of it, some customized reports would shown instantly to the user online. e.g of this is this link https://www.nab.com.au/personal/investments-super/financial-advice/financial-health-check
0
Please help.  I have the below query and I want to get the dates to use US format MM/DD/YYYY to run a report using Crystal Reports.  I am using the following line of sql:-

      where CONVERT(DATETIME,(substring(A_AUMDTETME, 7, 2) + '/' + substring(A_AUMDTETME, 5, 2) + '/' + left(A_AUMDTETME, 4)),103) BETWEEN {?1StartDate} AND {?EndDate}


The entire sql query is listed below:-

DECLARE @today VARCHAR(50)
DECLARE @previousDate VARCHAR(50), @todayDate VARCHAR(17)

SET @today = (SELECT DATENAME(WEEKDAY, GETUTCDATE()))
SET @todayDate = dbo.CTUTCDate()
SET @previousDate =
CASE
      WHEN @today = 'Monday' THEN
            (SELECT CONVERT(VARCHAR, DATEADD(DAY, -3, GETUTCDATE()), 103))
      ELSE
            (SELECT CONVERT(VARCHAR, DATEADD(DAY, -1, GETUTCDATE()), 103))
END

SELECT
      Table1.[Instrument],
      Table1.[YtD P&L Value]
FROM
(
      SELECT TOP 200
            ISNULL(I.A_TKRCDE, I.A_INSNAM) AS 'Instrument',
            ROUND(SUM(A_ACCDAYPNLVAL), 2) AS 'YtD P&L Value'
      FROM T_ACC_AUMDET AD
      LEFT JOIN T_ATH_INS I ON AD.A_INSID = I.A_INSID
      LEFT JOIN T_ATH_INSTPEMAP ITM ON I.A_INSCLSCDE1 = ITM.A_INSCLSCDE
      WHERE A_AUMID IN
      (
            SELECT A_AUMID
            FROM T_ACC_AUM
      where CONVERT(DATETIME,(substring(A_AUMDTETME, 7, 2) + '/' + substring(A_AUMDTETME, 5, 2) + '/' + left(A_AUMDTETME, 4)),103) BETWEEN {?1StartDate} AND {?EndDate}
            AND A_ACCID = '{?AccountName}'
      )
      --AND ITM.A_INSTPECDE <> 4
      GROUP BY I.A_TKRCDE, I.A_INSNAM
      HAVING ROUND(SUM(A_ACCDAYPNLVAL), 2) <> 0
      --AND ROUND(SUM(A_ACCDAYPNLVAL), 2) <…
0
Dear Friends,
I have an application, which have many crystal reports. None of the reports are loading on the production site, but when I am debugging, I am getting some of them, but for other reports I am getting the below error.
Failed to open the connection. Details: [Database Vendor Code: 12154 ] Failed to open the connection. Details: [Database Vendor Code: 12154 ] Failed to open the connection. UniquePhoneDescriptions 22264_16812_{7A01D2B8-1B21-4BEA-BA22-0A214D6A6A99}.rpt Details: [Database Vendor Code: 12154 ]

I am wondering, when all the reports are connecting to the same DB Server, how can it have the issue with some of the reports. in my local machine, I have installed Crystal Reports 64 bit and on the server we have 16 bit. Is that casuing the issue on the prod web site?
Please suggest.

Thanks and Regards,
Sajitha Chandran
0
Hi,
I want to compute balance cashbook reconciliation statement in crystal ,
I have STATEMENT  BALANCE which is initial balance depending to period have selected,
I have two columns for Deposits and withdrawals.
My problem is I want to get running balance  depending whether is withdrawal or deposit.thank you
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