Could someone clarify for me what effect "suppression" does in sections, subreports, and formulas?
I thought I had a pretty good understanding, then I saw that suppression of sections not ...
SAP table ODLN has address field which contains address, city zip, country. There appears to be at leat one ascii character between address and city and one ascii cahracter between zip and cou...
How do I force the template to created multiple prints of the same address record when using the Label Template wizard. I see alot of users needing to create multiple labels based on quantitie...
I have a database VIEW that has account numbers within social security numbers.
I 'm reading from the view and I'm grouping the report by account number within social security number.
I want...
Hi friends,
Please help me with this issue. I have made a demo project in vb.net2005 and it consists of 1 form and 2 crystal report (the version of crystal report is the same that comes by ...
I've created a report that uses two data sources, an XML file and connection to a SQL server (using a connection string). I'd like to add a SQL Expression formula to the report but SQL Express...
Hi,
I have a report that details an operators activities for a particular week number.
Report has three areas:
Job Bookings - Main report
Non Production - Subreport
Time and attendance ...
I have a report in CRXI with several groups, I need to count the number of groups, as they are inside another group I need to reset the counter, every change of the first group.
i.e.
G...
new xp systsem
control panel identifies that .net 1.1 has been installed with sp1
when i run my installation package which requires Crystal reports 11.5 I receive the error message
"Error W...
I've tried this many different ways, but I cannot seem to figure out what I am doing wrong... to make the concept as simple as possible, I have two tables. One product_master, and one with P...
Here is my data:
Part Weight Trans.
Part1 100 23
Part1 100 86
Part1 200 27
Part1 200 37
I am grouping on Part and I want to summarize the unique values in th...
Hi,
I have a report that is generated using a view. I tend to create my reports from a view rather than doing all the table joins in SQL as I am more familiar with SQL than Crystal. What I ...
My report is laid out like this:
Qty Safety Stock
Group 1: Part ID X (Form...
Hello, please bare with me, I'm pretty new to this.
I have an existing report created by someone else who is no longer available. He had a really neat subreport that concatenates number of s...
Hi Experts,
I'm looking for a truncate formula in CR to shorted a lengthy customer name and show only small part of it:
For instance, the following customer names have long text name:
...
I am trying to highlight date fields with null values but the the formula keeps returning nothing.
If
IsNull({Plan_Manager.Milestone01_Actual_Comp_Dt})
Then
crRed
It works if I ...
Hello experts:
I've spent a week trying to figure this problem but I'm giving up.
I develop Crystal reports using Crystal Reports Version 10.0.0.533.
The client does not have Crystal inst...
hi,
Im using Crystal 11 in Visual Studio 2005.
I have a cost field, number. How can I total that field for each page?
Currently when I use running totals, it sums up previous pages. I...
Hi,
My client has the following situation:
- an existing software system build with Delphi 5 for the Windows platform.
- this system has several Crystal Reports (version 7) that connect...
I have 10 graphs in a report, i want to add following features to it:
1) i want to have only 1 legend for 12 graphs at the top.
2) i have a custom line at 2, i need to write '2' next to that...
I'm trying to find a way to allow users to only view Crystal Reports... My goal is to void them having all of the options that comes with the standard Crystal Reports app for it will confuse ...
We've developed a c#Winforms application that uses CrystalReports. The application stores all of its displayed strings in an Oracle 10 db (as nvarchar), thereby allowing us to switch displaye...
I created a report with the following fields:
Type_Code Total_Cables Total_Pulled Total_Est. Actual Pulled
I want to only show one row for each type code and then sum the totals o...
I want to take my field: {Claims_txt.DoctorsPIN}
Which produces a 15 character number (For Example) '036103248 2' and only report back the 15th character only. This 15th character in th...
I have created report from a stored procedure written by a third party that I cannot change, edit, etc. I do not know how to create stored procedures, I can only work with the existing stored...
