I have a field in crystal report with the following data: '605 KL1 - Daniel Steve' How can i just remove the '605 KL1 - ' and leave the 'Daniel Steve' in the field only? Characters before '-' could be different, i hope the formula would automatically search for the '- ' and then show everything after it. ...
I have a multi column report in crystal report.Is there any way to start each new group in new column in Crystal report in the same page? ...
HI, Is it possible to display summary of a group at the report footer ? Let me explain the scenario. I've to create the following kind of report: Client Amount Currency Customer 123: WWWW 300 SGD XXXX 400 SGD YYYY 200 USD ZZZZ 300 USD Customer 456: W1W1 300 ...
Hi , i want to know is it possible to bind my all crystal reports to a single reportviewer, somewhat in tabbed view or treevie. If tabbed then visible through navigation button. If yes then how? any help would be highly appreciated. Amit Ranjan ...
Hello Everyone! I work with Crystal Report 2008 sp2, and during creation of a new report template I've encountered a problem. I created a stored procedure, which prepares and pivots needed data on the server side, and filters it using a parameter. When I try to add this stored procedure to the report template in Crystal Editor, I recei...
Recently I updated a Crystal Report that was doing all of its work on the client-side (Selects, formulas, etc) and changed all of the logic to be done on the server-side through Stored Procedures using an Oracle 11g database. Now the report is only being used to display the output of the stored procedures and nothing else. Everything I h...
Hi I have crystal reports XI which have fields which are displayed in Arabic. The viewer works fine and displays all the fields in Arabic, however when i export it to PDF it becomes junk. I am not sure what to update or change. Has anyone solved this issue. Help needed Regards Hussain Mansoor ...
I have a report developed with Crystal '08 and it is published on CMC. My problem is when I changed the database to the production db, the report still asking for the development database password. I've tried to publish the report with a diferent name, but it didn't work. Thanks for your help! ...
Hello All! I have a query with grouping on one of the fields in Crystal Reports. My question is - is there a way to pass that value into a subreport? I.e. if there are three values in that field, there will be three groups in report. I want a subreport in every group to have that value as its parameter. Is that possible to accomplish ...
Crystal reports isn't working on different servers because they use different connection strings and crystal reports can't use the connection string stored on the web.config to access the database. Is there an alternative to crystal reports that can use the connection string on the web.config file? or does someone know how to fix the p...
I want to create a crystal report that will match a pdf file. the info in the pdf file is a combination of form fields and instructions layed out in a table format. The crystal report should exactly match the pdf file coz i will export the report to pdf later. is there a smart way of quickly designing the rpt file? like converting the p...
I'm using Crystal Reports Basic from Visual Studio. Now I want to create a 3D-Block Diagram but the series axis has the text from my columns of the dataset. Here is how my chart preview looks like and here is how it is configured in the diagram assistant All the texts on the series axis should be formatted like Monday, Tuesday, et...
I have a .NET Windows application with a CrystalReportViewer on form. I load various reports into the viewer that were created in Crystal Reports 2008. When the user is previewing a report (an invoice), as they move their mouse around over the report each field on the report is highlighted by a thin red rounded corner box as around the N...
Hi all, I am using Visual Studio 2008 and CR XI R2 for a web application built in silverlight. currently I am having a problem with showing a dynamic image on a crystal report. I was told that the reference file added in the project might be old version, so I replaced the reference files to be 11.5x version from 10.5x version. I r...
I have a report, in which I calculate starting date via Formula Fields. Then I need to pass calculated value into a sub-report, where I can use it as one of the parameters for the stored procedure in my database. The problem is that for some reason the value of the corresponding parameter when the database is queried is empty (or null, ...
Using Crystal Report XI. When I save the report, the default printer which is installed on my machine is being set as the default printer of the report, so that the deployed reports when printed goes to my default printer. How would I be able to remove the default printer so that when they print the report, it would default to the user...
Hi guys! I have a "can grow" field on my report and I wanna determine it's height after it has "grown". I have tried referencing it after loading the report, but I always get the value I set in designer, even though it is obvious that the field is now four/five times higher. I reference it via ReportDefinition class. I need not to menti...
When I try to instantiate a ReportDocument my app crashes - even when wrapped in a try/catch block. This only happens on Windows 7 machines (it might also happen on Vista - I haven't tested it there). Machines running XP don't have a problem at all. try { ReportDocument doc = new ReportDocument(); // This cause the app to crash } ca...
Hi, Can someone tell me if it's possible to load external CrystalReports (2008) .rpt files? I now embed them so they're compiled with my core. It would be nice if i can make changes to a reports layout without having to recompile anything. Is that possible? Thanks. ...
I'm putting an image in a crystal report (using Crystal Reports for Visual Studio 2005). The image is a product logo with a white background, and the report has a white background too. But when I run the report you can see it's not quite white. The off-white color is barely visible, but it is visible and more so when printed. I've trie...