Crystal report
In Crystal report how we suppress page header on pagenumber >= 2 when records are completed on the previous page ...
crystal-reports
Add an image with transparency to Crystal Reports
Is it really true that Crystal Reports does not support images that have transparency? We are using it at work and the guy that does Crystal Reports told me it doesn't support transparency. I couldn't believe it so I've spent the last 20 minutes googling and think he might be right. This seems absolutely incredible in this day and age....
Crystal Report fails to load on Windows 2003 os
Crystal Report 10 fails to load on Windows 2003 OS. We're developing with .net 3.5 with C#.net. It works properly on dev box which contains similar configuration but without a McAFEE Anti-virus software on it. Any pointers would be greatly appreciated. Error Message: [COMException (0x800002ad): Error in File UNKNOWN.RPT: The request ...
Pass parameters to a stored procedure in a Crystal Report sub report?
I have a Crystal Report, that is populated with a stored procedure, it also contains a sub report, that I am trying to populate with another stored procedure ... same parameters. I cannot figure out how to pass the parameter value to the sub report. Any help would be appreciated! ...
Sorting a Crystal Reports 2008 Cross-tab in two directions
I have a table that shows a list of doctors, facilities, and charges. I set up a Cross-tab Report in Crystal Reports 2008, putting the doctors on the rows, the facilities on the columns, and the sum of the charges (and a couple of related numbers) as the summary fields. When I did this same report in Excel, I had no trouble sorting by s...
Crystal Reports doesn't show any data
So I'm using this SQL Server with my application and I decided to display crystal reports to the user. I'm not at all experienced with crystal reports, but this project gives me a good opportunity to learn. Now, my data sources are already setup and i've been using them with for the past several months with this project. However, when I...
Crystal Reports Summing
So I two groups tblTenant.ID tblTransaction.TenantID In tblTransactions there are two fields I want to manipulate, AmountCharged and AmountPaid. How can I sum both fields and subtract them per group? I.E., each Tenant will have all their amountCharged's summed and then have their AmountPaid's summed and subtracted. For example, the SQL...
Need a good version control for SQL and Crystal Reports
We have several large data stores where we warehouse data for metric reporting. One is SQL 2000 and the other is 2005. We use Crystal Reports 11 as our reporting tool. Over the past several weeks we've had a couple very visible reports "crash" due to changes in the Db or changes within the reports. To minimalize these errors I am look...
Grouping and crystal reports
I have a crystal report that is like this: Group By Property.ID Group By RentalUnit.PropertyID Group By Tenant.PropertyID That way it comes out looking something like this: Property1 unit1 data, tenant data unit2 data, tenant data ... unitN data, tenant data Property2 unit1 data, tenant data unit2 data, tenant data ...
Crystal Reports query help if-then-else
Basically I have a field in my table called sex, and it's a boolean. true for male, false for female. How can I display it this way instead of as 0, 1? ...
Crystal Reports if-then-else selection based on parameter
I have this crystal report, and I want to be able to use it to display every person in the table or display only those who owe money. The parameter is called displayAll and is a boolean. Basically I want this if displayAll Then Show every person else Show only When Balance is below 0 How can I do this? ...
How to Display the same passed variables on the crystal report using C#
Hello good people. I'm really sure that the title of my question depicts what i mean.i guess that's why i can't find that much on google.I think it needs to be explained. Basically i've manage to pass programmatically discrete values to my report successfully. Now i wanted to make use of the A4 paper format to have 2 A3 format.that means...
Crystal Reports Date functions
I'm trying to select only the records in which their date falls from the current date to the end of the month three months from now. Currently there are two dates in the table that match the query: Judy: 5/17/09 asdf: 8/9/09 This is my formula: DateVar current = Date(DurrentDateTime); //takes the time off DateVar ThreeMonthsAway = Dat...
Changing Crystal Setting: "Overridden Qualified Table Name" in code
I have no issues setting pretty much any connection value in a report except for this one. I am using XI R2 and I have tried CRAXDDRT as well as the .Net SDK. Has anyone had luck doing this? BTW, the reason I want to do this is because I want the report to target the database specified in the system DSN instead of the the 'catalog' val...
Crystal Reports text cuts off last line in Details section
I have a Crystal Report 11 file that is a letter. The first Details section contains a large text box that has print date, address block, and the salutation line. Every once in a while, the last line of the text box gets cut off so that the salutation isn't seen. It's very inconsistent in that sometimes, I run the report for one person i...
Number to String in a formula field
Hello, I am using a formula field to concatonate 2 decimal values separated by a dash. However, I want the result to trim all unneccesary trailing zeros and decimal points for both values. For example, I want values 10 and 8.5 to be "10 - 8.5". Now it shows "10.00 - 8.50". The formula I am using is CSTR({field1}) + " - " + CSTR({field2...
Crystal Report in ASP.NET - display image
I am using a Crystal Report on my website to dynamically build a PDF file for download. This is working great. However, now I want to add an image to the report. When I go to Insert - Picture, browse to my image file, and click OK nothing happens, which leads me to believe that I'm adding it incorrectly. How can I do this? Also, doe...
How can I change this sql statement into something Crystal Reports
I have three tables in my Crystal Reports and it looks like this: Property ID Other Data Unit ID PropertyID <-- fk to Property Other Data Tenant ID UnitID <-- fk to Unit Other Data The report is going to show only Unit's (grouped by the property they belong to) that do not have any tenant's linked to it. Some nice peop...
How can you add a bread crumb in a Crystal Xcelsius Report?
How can I add a bread crumb in a Crystal Xcelsius Report? I need to track the navigation of my clicks on my charts. ...
Crystal Report
How i can fix the crystak report to update directly from the datasource.... i'm using dataset to the rpt when i install the report in onother pc in the runtime when loading teh report it shows username and password on the i solved manually in the pc by openning the report and make verfiy from the dataset....????!!!any ideas... ...