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,

I've been playing around with the Always_on technology in SQL Server 2014 Enterprise.  I've got a production database and I've created a secondary database using this technology to use as a "Real Time" reporting database.  I've got the databases setup using Always_on and I am using Crystal Reports XI to try to connect to the "Synchronized" database but I am unable to connect.  In fact when I try to create an ADO connection to the database I put in the "sa" user and password and the database doesn't even show up in the database dropdown.  I've got the secondary database set to "Readable"

Any help would be greatly appreciated.
0
[Webinar] Learn How Hackers Steal Your Credentials
LVL 9
[Webinar] Learn 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. Thursday, July 13, 2017 10:00 A.M. PDT

If there is any insight that you could give me on this situation, I would appreciate it. I feel like I am really close to an answer after days of progress.

My challenge is that I want to display data from one column in two different places:

Here is what I am shooting for:

Diagram 1: Pipeline Shipments for 'TK101':
 
      
Tank     Product            Max             Net Product             Pipeline Receipts
                                                            
                                                            
TK101 #CRUDE            209,003.15            95,555                  3,045.00                  
                                                            
The 'PipelineReceipts' is a sum of transfers that feed into TK101.

This is the equation that I am using to get the “PipelineReceipts”:

Diagram 2: “PipelineReceipts” Formula in Crystal Reports:

 If {spRecShipInv;1.RecShipID} = "PipelineReceipts"
then
{spRecShipInv;1.MeasLiqVol}
Else 0

The equation produces the following:

Diagram 3: Results from Equation:

 Transfer-63786            RECOVERED SLOP OIL            0260            0.00            0.00                        2,601.00      
                                                                                                                                                                                    
Transfer-63787            RECOVERED SLOP OIL            0260            0.00            0.00                           444.00      

The two results from the transfers give me the total that I need.

Here is a copy of the relevant tables from the data source ‘spRecShipInv’

Diagram 4: spRecShipInv Table for ‘Transfers’:

      FlowID               FlowMeter      FlowType   RecShipID                 InService      MeasLiqVol      RecShipSrc           RecShipDest
Transfer-63786      Transfer-63786      R          PipelineReceipts      IS                 2601              PipelineReceipts      TK101
Transfer 63787      Transfer 63787      R          …
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
I want to copy some data in row or column in crystal report when viewing and pass it data to MS Excel and keep the right format as when view in crystal report like that:

Crystal report data (I selected login Time column data and press Ctrl + C to copy)
cx.PNG
and i want to paste that selected data into excel like that:
bbb.PNG
Is this possible?
Thanks in advance for help.
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
I created a dbf file and appended it with data from a CSV file. I thought I could simply create a dfb file with data in it without setting up an entire database and then create a connection to it in crystal reports to pull in the data. Is it not that simple?

The reason I did this is b/c my original data file that is csv format (or even if I convert it to xls or xlsx) treats one of my columns as a number field even though I format it to be a text field. The field contains bank insurance numbers like 12345, 22334, 52643, etc. I am trying to format it as text or string b/c in my report I am using my company database and trying to connect it to the csv file, but the Cert field in my database is a String field and the Cert field in the CSV (or xls,xlsx) file is always seen as a Number field, thus crystal reports won't let me join the two tables. This Cert field is the only field that I can use to join the two.

I thought by creating a dbf file I could change the field to be a string field and that would solve my problem. Any thoughts, is there a way around so that crystal reports will see the field in my csv or excel as a string field and not a number field?
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
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
Is there a way to suppress certain column grand totals of a crosstab. I know there is a function to suppress grand totals in the Cross-Tab Expert > customize style area, but that is for suppressing the entire column grand total section.

I also know that I can manual suppress each field in the grand total section, but the problem with that is that I still takes up the same vertical space in the grand total section...that section does not vertically collapse in size as you suppress each grand total.
0
Want Experts Exchange at your fingertips?
LVL 9
Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

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
Hello - is there a way to enable the auto-grow setting for larger text in cross tab?

I see that the autogrow of crosstab is disabled in the format editor of label
auto_grow_crosstab.png
auto_grow_crosstab.png
0
I have a column in a database that has "chunk text"...it apparently stores data in 2000 letter sequences. If the note is more than 2000 characters then it stores the remainder in another row which is associated back to the original row, naturally.

The problem I am having is that Crystal Reports XI only displays the first "chunk" of data in my output INSTEAD of the CONCATENATED output expected.

Here is my setup in the report.

I have an "Initialization  Formula " that I placed in the  "GROUP HEADER"  section of my report. See below,.
WhilePrintingRecords;
Global StringVar ConcatSecureMessage:= '';



I have an  "Accumulation Formula" that I placed in the "DETAILS" section of my report. See below.

WhilePrintingRecords;
Global StringVar ConcatSecureMessage;
 
ConcatSecureMessage := ConcatSecureMessage & (if

ToText(next({DOCDATA.SDID})) = ToText({DOCDATA.SDID})
     then {DOCDATA.DATA}
          else '');




Finally, I have  a "Display Formula" that I placed in the "GROUP FOOTER" section of my report. See below.

WhilePrintingRecords;
Global StringVar ConcatSecureMessage;

ConcatSecureMessage;
0
0
I ran into a issue with what I use as my standard connection to sql 2014 from Crystal Reports 16 Service Pack 4.  It seems that after a Microsoft update the other day the OLE DB (ADO) connection does not show anything related to the database.  ie tables, sp.  

I even tried to make a new OLE DB (ADO) connection.  It will connect to the db but again will not show any of the tables...ect.

I have attached a screenshot of the connection.
2017-06-28.png
0
I'm looking at merging cells in cross tab based on some condition.

I see that there are many articles to have the row formatted based on a condition,

Attached is an example to show the expected result.

Any help is appreciated.. thank's a ton in advance.
crosstab_mergecells.png
0
Free Tool: IP Lookup
LVL 9
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

how to run crystal reports in batch
0
In my crystal report i added water mark image on the main report and rest of rows are in second subreport. My question is how can i fix no of rows in second subreport ?Untitled.png
0
I'm running into the below error when using the OLE DB (ADO) SQL Server Native Client 10. Server is running SQL Server 2008 R2. We are able to make a connection using Microsoft OLE DB Provider for SQL Server fine however the reports are putting out unreadable data. Thanks in advance.
Crystal reports error
0
Good Morning All;
We are creating a report which will show a distinct count of cartons which have specific total units.    For example we have 5 unique cartons that have a total of 3 units, we have 10 unique cartons that have a total of 4 units and we have 6 unique cartons that have a total of 10 units.    On the report we currently have each carton number and a sum showing the total units within each carton.  We need to create a Grouping that would show something like this:
Week #43     Total Cartons  10             Each Carton Contains 5 Units
We cannot do a distinct count of cartons because there are various totals for each carton so we thought a distinct count of the Units within a carton or sum of the units in a carton would do what is needed but we cannot do a distinct count against the sum.   We attempted to convert the sum to a text and then do a distinct count of the text but the text field is no available to select for a distinct count.       Is there a way to do this distinct count?

Appreciate any assistance.

Rosemary
0
I have Crystal Reports 7 (mr2). Its circa 2000 but is functional and fast, and it is used to support another program that is circa mid-80s. I add this point because there really is not a modern alternative and I am stuck with the 80's program.

I eventually coerced Crystal to run on Windows 7(64), to get away from the Windows XP box it is running on. It appears to work but for one problem. When running a report as an AD domain user the report fails with: "PEStartPrintJob : Error detected by database DLL." But if I log off and back on as the local Administrator, the report completes successfully.

The other point I would mention but might be nothing is that the startup file: "Seagate Info Startup" which launches: Sentinel, APS, Agent, and Analysis Server also fails to launch those programs as an AD user. I can launch the program manually and then it runs. Again its different behaviour as local Admin. The file launches from the StartMenu startup folder without a manual nudge.

Been scratching my head for the last 12+ hours or so. I doubt anyone out there is still using this antique but on the off-chance someone is, what's the trick? why doesn't CR7 like domain users?
0
I created a crystal report based on a command.  To speed up the query I have a date parameter in the command Parameter request 1.  This is OK, however I am prompted again for the same date parameters again once report is launched Parameter request 2.

Is there any way I can stop the report requesting the exact same parameters twice?

Thanks

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