I'm trying to upgrade an old ASP.NET application we've got, which was written in VS 2005, and uses Crystal Reports XI Release 2, to VS 2010; and still using CR XI R 2. When it gets to the point of trying to instantiate the ReportDocument type, I get the following error: An unhandled win32 exception occurred in w3wp.exe [3148] The Just...
I have created a crosstab in crytal report, in which it is required to suppress the Row Headers of the Cross Tab, I tried suppressing the Row-Header object, but by doing it, I still see the empty Row-Header cells. Edit: For example, I have Columns: Opening and Closing and Rows as Dates of some Month, So it would look like following in...
Hi, very new to crystal reports.. Question is that - In our .net application we view the crystal report, the report prompts for entering 2 parameter values i.e 2 dates and inturn these parameters will be used to generate the report. The parameter panel on the left has a button (show advanced dialog box). This button should again invok...
If I have a varchar column in a SqlServer db containg html, is there any way that crystal reports can display it the way a brower would? For example, if the field contains the string <b> <u> This is my text. </u> </b> crystal would know to display it as This is my text. I am using the crystal reports that comes with vs2008. ...
I have a cystal report, which prompts for parameter value to be entered. When I enter the value and hit okay, an exception is generated. The call stack of the exception :- at CrystalDecisions.Windows.Forms.ParameterFieldInfo.get_isDCP() at CrystalDecisions.Windows.Forms.ParameterValueEditControl.Start() at CrystalDecisions.Windows.For...
I am wondering if there is an easy way to calculate the text extent of a string (similar to GetTextExtentPoint32), but allows me to specify the DPI to use in the calcuation. In other words, is there a function that does exactly what TextGetExtentPoint32 does, but allows me to pass the DPI as a parameter, or a way to "trick" TextGetExtent...
Hi, How to suppress field depending upon next data field change? I have datas (two colomns of a table) which is something like as below: SubItemcode___________IsLock SODBPCFBX01601G_______N SODBPCFBX01601G_______N SODRWFIMX01G017_______N SODRWFIMX01G017_______N BG8Wx0191765044_______N BG8Wx0191765044__...
Hello: I want to preview a report in a Delphi 7 program that connects to a SQL database. The database can use SQL or Windows Authentication. If SQL Authentication my program do: MyReportComponent.Connect.Server:=myServer; MyReportComponent.Connect.UserId:=myUserId; MyReportComponent.Connect.Password:=myPassword; MyReportComponent.Conn...
//Using Small Business Code from PO Record in Subreport Accumulate Associated $ numbervar BC1; WhilePrintingRecords; shared stringvar BC; // added following 2 statements to prevent doubling value on last record 10/23/06 (WET) if shared stringvar BC = " BC1" and not onlastrecord then BC1 := BC1+{@PTEXT$}; if shared stringvar BC = " BC...
Is it possible to hide a row in a crystal reports crosstab? I have two rows that are only used to calculate a third row and I would like to hide them so only the result is visible to the user. ...
Hi i am working on crystal reports 11. Just added a stored proc with 2 parameters. but refreshing the report does not prompt for new parameters. Any suggestions. Thanks Amrita ...
Can crystal reports get data from an object data source instead of a database? I am using the crystal reports that comes with vs2008. I am coding in c# 3.5. I would like to use an object data source that returns a List< MyClass>. For when we migrate to ssrs in the future, Can ssrs 2008 get data from this object data source ? ...
We are looking for a solution to generate documents in PDF/A format for sharing and also archiving purpose. I checked the description of ExportFormatType.PortableDocFormat, however it just say PDF file. Can the Crystal Reports generate PDF/A compatible files? ...
Hello, I am looking for a way out in cross tab, so that if the columns exceed in cross tab, they shouldnt go on next page..rather a new cross-tab should repeat after the first one. For example, two columns are displayed in a cross tab : Now if a new column is added, and assuming that it could not be accomodated within the given page...
i am working on crystal reports in asp.net using c#. i am using reportdocument object rpt for load crystal report. i am using following code ConnectionInfo connectionInfo = new ConnectionInfo(); connectionInfo.ServerName = @"servername"; connectionInfo.DatabaseName = "databasename"; connectionInfo.Use...
Hi. I have to create Report in Crystal Report from In memory data set. This data set have two tables. 1st table is base table "ReportBase" having following fields ReportID [PK] ReportType Second Table is "StudentReport" which has ReportID [FK] StudentName Address In Report I want to display fields from both tables. Please sugg...
Hello ! I have a report and two subreports. In the subreports I used Sort Record Expert for defining the column that I want to sort the subreport. I would like to have a sort control, but I don't have the option 'Bind Sort Control'. Could someone be kind and explain me how to create the sort control in the subreport, if possible. Mayb...
WE developed system integrated with crystal Reports, with Crystal Report viewer on page. but the problem is we hosted it on 32 bit server but when access it and try to print the report it gives the error and does show any dialogue. we have installed full crystal report version with License but error is there. I tried to find but no succ...
Hey guys, I have an application that generates some pretty basic reports. I have installed the crystal reports .net 4 beta 2 for visual studio 2010 and copied the DLLs into my web site's bin folder. Everything works fine when running locally but when I try to create a report on my production server I get the following exception thrown. ...
Hi All I want to get the following working, please could someone advise... Dim rpt As ReportDocument If (Exists(rpt.ReportDefinition.ReportObjects("crlTitle"))) Then txtTitle = CType(rpt.ReportDefinition.ReportObjects("crlTitle"), TextObject) txtTitle.Color = mainColour txttitle.Text = "Report Title" End If Any help much ap...