I am using Crystal reports inside VS 2005 and had questions about a report I am trying to create.
I have pasted some sample data below under "--------Data-----------" and have pasted how I wa...
I have a form with a ReportViewer and fields to filter the report.
The report contains one parameter "idclient".
Code use to load the report:
--
c_rapport.SetParameterValue("idclient", (...
I have created a formula that changes the string date to an actual date using CDATE({Assc99.D_Appt}-18261) this field is now called DATE OF APPT. Now I need to change this date to be three...
I have Crystal XI installed on my client machine and I'm running VB.Net on my client XP machine. When clicking on the Export button on the Viewer object, I would like to remove some of the fi...
Hi,
I have 2 tables I need to join them to build a report. But there is no direct relation between the tables. I will have to join substring of a column from 1st table to a column in 2nd tabl...
How do I make the numbers in a STACKED bar chart contain the number for each part of the stacked bar in stead of the aggregated number.
I want the number of each part of the stack to be prin...
How can I pass a parameter to my sql query?
In the Command Box I have :
Select Sum(payAmount) as lastPayed, CustomerID From Payment_table Where DateDiff("d", payDate, Now()) <=30 Group By ...
I have an Access database, db1, with a table in it called table1.
This table has two fields... ID and theName.
I have VB6 and Crystal Reports XI Developer version.
I'd like to create a prog...
I have a parameter set up as a string. The user can select different date ranges such as CurrentWeek, LastMonth etc. In my record select logic I check what was selected on the parameter. If i...
I currently have more than 300 crystal reports that need to migrated. The issue is that all of it was written using crystal syntax instead of vb. Is there any tool that will make the conversio...
when i debug the below code i am getting the "LOGON failed error" in vs 2003!!!!
whats the problem here...??? Urgent..
Thanks.
Just updated a report to v12 that was written in v9. I had imported the "static" list of customers to v9, and now want to take advantage of "dynamic" parameter to get automatic updates from d...
I have a text string field I am exporting into excel that needs to be seperated into rows or columns. Which ever I can do. Columns would be preferable.
Normally I would use the text to column...
I using following formula to count proposals due within 60 days but I am getting value 1 for all rows.
datevar ddd1:=cdate({Command.DueDate});
datevar ddd2:=cdate({Command.InitiateDate});
...
Hi, I am struggling with formula to pass information from sub report to main report's footer section
In my main report I display all regions and world total and in the sub report all leading ...
THE EXACT MESSAGE RECEIVED when trying to run Crystal Report from website.
The Visual Basic UFL that implements this function is missing (or U2lcom.dll is missing). Error in File C:\Crystal...
I'm creating a report using data from a dbase that allows attachments. So, in CR, John Smith's "Notes" may be "Met with John to discuss..... " or it may be "{00000skdjfli...} - basically junk...
I have developed a simple report with Crystal Developer, pulling data from a stored procedure with three parameters. The report runs fine on the development machine. But after deploying to the...
Hello,
I'm using the latest version of Crystal Reports 2008 (Service pack 0). I'm creating the web application with Visual Studio 2005 (C#).
I need to print Crystal reports to Postscript...
I need to create a grouping for a range / variable. Basically i have projection which can vary from 0 - 1000 ( positive interger) . I need to a crosstab to calculate number of projection by m...
Hi Experts,
I have a chart which accepts the start date and end date as input parameters and plots the sales for each day between these 2 dates. When users enter a very wide reporting peri...
Using Crystal Reports 2008 or XI I can't find a way to ignore/hide/suppress 0 values in a line chart..
Help!
I need to find a way to edit a currency field with a formula to remove "," and decimal points. For example, 12,866.90 would need to be 1286690. I cannot simply do this with the "format field...
Hi Experts,
Using the table below, is it possible to create two separate formulas using the condition below:
1) minus the Net Value with CV, then divide the result with Quantity where SU...
how can I change the date and time format during runtime in crystal using Crystal API? eg: 01/10/2008 in US and 10/01/2008 in UK. Is there a way with the local OS date time settings we can set...
