I'm writing a small app in vb.net 2008 Pro that executes a crystal report that was created in Crystal XI. This report has several subreports all of which use the same stored procedure that is ...
What does the following Crystal Reports settings mean?
1. Page Setup -> Use Default Margins
(What are the default margin values?
2. Page Setup -> Adjust Automatically
How it will affec...
Hello,
I have a formula field converting my date of birth field (string) from yyyymmdd into mm/dd/yyyy. I am now trying to calculate the person's age based on that string value, but am ha...
I have been trying for 2 days now to move a report from my development machine to our webserver. But it simply won't work. I've gotten these to work before but they were always dealing with ...
I have a Crystal report that I have created to export data that we can send to our imaging company and I am having trouble getting it to work correctly. When i run the report it looks just li...
Hi,
I have around 47 columns appearing on a cross tab report in Crystal report 2008. When i try to export to excel it shows only upto 30 columns and remaining are ignored as the end of the ...
I have a Crystal Report 2008 report that I can't seem to figure out the right way to work up a breakdown view. The data inthe report will be a list of people that I want to show how many hours...
I am to use a field on my report which is defined in the database as NUMBER. I need to do the following to the field before displaying on report:
(1) Limit the field to only 2 decimals
(2) ...
I asked this question before and assigned points but I still need an example of how to add that formula to each cell.
Dear all,
I think that everything is said in the title:
I'm new to Crystal Report 2008 and I have to make some tests in order to see if some functionnalities found in Cognos are possible t...
Good day
I've been browsing for at least a week to find a solution at my problem.
I have a Crystal Report into a Window Application coded in c#. This report is directly connected to a SQL ...
each time i try to use a parameter in my report, i get the error crw32.exe has encountered a problem and needs to close. We are sorry for the inconvenience. this is only happenning with one ...
Hi.
I've got a report which has a group footer.
The footer sometimes appears by itself on a page. The previous page is full and so the footer (just some totals) appears on the following ...
I have a function writen in SQL that returns the first day of a given week as follows
( @pInputDate DATETIME )
RETURNS datetime
Begin
Declare @result datetime
if datepart(dw,@pInputDat...
I have an existing reports and every thing works fine.
Now, for the header I have created a sub-report and this sub-report is tied to a stored procedure.
I am passing the PolicyId to the...
Hello Experts,
I am writing a Crystal Report (in CRXI) that will explode the Bill of Materials for each part number entered by the user. Additionally, the user wants to be able to prioriti...
I have used the Count ({Db.NAME} ) to get the number of records that were returned as a result of the selection formula filter. I would like to also show the total number of records that came...
I need to display the first 10 records coming from my source in a horizontal fashion, rather than vertical.
This seem far more tricky than it should be - in the very, very worst case, could...
I have a simple report created in CR XI with a date parameter. When I run the report and get prompted for the parameter, the date picker does not work and there is an Internet Explorer script...
We have a multi-page invoice style report which needs a "terms and conditions" page on the back of each invoice page. I've tried a lot of things, like alternating headers depending on mod of p...
I have a report with multiple input static parameter. I want to search the data based on the multiple static input values. The parameter values may not be an exact match which is why i am tryi...
I have Crystal report that uses cross-tab. It runs fine when I preview it within Crystal reports, but when I view it with web viewer I get error:
Exception in formula '{@displayString}' at '9...
Hello, I recently migrated an Access based ERP system to a Flex front end with PHP and Mysql. I am using Crystal Reports to recreate the reports I had in Access, but am stumped as to how to co...
Hello,
I am trying to get a dynamic parameter to work for my reports. Here are my steps, along with what I am seeing.
1. Create new Parameter
2. Choose 'Type' = String
3. Choose 'List...
I have built a report viewer in C# using Visual Studio 2008. I am trying to deploy the application on a test machine and I get the Load Report Failed error. I have installed the crystal 2008...
