Stack Overflow
Stack Overflow

Questions tagged [crystal-reports-2013]

48 questions
4
votes
2 answers

Display em-dash in report

I want a simple formula which concatenates two values together separated by an em-dash. The formula would read something like the following: {?PeriodFrom} & #em-dash-character# & {?PeriodTo} Obviously, I just want the em-dash character to appear…
cartbeforehorse
  • 3,045
  • 1
  • 34
  • 49
1
vote
0 answers

Crystal Reports database connection not working

Recently a report that's existed for a while stopped working and it gave the error message: The viewer could not process the event. The database logon information for this for this report is either incomplete or incorrect. [] ---- Error code:0…
Andrew Robie
  • 303
  • 3
  • 14
1
vote
2 answers

If there is a record under a key with a value, do not select that key

I am trying to find a way in CR2013 to only select records if every record under a key does not have a value. I don't see a way to use the SQL: NOT EXIST in CR. I've tried to create group selections, which seem to be the best way to go with this, to…
Garrett C.
  • 23
  • 2
1
vote
1 answer

Pass value in Crystal report

I add formula field region,fromdate,todate in report i.e. UPDATED IMAGE Also I try this another method: protected void Report_Click(object sender, EventArgs e) { data crystalReport = new data(); …
user6628729
  • 323
  • 1
  • 7
  • 25
1
vote
1 answer

Decimal places on dates, Crystal Reports

Good morning, I'm currently working on a custom date for a label. It needs to read the last 2 numbers of the current year, followed by the number of day it is within the current year (8/3/2016 would be day 216). So if I were to print a label, the…
PCGKyle
  • 11
  • 1
1
vote
1 answer

Filtering grouped records in crystal reports

I have an issue that I'm not sure how to overcome. I need to filter a my groups in crystal reports based on a field within the group. Not only that I need it to filter the groups based on if there are two different values in this field within the…
ZzappMaster44
  • 13
  • 2
1
vote
0 answers

RTF data in Crystal Report 13 with Data field

I have problem to display RTF data in crystal report.My RTF data showing with formatting but data fields value not showing. My RTF Data Below: {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl…
Amit Saha
  • 11
  • 2
0
votes
2 answers

Crystal report Parameter Fetching Data from DB

How can I add a parameter to fetch customer names from a database in Crystal Reports 2013? Is it possible to write a query in a formula to retrieve the data? I have already used dynamic parameters, but they don't allow for searching. I also need to…
Ahmad Sherwani
  • 1
0
votes
1 answer

Exporting a Crystal Report to PDF using VB, ReportDocument.Export() getting hung

I have inherited a process that is meant to produce reports through Crystal and then send them out. I am trying to add a report to be automatically sent out through this process but it seems to be getting stuck on the Export() call. There is a lot…
Scribbles93
  • 11
  • 2
0
votes
1 answer

Crystal Reports:IF/THEN/ELSE with null values and multiple conditions

I am new to crystal reports and am writing a formula for crystal so I can get a check for when certain trainings are due and every training has a different due date. For example if someone was hired 9/1/2022, they would have 15 days for report…
pihard314
  • 1
  • 1
0
votes
1 answer

Draw an image in Crystal Reports from a binary string

folk, I'm trying to develop something for our Crystal Reports that generates an EAN barcode image from the numeric string. I've already developed a function in our SQL database to encode the numeric string as the ones and zeroes that represent the…
Cory
  • 1
0
votes
1 answer

Crystal Reports 2013 OLE size in function

how to get the width and height from a image and set those as measurements of a ole element inside a function? The problem is, if I use a image inside a ole element, the image wil be cropped to 5x5cm instead of leaving it as it is 2x5cm. In a other…
Qhiliqq
  • 79
  • 7
0
votes
0 answers

Crystal Reports, Same report for every day in period

I have a report that can pull the number of reservations on a day. I have a report that I was able to create to give an average of the number of reservations per day for a given period. Is there a way that I can create a master report and put the…
James Vooris
  • 23
  • 4
0
votes
0 answers

Crystal Reports 'if-statement' assistance

I'm currently using Crystal Reports 2013 to run reports. I'm having an issue with a formula that needs to look at an SAP order status and only print out a specific few. The SAP Order Status field is made up of 2 sections. Section 1: 'A' 'B' 'C' 'D'…
Jaime Sanchez
  • 3
  • 3
0
votes
1 answer

How do I use the Detail Section when I have multiple Tables

I recently had to take over creating reports using CR 2013, but the introduction I got was kinda lackluster, so from time to time I run into some Problems. Recently I had to use the detail section for the first time since I was somehow able to…
RhoGu
  • 11
  • 3
1
2 3 4