I am getting an error when I attempt to run a crystal report with a test data source.
It says:
Failed to open a rowset.
Details: 42S02
MS SQL Server....Invalid Object Name Production_db.re...
Crystal Reports Server 2008 (aka Crystal Enterprise XI 3.0)
I am attempting to set up destinations for File System. So far, in order for a report to successfully save to the shared drive, I...
i have sql server database view. i run the select command with a particular sort order (ORDER BY). But when i attach this view to a crystal report, report doesnot sort the records as defined ...
How do I create a trimmed average summary value in Crystal? I want to eliminate the top and bottom 5% of my data set and average the remaining values. This should remove the outliers to prov...
I have a string value from a field in a database. The format is always the same and I need to pull out the last few characters, trim out some special characters (if any) and change it to a nu...
Hi,
What I'm trying to do is to add some SQL that I already have working in AquaData into the Crystal Report file which I will then use in Business Objects, but I'm writing directly off the...
Any idea on how to convert an XML to viewable data in a report? I tried the coverter but it does not show the fields??
This is what I am trying to convert:
<?xml version="1.0" encodin...
crystal reports is the reporting tool within an emr.
some of our reports run very slowly - others quickly.
need some optimization tips for crystal reports when dealing with mutliple tables,
...
I have a report that in the main report is pulling in data from two tables and is limiting it by data on a third table. All 3 tables are linked in some way. I then have a sub report that is...
Hello,
I have a Crystal Report that contains a line chart. It works good but I want to be able to dynamically change the Data, for example I want to chage the option "On Change of" that at th...
I have created a report that is used in a vb.net application. In that report there is a group by clientname. When the report loads but there is only one match in the database the report loads ...
Hi Experts,
I have an issue with my formula not working correctly at the group level. The equation is propery set up, however the variablesseem to be the same at every the group level (see pi...
is there a way to break crystal reports after the group footer into multiple files?
I suspect there is an addon to do this. The ulitmate goal to print to individual PDF files based on the Gr...
How can I use the ToText function to convert the 20091201 to text? When I use ToText it produces 20,091,201.00
Ultimately I wan to use right ([MyFieldName}, 2)&"?"& mid ([MyFieldName},4,...
Hi,
I am using crystal report 11.
I am very new to reporting, I have a question on parameter fields.
I created a parameter field called "Option1", the values are: a,b,c,all. (Crystal repo...
Hello Experts,
I need to convert/format a running total date value that is formatted as 1/13/2010 12:23:22PM to a 2010-1-19 00:00:00 format. The user needs to be able to copy and paste th...
Hello,
I have a column called med_number that is datatype string, length 12. There are of course various numbers that are generally 8 characters in length stored in the table, but all have...
As a related question shows there are two fields which could be hidden or not, I need to sumarize them in separated results and show them in footer report.
Regards.
Hi Experts,
I was wondering how to make this SQL statement work with multiple values in Crystal Reports 2008.
WHERE "MasterCostCodeList"."Level1" =' {?Contract}'
It is formated as a ...
I have a formula that returns items based on a several formulas, I would like to separate the Text with commas but return no commas if there is no data returned.
{@1_LEAD}&" "&
{@2_UNL}&...
I have a report in which I need to change a specific currency field from $25.63 to $25.625. However, I don't know how to do this in the formula editor. When I use the following:
if {CnGf_...
I have two numeric fields that I am using. One field has a decimal value which I would like to drop and the other has a single digit value that specifies the month. The single digit value I ...
Background:
---------------
We have Crystal Reports 10.0 running in Production. Apparently we dont have Crystal 10 Software to work on the changes for the reports. We do have the license f...
Have a Licensed Crystal Reports 10.0 installed on my PC. But dont have the install disks to instal on other PCs for development. Is there a way out ? Shoudl I contact Business Objects ? All I...
I want a {?Top} parameter for the end user to enter a Number of records to report on. eg top 20
The {?Top} Parameter is needed in the DETAILS section
The {?top} question would be;
Top h...
