I need to create a report in Crystal 2008 and I've haven't developed a report using Crystal in many years. When the user runs the report, I want them to be able to enter a start date and end date. I assume I can do this by using parameters. My question is this. Can I do this with a single parameter value or will it require two paramet...
I've recently come across the following error in one of my crystal reports following an accounting system update. Group #1: ? - A : This group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field. I've verified every database field being used to ensur...
I am trying to display an existing Crystal Report in my ASP webpage. Report uses a SQL Server stored procedure which expects an input parameter that's a date. I'm using C# with Visual Studio 2008. The code below works but has a problem. When the report first appears it has a default date selected which is fine. I select May 28, 2010 an...
We have a VB6 application that can generate reports using the Crystal Reports 8.5 runtime. To generate one of the more complicated reports we have, the VB app does the following: Deletes records from a SQL table (we'll call it Foo) based on the session ID of the user Performs a select statement, and populates the Foo table with the co...
I have a Crystal 2008 report that will be deployed to an InfoView server. There are four different databases the user might want to execute the report against. Each of the four databases have exactly the same schema. Only the data in each is different. Each database corresponds to a plant we have around the world. Instead of creating fo...
I am new to the ASP.net and crystal reports.. I created a report using crystal reports and i used 3 parameters as Division,Month & Year. These parameters values will come from database using dropdown lists.. after selecting the parameters, report button clicked the report should come.. Report is coming but the values what ever I taken ar...
I'm working with a Crystal Reports object in Visual Studio 2008 (C#). The report is building fine and the data is binding correctly. However, when I try to resize an IBlobFieldObject from within the source, the scale is getting skewed. Two notes about this scenario. Source image is 1024x768, my max width and height are 720x576. My ma...
Hi, I have Crystal report 10 and need to connect to oracle db. Am looking for CR Oracle ODBC driver. Where can i get it from.Please help. ...
Hi. I have a Crystal report where the data source has originally been set to use ODBC connections. Now I want to modify the data source to instead use OLE DB instead of using ODBC. How do I replace the data source connection without breaking the database fields which I have originally set up for my report? If I try to delete the orig...
When setting ExportFormatType.CharacterSeparatedValues crystal report generates every row of data prefixed with column names (Report Headers). Why it does this? How it could be fixed? Usually it is preferred to have single header. For excel export type - generated report looks ok (only single header for all rows). I am using crystal rep...
We have several reports that have a header that looks exactly the same but each report pulls its header information from a different database table. Is it possible to use a single shared/external subreport for the formatting but pull from a different table depending which main report the subreport is hosted on? ...
I am creating a Crystal 2008 report, and I'd like to provide it a T-SQL statement for data generation, instead of selecting and joining together tables. Can this be done? ...
Hi folks, I have integrated the below code in my application to generate a 'pdf' file using crystal reports in MVC project. However, after the request is processed, i get to see only 2 pages in the pdf file while my 'data' returns more than 2 records. Also, the pdf isn't rendered as soon as the page is processed but instead i have to r...
Possible Duplicate: CR Oracle ODBC driver which odbc driver should i install to connect crystal reports 10 to oracle 11g ...
Hello, I'm using Crystal Reports for Eclipse 2.0.4 and I have a problem. I use a formula in an report to subtract one day from a string which is a date: ToText(CDate({Agreement.EndDate})-1, "dd.MM.yyyy"); This works for the German locale. With an English locale, the calculation is absolutely wrong because the day and month is intercha...
How can display two detail section's data after completion of first detail section in crystal report of vb2005 like detail of first detailsection #one row.........................." #second row........................." #three row.........................." detail of second detailsection #"one row.............." #"second row..........
Hello, After spending a good 3 to 4 hours on google trying to find any solution to my problem I haven't had much luck. Basically, we use crystal reports for our .NET applications with a sql server back end, we have many clients each with their own server and so our reports need to have their connections dynamically set. Up until a wee...
Hi, I am developing a web app. My users want to be able to design their own reports. Is there a way I can embed a simple Report Designer in my app? If so, which Report Designer app should I use? The Report Designer should be an existing app. I don't want to create a Report Designer from scratch. More details: My app is an ASP.NET MVC a...
Hi! We have a client that is using the SDK for invoking reports on the Business Objects Embedded Report Server. We can login, but when calling the openDocument method, something goes wrong. code: //LOGON IEnterpriseSession session = sessionMgr.logon(username, password, clusterNode, authType); IInfoStore infoStore = (IInfoStor...
Using Crystal Reports 8.5 on Windows Vista or 7, I'm using the ToText function to report a value: totext(Sum ({ap121w7.yrentamt}, {@type1099})*100,"000000000000000000") The result (if yrentamt is 0) is -000000000000000000 The dash (I assume it's a negative sign) is unneccessary and unwanted in my report. Is this a bug, or is there an...