Stack Overflow
Stack Overflow

Questions tagged [crystal-reports-2016]

38 questions
3
votes
2 answers

NullPointerException when running Crystal reports with SP24 for Eclipse

We are trying to upgrade to SP24 of Crystal Report for Eclipse but have found that several of our reports are failing with a NullPointerException when generating the report. I've included the stack trace below - does anyone have any idea what may be…
Chaitra
  • 31
  • 4
1
vote
2 answers

How do you "globally" tune a SQL query so it's driven by records in a view if the view name keeps changing but query structure stays the same?

I have a Crystal report running through an application that takes a long time to run due to an inefficient query that takes 15 minutes. We are running Oracle 19.4. CURSOR_SHARING = FORCE for the database and this is required per the vendor. See…
Doug Weigle
  • 21
  • 2
1
vote
0 answers

Backend export Crystal Reports to PDF

I'm newbie to Crystal Reports and would like to know, which way to go. My challenge: A web-service consumer asks for a PDF on a specific report (name of RPT-file). The called web-service shall generate report output as PDF and send it to the…
Carsten
  • 11
  • 1
1
vote
1 answer

Suppress a text object if embedded summary field has a certain value in Crystal Reports

How do you suppress a text object in Crystal if a summarize field inside the text object is equal to 0? Example of text object content: I want the text object to only display when {Sum of RETOUR_INVOICE_LINE.AMOUNT_EUR} is zero. It seems I can't…
svdotbe
  • 168
  • 1
  • 3
  • 16
1
vote
1 answer

Crystal Reports -- combine multiple rows into one row

Example: RecordID ............ MemberName ........... SportID ......... Sport 1 .................. James ................. 1 ...............Hockey 1 .................. James ................. 2 ...............Football 2 .................. Jose…
Trevor
  • 51
  • 9
1
vote
1 answer

Filter by field in Crystal Reports without selecting it (distinct)

I have a report in which I would like to filter the data based on one field, let's call it status. I have activated distinct values, as the select statement returns duplicate records. My problem is that the generated select statement now includes…
guerda
  • 23,388
  • 27
  • 97
  • 146
0
votes
2 answers

Crystal Reports: Dynamically accessing Database Fields

I'm working with Crystal Reports 2016 (Version 14.2.7) and I need to dynamically access database fields with generated names. My current formula looks like this: Local NumberVar i; Local StringVar fieldName; stringvar array tmp_arr := []; For i :=…
klediooo
  • 630
  • 1
  • 7
  • 25
0
votes
1 answer

Crystal reports-How to force the group footer to pull the correct field based on another field in the same table?

I am using 2016 Crystal Reports pulling data from 2021 Sage 100 database. My corporate IT moved us from our Sage environment to their consolidated Sage environment for multiple companies they own. This eliminated our old work order module and we are…
ConfusedByTrying
  • 1
0
votes
0 answers

Crystal Reports 2016 list of months

I want a list of months between a start date and end date from the database. For example the start date is 01.01.2020 and the end date is 31.12.2023. Can I use a while clause to get the months like this: 02.20 03.20 04.20 ... 11.23? I need a…
yellowtek
  • 1
0
votes
1 answer

How to update the Table Name in Crystal Reports SQL Expression Fields?

I am using an existing Crystal Report in an ERP system, which works fine within their application. Which means, I don't want to change the report definition because somehow the application is able to get past this issue. I have written a .NET…
Krisjl
  • 1
  • 4
0
votes
1 answer

Multi-line Fields in Crystal Reports

I am working on a report in Crystal Reports 2016. The table used by the report, USER_ADDR, stores the addresses in its ADDRESS column, storing additional information about the address (ex: apartment #) in a second line. USER_ADDR…
Kelly
  • 1
  • 1
0
votes
0 answers

How to delete the duplicate detail section in SAP Crystal Report?

Not able to remove the duplicate detail section. Tried everything from section expert as well. Also, tried using suppress down. But no luck. Tried using Format Field to use the option of 'Suppress down if duplicated' which didn't work. Due to this,…
Vaishnav Baswe
  • 1
0
votes
1 answer

Crystal Reports 2016 - How to display multiple tables?

I am actually stuck with a multiple tables problem. I want to display 2 tables in my report. I saw how to do it with C# but I am not using C#, only Crystal Reports. So I have to manage to do it inside Crystal Reports. Is there any way to do it other…
JennE
  • 3
  • 2
0
votes
2 answers

Average from a Groupresult in Crystal Reports

Is there anybody who can help me out with a Crystal Reports question? I did a groupresult as average. The Option Average from the groupresults shows me per example 4.3, 5.4, 6.3. The question is, if there are some options to round these results from…
Zan
  • 1
  • 1
0
votes
1 answer

Error when trying to use stored procedure in crystal reports

The error: Database Connector Error: '22018:[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the nvarchar value '%' to data type int. [Database Vendor Code: 245]' The stored procedure contains one parameter that…
Terry S
  • 23
  • 1
  • 6
1
2 3