HI all, I created a .net object (ex: A) which contain data have been collected from tables. Next, i create a List<A>() and pass to SetDataSource() method of ReportDocument object. When i run then an Exception have been throwed : "CrystalDecisions.CrystalReports.Engine.DataSourceException: The data source object is invalid" I don't kn...
We have several reports that do the same formatting operations (e.g. displaying "PASS" or "FAIL" if a value is within a particular range.) Without Crystal Reports Server, is there a way to share functions between reports so that they do not need to be duplicated? I understand I could do this with a user function library but I would pref...
I have a multi column report in crystal report.Is there any way to start each new group in new column in Crystal report in the same page? ...
Hi! I have a Tomcat 5.5 running which includes a Webapp with the Java Reporting Components (JRC) 2008. The Server has a different data source than the client, and currently I set it with the setConnection() functions on the tables, and it works fine. The downside is, that this taken 800ms (Damn slow crystal) just to set the datasources...
hi I want to display photo with crystal report i am using sqlserver 2008 and c#,I am storing imagepath in my databasetable(employee detail) and i bind this table with crystal report through dataset, now how can i bind photo no each record in crystal report pls any body help me i need it urgently. ...
We are having some major problems with reports at this time. We have some very large databases that have been using the same reports for years. Lately with our newwer builds we find that some reports will not work. We would go in and set the overridden qualified table names and set DNS to false, rebuild the views and then the report woul...
I have a very large table that I need to be able to select specific records from. I at first just created a parameter in Crystal and made it accept multiple values, but because of the size of the table, the reading of the records was very slow before it even got to the record selection. So I decided to create a stored procedure instead a...
I've got an .rpt file that I did not write and can find no documentation about. I want to be able to review the SQL that is generated from this report so that I can figure out, well, what data it was pulling and what WHERE clause parameters were used. I can open it up and see the report layout. But when I select Database|Show SQL Query...
Hi, I upgraded web project from VS2005 to VS2008 and CR from 10.2 to 10.5. After that when i run the report i get this error: BindingFailure was detected Message: The assembly with display name 'CrystalDecisions.Shared.XmlSerializers' failed to load in the 'LoadFrom' binding context of the AppDomain with ID 2. The cause of...
Most of my reports have migrated without issue, but I have a specific report which is failing (viewer actually crashes) on preview or run. This report has a subreport which is populated by a pl/sql procedure returning a variable number of columns, based on input parameters. The report is designed with all 'possible' columns inserted in ...
Hello guys, I have a pretty complex report. I have managed to create it up till the 1st sub report. Now I have to summarize the 1st sub report's fields inside a 2nd subreport 'horizontally'. 1) How do I pass the fields from sub report 1 to sub report 2 (Name & totals) & list them horizontally/each year? 2) How do I get each summary to...
Hi I am trying to have a master detail report. But the report always crashes as i hit the next page on the preview. Both the queries work fine in the query editor. Main report query select a.Name,a.ftid,a.instno from testschema.ViewA a where a.ftid={?ftid} Shared variables declared in main report separately shared numbervar instno; ...
Hi i have a long formula field which I would like to include as the cross tab report summary field. However after I define the formula field I don't see it in my crosstab screen. How to include it ? Here is my formula field WhilePrintingRecords; numberVar rt; numberVar layMdp; numberVar totMdp; rt=Round(({Command.GENGNPIAMT}/{Comma...
Can you please tell me how to integrate the CR 2008 into VS 2008 Team System as currently VS doen't give me the option to create Crystal reports using a template!!! Please guide me... The data on which the reports are to be based are in SQL Server 2000. ...
Hello fellows, Good day. I have a cross tab inside a subreport. I need to fetch the grandtotal of cross tab and display it in a textobject under the cross tab. Any clue how this can be achieved ? ...
My field explorer in vs2008 is not updating my dataset. So there any suggestions to this issue are welcome. I am using Crystal Reports Basic for Visual Studio 2008. ...
Hey, I'm trying to edit some .RPT files via VS08/Crystal Reports. Problem is, if i create new elements or delete/move existing elements, the text below (within a new section) floats up to (or above) the element i created. How do i create elements with an absolute "top-value"? Other than that, if there are there any design-essentials-t...
I'm trying to develop a Crystal Report that passes the user executing the report as a parameter to the report query. I'm using Business Objects Enterprise, executing the reports through InfoView which I would assume uses the Crystal "Special Fields" Current CE User Name, I just can't figure out how to link that to the query. Am I think...
Hi Everybody, I want to fatch data from sql server stored procedure in creating a crystal report. How to do that. Please Help ...
for example if label count is 3 in database, the label should be printed 3 times in the report. ...