Recent update: 2008-3-21
Hi, For an ASP.Net application is it necessary to have Microsoft Office installed on the server in order for crystal reports to export data to office formats? Is exporting of data in office formats possible with Crystal Reports bundled with Vs.Net 2003 or does it require a developer edition. ...
Hi,I tried to pass a collection of objects to the crystal report i created but it kept prompting the error message 'Load Report Failed'. I debugged step by step and realized that the collection of the passed in objects became empty after i set the data source for the report. I doubted bcs of ...
139 byte By
SSM at 2008-3-5
Hi, I want to use a stored procedure with dynamic sql,I am not able to view the fileds when I try to create the reports.what should I do?
366 byte By
zahnej at 2008-3-3
Have created a dataset on the fly in VS.Net. Not linked to a database. Crystal reports is asking for log on info for access to the dataset at runtime. How do I stop this. Saw a similiar post but I guess I was not smart enough to figure out all the links that were given to Bus.Solutions site. ...
HiI have an urgent task that includes setting a few parameters to a crystal report file, probably created in CR 9. I only want to set a coupl of parameters and then print the report. I don′t have to display it.I intend using VS.NET or VB6, but it seems to me that .NET is the best choice since ...
124 byte By
SSM at 2008-2-28
Hi, I have a table of information,is it possible to sort the table by that value on click of the header? Thanks, SSM
Hello AllI am trying to create a report in a Website that uses a class for populating data.I've followed the example in http://www.businessobjects.com/products/dev_zone/granville_beta/GranvilleBetaOnlineHelp/step by step, but in the Report Wizard (after building the solution) when i choose the ...
Hi,I can't seem to get crystal to use the new SQL Native Client to connect to a SQL Express database, when I try I get the error :Logon Failed. Details: ADO Error Code: 0xSource: Microsoft OLEDB Service ComponentsDescription: Format of the initializartion string does not conform to the OLEDB ...
Hello all I want to know what is difference between crystal report 8.5 (which is along with VS 2003) and Crystal Report 11 thanks Nilay
We are maintaining a web application that uses VS 2003 and Crystal .NET and developing an upgrade using VS 2003 and Crystal XI. How can I switch back and forth between Crystal environments in VS 2003 on one development machine? Is it possible? Has anyone accomplished this? Scott
2309 byte By
SSM at 2008-2-23
Hi,I am using crystal reports bundled with VS.net.I have an aspx page with links to various reports.I have created reports with parameters.how do I obtain the parameter values.Won't the crystal automatically prompt for the parameters when it is opened as I have parameters in the reports?I am ...
I need to give the enduser 5 options to choose to group on. For example they could group by Salesman ID and product category or vice versa. Or Salesman and the state the product was shipped to. And the report would just have a static detail band. Thanks
158 byte By
SSM at 2008-2-22
Hi, I am using vs.net bundled Crystal Reports,When I open the Report in the browser,I don't see the export option,am I missing something? Thanks, SSM
218 byte By
SSM at 2008-2-21
Hi, is it possible to use Stylesheets with Reports?I have a bunch of reports for which I need to have similar formatting like colors,fonts etc...so is it possible use stylesheets for this?if so,how? Thanks, SSM
655 byte By
MickyG at 2008-2-20
After copying my application to our web server I've noticed that the dates in the report are in American format, even though in the design of the report the field is set to display the date in dd/mm/yyyy format and the regional settings on the web server are set to English UK, with date set to ...
Hi,I have a problem to pass data set to crystal report XI's report, I have try it with Crystal Report 8.5 and its work.I used "File Definition Only" as my data sourceThe code is like below, ReportDocument doc = new ReportDocument(); doc.Load("C:\Customer.rpt"); string cString = "Persist ...
Hi,I have a SQL server database called DelveDatabase, it has a table called ORDERS, this orders table currently contains a one record.I add a CrystalReport item to my project, double click it and it enters design mode.I right click -> menu -> Database ExpertSelect Project Data -> ...
The problem is the when I run the report for a particular stored procedure the output is as long as 200 pages of report. Can this be changed so that we get 20 long pages of the size of 10 times the usual size. This can help since we have to move ahead and back less.I am using Crystal Report ...
After much newsgroup searching, I was able to make CR work on my web server. However the charts (images) inside the reports do not show up.The src attribute for these images look like this:src="//CrystalImageHandler.aspx?dynamicimage=cr_tmp_image_5f03e8ad-37b4-4b16-923e-264e3b3a0314.png"And ...
Does crystal report support CLOB data?I have to bind a stored procedure which returns CLOB data to my report. I am presently unable to do this. Do we need to specify some settings for this or is there any equivalent datatype in crystal reports.Please reply soon It is very urgent.I am not able ...
402 byte By
Anibol at 2008-2-16
Hi, i've a table with 2 fields: 1. Datetime with values like 30/01/2005 10:10:00 2. Integer with values like 0,1,32,5,2, tc. Well, i want a report with a graphic that has datetime field on x-axis and value o y-axis, and i can't get it. I've converted datetime field to number by a formula so ...
I am using CR XI from inside VS .NET 2003.Is there a way to have a button or file menu option show up on the CrystalReportViewer page? Is there a pre-existing prompt dialog to enter the email information like the one you get if you are inside CR (menu: File->Export->Export Report) ...
253 byte By
Kyote at 2008-2-15
Is there a way to use the prompting style of CR XI in a .NET project instead of the default prompt? I'm looking to put all my Parameter fields on the same prompt instead of four different pages. Also how easy is it to use all the new functionality
Okay, now I'm really upset. A while back, I created a small Web app with a menu that lets you select a report, and then a web form that takes in the parameters for the report, and then a web form for each report. I'm successfully using the Session object to transmit the parameters between ...
I am attempting to use Crystal Reports to generate a report for a Windows App with Visual Studio 2005 beta. I want to insert the values for various parameters that are determined through the course of running the app into the report fields. However, reading the documentation seems to imply that ...
622 byte By
dekej at 2008-2-15
I would like to display all the data in a table on one sheet of paper in a report. I know it will all fit if I have each row of data go down the page like a column and set the paper to landscape. Unfortunately I cannot get it all to fit by having each row go across the page with the paper set ...
In my report I am using a Stored Procedure as the datasouce that returns me a ShowinList flag and DuplicateSettings information together with other data. If the ShowinList flag is set to '0' I need to show records whose DuplicateSettings is null and to show all records without any ...
69 byte By
TimM at 2008-2-14
Can I test Visual Studio 2005 Beta with the XI version I already own?
523 byte By
ETS at 2008-2-13
HiI am using VS 2005 beta2.When creating a crystal report you have a Field Explorer for for the current DB tables that u are working with. Welll for some unknown reason i can enable mine or just will not show... the Field view options stays greyed out all the time and i have everything to get ...
Using: Crystal Reports 11Setup:Step 1: Added Query to xtreme.mdbC:\Program Files\Business Objects\Crystal Reports 11\Samples\en\Databases\SELECT DISTINCT Orders.[Ship Via]FROM OrdersORDER BY Orders.[Ship Via];Step 2: Modify Orders.rpt (Edit Parameter: Ship Via)C:\Program Files\Business ...
Hi All.I am currently using bundled in Crystal Reports that comes with Visual Studio 2003. We have a requirement by which we need to dynamically change the image (LOGO) of each reports generated. Right now I have to embed the logo in header subreport and then include them individually in each ...
66 byte By
Bonnie at 2008-2-12
What version of Crystal Reports is shipped with Visual Studio 2005
376 byte By
guest at 2008-2-11
I have to print null vales in my report as 0. I used if else and isnull method for that. it works for me. here is the code. if IsNull ({Table.totdays}) thennumberVar tot := 0 else numberVar tot := ToNumber ({Table.totdays})If all records have totdays null then @ run time it will give an error field...
I have a report that I created in visual studio.net 2003. The report displays but the data in the report is old and out of date. I tried reportname.refresh() in the code but it gives a error message that login failed. I pass the username and passwo Private Sub Page_Load(ByVal sender As ...
Date CallElementDetail CallElementDetailValue01-Jan-07 E-mail 101-Jan-07 Short Message Service 001-Jan-07 Fax 001-Jan-07 Enquiry Form 002-Jan-07 E-mail 002-Jan-07 Short Message Service 002-Jan-07 Fax 002-Jan-07 Enquiry Form 003-Jan-07 E-mail 003-Jan-07 Short Message Service 003-Jan-07 Fax 003-Jan-07...
572 byte By
J.Shen at 2008-2-10
I have created a crystal report on remote server, and published it as a web service all using Visual Studio 2005 beta2. Then I created a web form and a viewer at local server, which was set up to retrieve the report. The reports without charts or images are displayed perfectly, but others are ...
678 byte By
EJK at 2008-2-10
Hi all,I am developing reports using Vb.net with crystal report,i came across the scenario where in i have to use the same method which i have developed in vb.net and am assining the Values as followsDim objdoc as new reportdocument method1.LoginName = LabShared.GetLoginName ...
69 byte By
TimM at 2008-2-8
Can I test Visual Studio 2005 Beta with the XI version I already own?
Hi All, This is regarding the issue which I faced while exporting the crystal report to Excel format I am using visual studio 2002 version. In my application I am exporting the report to excel, pdf and word formats. The problem I am facing is that, what ever be the report exported to pdf is ...
I recently purchased XI developer. What version of the merge modules should I be using to get things working with VS 2005 - the ones that shipped with XI, Visual Studio 2005 or others? I didn't install the VS CR version - just kept my XI developer version. I am having problems exporting files ...
198 byte By
SPK at 2008-2-7
I see that the layout options 'Group', 'Crosstab' and 'OLAP' options are greyed out under the 'Data' tab of the chart expert. Is there something wrong with my installation. Thanks in advance
Hi,In point 8 of Setup Project Deployment you said :8) In the Prerequisites dialog box, under the Choose which prerequisites to install list,select .NET Framework 2.0 and Crystal Reports for .NET.can i know where can i find the Crystal Reports for .NET if i need to select download prerequisites ...
3939 byte By
SSM at 2008-2-7
I am getting the following Error?What could be wrong.It is very urgent.Pls help Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file ...
270 byte By
dekej at 2008-2-6
I have developed a webforms project with reports on my laptop, and want to copy the project onto our production server. Do I need to install Visual Studio 2003 or Crystal Reports on our production server in order for the users to be able to view the reports? Thanks
403 byte By
SPK at 2008-2-6
I need to plot a point on a graph and I am using XY Scatter chart. I have the following questions regarding this.1. I can set the data range for the y-axis, but how do I set this for the x-axis? My range is static (30 - 110) and there is no need for me to change this dynamically during run ...
382 byte By
Carol at 2008-2-6
Hi,I have a VS 2005 web project, VB.Net with a Crystal Reports XI report. Works fine on my development environment, however, after I deployed to the server, the data appears fine, but the icons (export, print, etc) show as a box with a single red \ in it, and are not functional.Can someone please he...
Hello would anyone know how to dynamically change the datasource of a crystal report from within VB. The documentation lists the 'SetDataSource' method but it does not appear to work.? Thx
Hihopefully someone will be kind enough to help.I am using a crystal report viewer to display my crystal reports. I initially run a store proc to populate a table which I need to become the source of the report I wish to display. However, when the report is displayed, it always shows the data ...
Is there a way to use Integrated Security when displaying a Crystal Report from within a .NET application? I'm currently using the below code, but would prefer to not hardcode a username/password into the application. Thanks for your help.sean'Setup the connection information structure to be ...
I've created a .NET application that displays an existing Crystal Report, which runs fine on my machine. Following the directions from the Cyrstal Reports 10 and .NET document from Business Objects, I'm not able to build the application. As described in the document, I added a setup project ...