I've written a formula as follows whileprintingrecords; shared numbervar level1; level1:=level1+1; ToText(level1,0); And placed it into a report as so: Report Header a | {formula} {Text:Introduction} Report Header b | {formula} {Text: Scope} Report Header c | {formula} {Text: Overview} Group Header a | {formula} {Grou...
I am a newbie to Crystal Reports. There is a Parameter which has 2 values Yes and NULL in the mapped database column. I am trying to create a cross table with count, like - Name Yes NULL ABC 5 2 XYZ 3 7 How can I display 'No' in place of Null like --- Name Yes No ...
Hi, I have dropdown parameter with multi-values allowed. In my report header I want to show all the dropdown values that were checked by the user to run the report. But since there could be a couple of hundred values I want to show 'ALL' when all the values are selected instead of listing them one by one. How can I do that? Thanks, ...
Hi, I'm using crystal reports 10 and have an issue with a duplex printer. Basically I've a report that used to print to a printer in non-duplex mode. This report prints a list of new users created on a particular day. Previously this report would print 1 user per sheet. We've had a change of printer which only prints duplex and now...
I have visual studio 2010.. i have install the SAP Business Objects Crystal Reports for vs 2010.. In deploying my application.. what crystal reports runtime should i used? I have visited the sap website but i didn't find any available runtime.. Tnx.. ...
hi i have my database that show by crystal report, it has field ID and Name. i need that if the value of ID = 8 the line in crystal report will paint in red and if ID=10 in green. i use C# VS2008 thank's in advance ...
We currently have two web servers (Windows Server 2008 Standard, IIS7) setup to host an ASP.Net website and are using the basic features of our hardware firewall to provide network load balancing (NLB) between the two servers. This means we have had to change the ASP.Net session state mode to SQL Server in order to make the data stored ...
I have a Crystal Report used in an ASP.NET web application that I've just come into a project I'm assessing/turning around. The reports are called from a web page or web service and are sent an ADO.NET dataset - using ReportDocument.SetDataSource for some tables with a relation etc - all defined largely in code - initially loaded from t...
I need to pass a list of key values to a stored procedure in SQL-Server, and that stored procedure then returns back the values needed for a Crystal Report. Rather than sending a comma separated list and then parsing that, it was suggested that I use a Table Type. So, I've defined that table type as simply made of integers: CREATE TYP...
Hi, is it possible to execute a crystal report (TCrpe component) from a Delphi non VCL main thread when Output = toWindow? I execute reports from a background thread, and when Output is toPrinter or toExport, everything is fine. I know that creating forms in a Delphi non VCL main thread generally is a bad idea. When a Crystal Report...
Scenario 1. Crystal Reports 8.5 2. Visual Studio 6 The above combination creates hundreds of .tmp files on drives and project directory folder on each time a project is compiled/run and I am sick of searching and deleting the temporary files. Is this some sort of misconfiguration? Does anybody know the secret of the .tmp files and how ...
Hi, I have a web application that has a report. I export this report as PDF and send it to the client. On this report I have a field that has a font set to a non-standard windows font (i.e. a barcode font). The barcode font is a TTF font. On my dev machine, I installed the font, printed the report, barcode was displayed. On the serve...
Hi all, A few days ago, I have migrated from vs2005 pro to vs2010 pro. To do this I have setup a new pc with installed win7 pro 32 bit With my surprise I have understand that CrystalReport is not shipped with VisualStudio 2010. So I have downloaded, like required from visual studio, two file from sap site, the runtime and the Cr Ide....
Using VB.NET on VS2008. I'm having trouble getting this report to work when using different data tables for some subreports. The thing that throws me off the most is that if I SetDataSource only once I don't get any errors but if I use two or more tables from the xsd the "Table [name] could not be found" error shows up. This works (com...
I am new to crystal reports so this might be novice to you. I have created a cross tab with row grand total to the right. How can I add an extra column to display Average of the rows. I am using Crystal reports 2008 Here is a rough example of the cross tab- How do I insert the Average column? Thanks New York Chicago Bost...
I need users to be able to enter text in a webform with some basic formatting options and then generate a report showing the formatted text. The support for HTML is horrible and entering a simple bulletlist doesn't even show properly in the report. Right now i'm using a textarea with tinyMCE but that's because i don't know what else to...
I have to add a crystal report to a tab item from a tabcontrol in Silverlight. Is it possible to do this without using 3rd party controls, just with usual controls on Visual Studio ? And if it is possible, how do I do this? ...
I'm in a bit of trouble here. I upgraded one of our Winforms products from VS2008 to VS2010 about 4 weeks ago. The conversion was fine but we used Crystal Reports so had to install the VS2010 Crsytal Reports for Visual Studio 2010 Beta 2. This was fine and gave me the designer etc. back for crystal. I chose not to convert the reports...
I have in my project a report that calculate some event ...i want insert a chart in this report but its unshown when i complie it .... its shown like un appernce image :( RunTime Application Thanks in advance ...
Hi I have crystal report 10.0 and IIS 7 (windows 2007) installed.I have added an image in my crystal report.When view the report from my web application, the added image is not displayed.but when i export to PDF file it gets displayed. How can i solve this so that my crystal report displays the image in my rpeort. Thanks ...