crystal-reports

Crystal Reports - adding same footer to multiple reports

I have multiple reports all of which require the same footer (company address, VAT no etc). Is there a simple way to write this information once and apply it to all of my reports? I thought I could do this with a simple subreport but this just seems to copy the subreport to the main report and any changes in the 'footer report' aren't ...

Crystal Reports Formula to parse RTFtext based on font format ie Bold and Italic

I have a column of RTF data that looks like the following: The terms or definitions to be used in this document are: Daily Operator. Used when the user is.......etc.. Using crystal reports I would like to grab just the BOLD text using a formula or equivalent. I keep getting the RTF markup instead of standard text. Here is an example ...

crystal reports 2010 Change OLEDB connection

I am using Crystal reports for Visual Studio 2010 beta 2. After upgrading my project from using Crystal reports 12.1 to 2010, it started showing up set Connection dialog. I am using oledb connection for reports while designing, the following code was working with Crystal 2008. I am using Visual Studio 2010 with Target Framework as 2.0 A...

Crystal Report showing HTML text, but the bullets don't show. Why?

I'm getting data out of a SQL-Server nvarchar(3000) field, which is formatted as html, displaying it in Crystal Reports 11. The data is being saved as bullets, and if I pull out the data and drop it in a text file with an html extension, it shows the bullets. But from Crystal, it does not. I get the new line, but no bullets. The fiel...

Crystal Reports Cross Tabs Growing Into Each Other

I have a report with several crosstabs in the report header. The problem is that some of them grow down into the ones below them. Is there an option to have each crosstab dynamically determine its starting position based on the end of the previous one? ...

How to make crystal report fit width with ?

Hello ! I have a Silverlight application. On the server I have an aspx file that contains a report viewer. I get the report from the server and I display it on a RadHtmlPlaceHolder. The report has set the property FitWidth and BestFitPage property set to false. I would like to make the report to fit the place holder's width, maybe to ...

How can I insert page breaks between groups in Crystal Reports

In selection expert options "I have set Keep Group Together,new page before,new page after" which makes sure a new page is set. how can I make sure that a new group always forms on a new sheet of paper? Can this be done in the formula expert? right now it is coming in seperate page. i want a new organization employee list record in new...

How to suppress specific bar on bar graph in crystal reports?

So I am trying to suppress a specific bar on my bar graph. So instead of populating the graph from the database, I am populating it from a formula field. So in my formula field, I have something like this: if field <> "Member" then formula = field So it gets rid of the field however it leaves me with this: I know I can make a subre...

Crystal reports zero values

Hey guys, So I have this report that I am grouping into different age buckets. I want the count of an age bucket to be zero if there are no rows associated with this age bucket. So I did an outer join in my database select and that works fine. However, I need to add a group based on another column in my database. When I add this group, ...

Crystal Reports: Text field flow justified around image/margin indentation

I'm creating a report that outputs a letter. The first page contains is a large left margin containing static company information. The letter output can be multiple pages, however I only want the text on the first page indented to the right away from the left margin. How can I accomplish this with one text field (the letter body is all o...

Crystal Reports - Accessing IGraphObject properties at runtime

Hi All, I am using Visual Studio 2008 and Crystal Reports that is shipped with it. I would like to set certain properties of a chart such as Chart Title at Runtime. I have tried via ChartObject but there are only limited properties such as top, width, height etc. and not the properties I'm interested in. I included "craxddrt.dll" in m...

Is SQLite DataSource compatible with Crystal Reports?

I am thinking to use SQLite for the newer version of my app. Is SQLite compatible with Crystal Reports? I am using VS2008. ...

Deploying Crystal Reports with default parameters

i have a report with parameters that have been assigned default values, it works fine while previewing the report but as soon as I publish it to the server the default values dont show up. Can some one help me figure out the best practice in publishing that maintains default value Thanks Abey ...

using vb 6 reports in asp.net

Hi Everybody, i have crystal reports in vb 6. can i use those in asp.net and How? ...

Operation Not Implemented Exporting Excel (Data Only) Crystal Reports 2008

I'm trying to deploy an application to a client's server, but export to Excel (Data Only) is not working, giving me the "Operation Not Implemented" error. It isn't a problem with the report, because I have over 50 reports with standard fonts, some of them very simple, and the export fails for all of them. I have the feeling the incorre...

Crystal Reports subreports

Here is the scenario where I need help I ve got a report - XYZ Summary Report (with embedded sub-report) and the XYZ Details report (the sub-report) The requirement is that the XYZ Details report be a sub-report to XYZ Summary Report and also be available as a Stand Alone report through a Parameter. Report Information: 1) A Parameter...

how can we pass data from crystal report(8.5) to vb form

I made Invoice By Crystal Report v8.5 (Vb6 & Access). There is item Name and Price. At last Net Payable Amount:500(Exp), I need to Show In words(Five hundred). Crystal built in Function is not appropiate for it. So write a function in VB6 and it works nice. Now problem is how i send this value Crystal Report (v8.5) to vb.(I know to sen...

Why my report has strange fonts when I export it to PDF file?

Hi I have a report which has been created by Crystal Reports 8.5. When I run my application (vb6) and wanna show the report, every thing is all right but problem begins when I export it to PDF file. The .pdf file has strange fonts and can NOT be read . I have used "Tahoma" font for displaying text on the report. What is your solution? ...

Deliver a Crystal report using Web Service (ASP.NET)

My end goal is to open up a new browser window and display an animated progress gif whilst loading a slow Crystal Report. Using traditional asp.net methods to achieve this always results in the gif not animating during a postback, unless I use update panels but that's when things start getting messy. I have read lots of articles describ...

Implementing ACL in Crystal Reports 2008

My team have been working on implementing reports using Crystal Reports 2008. We are faced with the following problem: We need to be able to organize the reports into groups (representing the various departments in our workplace). The groups will have access to only the reports which they are authorized to. Is there any way to define th...