I'm customizing another crystal report which was developed before me. One of the custom formulas includes the line: FreeFormText("kIMShipWhse") Is this a built in or custom function? thanks in advance.. ...
Hi, How can I get the DateTime difference between 2 DateTime fields in Crystal Report? I tried using DateDiff with not much luck, Any help/hint will be appreciated. Thanks, ...
I'm looking for a method to resize the page width Crystal Reports gives me to place fields in my .rpt file. So far I have discovered if I right click on the report, select 'design'/'printer setup', I can select the size of the paper I want the report to print out on. If I select 'Orientation/Landscape' I can increase the width of the p...
I have a couple duplicate custom crystal reports controls in my Toolbox in VS2005 and VS2008. One of each of the duplicates is preceded with the word Cached. These controls are all part of other projects in the same solution. I have removed some of the main controls that I don't want on the Toolbox by adding the [ToolboxItem(false)] attr...
I have a crystal report function which requires me to trim off characters which start with a "-" and delete the rest following the the "-" (dash). for example.. I would have order number 00000112345-C43-PJ how would I just trim off everything from the "-" and to the right and get the result 00000112345 I looked for a regex and subs...
I am using the CR 2008 RAS API (but could also use an older API if needed). Any idea how to access information about the settings for dynamic prompts in a report? I can access the PromptField objects with dataDefController.ParameterFieldController. GetPromptParameterFields(new PropertyBagClass()); but can't seem t...
I'm not sure if this is even possible but here goes: Currently I have a crystal report with a few header fields and detail lines ( of course) I pass a dataset containing a header datatable and a detail datatable. Everything works as expected... as long as I have only 1 record in the header table. What I would like to be able to do is so...
How to migrate Crystal Reports 8.0 to Crystal Reports 2008? The crystal reports which had stored procedures of 8.0 are not executing in 2008, can anyone help? We are using Seagate Crystal reports 8 and want to migrate all the programs to Crystal Reports 2008 Visual Studio Can you please explain the pros and cons of this.Thanks ...
We are running Crystal Reports Server 11.5. We have set it up for AD authentication and I have mapped the correct groups under Authentication in the CMC. The issue we are having is that when a user is added to a group in AD, Crystal Server does not pick up this change. The really weird thing is that if you go to CMC and view the Group's...
Hello all! I am using Crystal Reports 8.0.1.0 and have an OLEDB connection set as "favourite". We have several reports being run against a few stored procedures on the database. Our database is an SQLExpress 2005 named instance. One of the reports deals with balance, i.e. we have to provide a balance report for a specific company or se...
I want to know I can dynamically modify an existing Crystal Report (using C# and Crystal Reports 2008) so that it can report on fundamentally different data (from the same database) using the same layout. The reason is that we are building an application that allows the user to specify: A filter so that only the data they are intereste...
Hi, I'm trying to summarize data in a crystal report. I'd like to create a columnar view of data in crystal but am not sure how to do it. I was wanting to use a crosstab but when I try to insert, the control never appears. I create a crosstab report but when done, it comes to a blank report. I want it to be like this except columns would...
In crystal reports, how do you remove leading zeroes? I realize for the number 0000012313, you can use right(0000012313, 5) and return 12313; however this is presuming this is a fixed length. any ideas? thanks in advance ...
Hello again, Crystal is proving to be an increasing PITA... anyway, this is my brand new problem :-) I'm still working on the balance report, with the same structure, except that now the third party assets work beautifully. It has been implemented by using a subreport, but I am now trying to include it in a new report, because I need t...
Hi, I have application in C# (.net 2), and I use Crystal Report 11. When I will distribute the application throughout installer, How can I install Crystal Report run time files? Is there an easy way other than install the whole Crystal Report Runtime (43 MB) Thanks, ...
I could not print the subreport created. Whenever I click the print button, it takes me to main report and export main report in a pdf instead of doing the same for subreport. Will you please let me know why it is happening so in Crystal Report 10.5 and Asp.Net (VS 2008). It works fine in VS 2005 (ASP.Net and Crystal Report 10.2) ...
Hello again. Yes, still the same report as in this question and this other question. Yes, I know, I'm a CR noob :-) Anyway, I've browsed Google attentively and lots of tutorials about how to use shared variables popped up, yet I seem unable to grasp its workings because I can't achieve what I need. These are my formulas: (ActiveAttSald...
How can I print a picture that connects to a field image in a database using Crystal Reports? Thanks for any help. ...
I am in the process of creating a class that will query my local database and generate a series of scheduled reports on the Crystal Enterprise server (each with a different output file). I have done this in Java but would like to create a .net (VB or C#) class to do the same. Can someone point me in the right direction for sample code ...
I have a problem which is perfectly described here (http://www.bokebb.com/dev/english/1972/posts/197270504.shtml): Scenario: Windows smart client app and the CrystalReportViewer for windows. Using ServerFileReports to access reports through a centralized and disconnected folder location. When accessing a report which was designed agai...