I need to know the best way to do this. I have a crystal parameter which needs to be a string. If the user enters a date it will be entered as YYMMDD. In the record select section I need to c...
PLease help. I am using Visual Basic 6 to connect and run a crystal report. I was able to use this exact method at my last job with Crystal 9, and VB6. Still connecting to an ODBC datasource f...
Hi
I'm playing with a trial version of Crystal Reports 2008 & I need to pass multi-value parameters to a stored procedure. I've created a command object & added the exec statement. I also c...
I have a problem installing the Crystal Reports Print Control on clients where the user is not an administrator. When the user navigates to a web page with an imbedded crystal report and clic...
In my CR formula, how do I specify AM/PM when using ToText(<datetime field>, "MM-dd-yyyy hh:mm:ss")?
How to change datasource for a crystal report between databases also pass login and password
I have a series of reports I am working with a client in CA. We migrated these reports from CR10 - CR2008 I noticed that when I started to migrate the reports on consisten problem came up. It ...
I am getting an error while executing following formula, (Bad date format string)
local datevar input_date := {Table1.Mydate}
local numbervar input_day := day(input_date);
if input_day ...
I am using Crystal Reports XI and Visual Studio 2005 to deploy Crystal Reports as (.aspx) web pages. For printing the reports, I am using the ActiveX print control provided by Crystal. The sol...
I have a Windows Form VB.NET application using Crystal XI R2 to produce reports. The application works flawlessly on other machines in Windows XP, but as soon as I try to load a report in Vis...
Hey, I'm struggling through incorporating a crystal report into my ASP.NET web page. My method is to create a DAO connection to my MDB file in my .rpt, and then on my report form with the CR ...
I'm getting sdtopped cold by this error, and have checked Google and found many othher suffered the same fate.
Source of error: CrystalDecisions.CrystalReports.Engine
I checked the permi...
Hello experts,
I have a subreport that is set to suppress if blank. The subreport is in section 1ca, which is also set to suppress if blank. Even when the subreport is blank, though, sect...
Hi,
I am trying to calculate the % increase / decrease between profit figures from previous to current year. Currently my formula is as follows:
If Sum ({@Current}) <> 0 and Sum ({@Previ...
Hello! I am trying to create a summary on a formula field (@Amt_Reversed) where a "minimum" function is involved. However, when I add the condition "and {balance_date} = {@Date_Min}" to the ...
How do I convert a date from a String to a Date format? If I export my report to Excel and try to create a pivot table, Excel reads my string field as General. It won't allow conversion to a...
My Crystal report has a field TimeCreated which happens to be the time an order is created, for example, 18.93963 which is apx 6:58 pm. How can I create a formula to convert the decimal milit...
We have a bunch of clients that use terminal services to connect to some servers that have Crystal Reports. We have about 40 System DSN's on each server. When the users open a report, hit refr...
I have a reports that pulls a date field from a SQL database that comes across as 05/05/08 and on the report the field needs to dispaly the month that is before that date. So for example if t...
Hi, I'm making a crystal report and I have two data fields, "Plan Number" which is something like "001-223" and "Plan Revision" which is something like 1 or 2. I'd like to create a single tex...
I have a report that has 3 subreports. I added a 4th subreport, but I can't get it to display the data properly. All 4 subreports are located in a Group Header in the main report. The Group...
Using the "Select Expert" option in crystal reports to filter records, how can i do this to filter by keywords or any characters? I see there is an option to select the "is like" condition but...
I have created a subreport that has running totals, this has been inserted in my main report in the group header, I am using a shared variable on the main report from the subreport, this varia...
We have an older application developed in VB 6 with Crystal Report 9.1.33.
Users now want us to:
1. provide a Print Preview Option
2. Provide an option so they can export the report to Micr...
I use Crystal Reports 8.5 for developing a legacy application ((with VB6), but now want to install the Crystal Reports Professional 2008 version to use with VB.NET in Visual Studio 2008.
Wi...
