I am trying to figure out how to export a crystal report into a PDF file from an ASP.NET application. I got it to work, however, I want the group tree to show up as bookmarks in the PDF. From what I've found on google, the way to do this is to declare an instance of the CrystalDecisions.Shared.PDFFormatOptions class, then set the GroupTree property to true.However, this class does not seem to exist. I don't know if its because I am using Crystal Reports for Visual Studio 2008 or what, but it is not there. There is a class called CrystalDecisions.Shared.PdfRtfWordFormatOptions, however, the GroupTree property does not exist in this class.
I am using vb.net 2005. I am trying to set report groupings of a crystal report at runtime based on user defined options. MSDN says this: Dim FieldDef As FieldDefinition FieldDef = Report.Database.Tables.Item(0).Fields.Item(comboBox1().Text) Report.DataDefinition.Groups.Item(0).ConditionField = FieldDef But error shows invalid group number
I want to export 2 different reports when I click an Export button. The problem is the routine only fires once and I only get one report to print out. Am I doing something wrong? I think it has something to do with the HTTPResponse, but I'm not sure.
Here's my code:
Dim badgeSize As Integer = 0 'Drop Down selection Dim badgeData As New DataSet 'Visitor Badge Data Dim badgeEmployeeData As New DataSet 'Employee Badge Data
We are using VB.NET 2010 with Crystal Reports to generate reports for our project. The reports are filled from Data Sets that are filled from Arrays. As far as that goes all is working great.Where we are running into a headache is when we try to total up a specific column in the generated report. We have created a Group called EMPLOYEE that creates grouping by employee name. We cannot seem to figure out the necessary steps to get our AMOUNT column (Numerical field) to total in the EMPLOYEE group or anywhere else for that matter. No luck with Google (may not know what to look for...) no luck here and no luck with my CR book...
I want Number of cartons and Pieces currently available in the stock that are about to expire in next 30 days and this is calculated based on expiry date...I have used formula field on crystal report to calculate current stock like "stock.crtns_added - stock.crtns_removed" and "stock.pieces_added - stock.pieces_removed"....Now I want to group by item name, category and expirydate because based on these three columns there can be more than 1 entries in the database....I want that when there are more than one entries the formula should sum up all the cartons and pieces for same item of a category with same expiry date and on report it should display just 1 line showing available cartons and pieces that are about to expire
How can i do this?? How can I apply group clause on the formula field in crystal report to get sum of cartons or pieces for each item based on expiry date??
I am working on VB.NET(Visual studio 2008)..I completed developing my application and i need to deploy the application. I tried it and faced problems in some areas like adding crystal reports to the setup and deployment. I created a setup file to my application and everything is fine except crystal reports...its showing the error like; An error occurred in crystalDecisions.Reports, crystalEngine threw exception.
I am trying to export a report but everytime it runs the code to export the crystal report in the crystalreportviewer I get an error message saying "Missing Parameter Values". I've looked through many sources but havent found a solution. I do know that all parameters are filled in because without the export code, the site runs perfectly fine.
Export code Try Dim CrExportOptions As CrystalDecisions.Shared.ExportOptions
I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
In MS Reports, I have a tablix(table) where I group on foo. How do I get the count for each group? This is how I would do it for the total count: =Count(Fields!foo.Value) , but it's not enough.
I am preparing crystal reports using vb.net 2008 with ms sql server 2005.everything is showing fine.. except that i want my report to be multiple column... I cant do this using "format multiple column" option because the data is not shown in details section. Actually i need to group the data in data.
e.g: i am preparing a warehouse report to know how much quantity of which products are left, products with 0 (zero) value are not displayed..
I want my reports to be as follows: item1 item_quantity item2 item_quantity item3 item_quantity
i have a question concering Reports. I am using Visual Studio 2008. As it currently stands when you try to export a report you have two options, either export to pdf or as an excel file (97-2003). Is it possible to also include an option for saving the file in Excel 2007 format as well?
I run a report of nearly 10 pages in Ms.Access, included in with various conditions. When I export text to Ms.Word, the text is not justified but is left aligned. Is there any possibility of getting text aligned at export.
I'm using VS 2008 to develop a solution which will report on data mostly contained in SQL Express databases, across two servers. It will be used by up to about 10 XP clients. I am unfamiliar with the Reports Applications. Will I need to buy extra licenses to use a Crystal Reports application? Why are they both included in VS? What is the basic difference between them?
How can I connect to a Crystal Reports 4.6 report that connects to SQL Server 2005 as a data source, using Visual Basic?I don't want to specify the connection string in the report. I want to pass the connection from VB. Is there any way to do this?
I am working on Windows Forms Projects.I am creating a report for customers.The report data is pulled from a "CustomerDetails" table.A field in the table is called "CustPhotoName", this holds a string which relates to an image file.
I Currently have a report set up which runs for a single customer by passing in a customer ID. Then using the passed in ID to populate a Dataset with an ImageRow and then a sub report with the image from the dataset.
I am wanting to set up this report where I can pass in an array of customer IDs and produce the reports (1 page per customer with image (if CustPhotoName has value))
I have created reports using Crystal Reports in my asp.net application(vb). It was fine. But when I run it in another system, the report loading fails. So I modified my code like this.
sub Loadreport() try Dim sreport as new ReportDocument sreport.Load(Server.MapPath("ClientList.rpt"))
[code]....
When the control comes to the line:-
sreport.Load(Server.MapPath("ClientList.rpt"))
it jumps to the catch block showing "Invalid Report path". But initially, the code was not showing any error. I haven't changed the path.
I made a program in VB .net 2008 that has a form in which there is a Crystal Report Viewer object. Here is some code:
[Code]...
1. Some reports show tens and hundreds of thousands or records (they are required to do so, so no work-around is possible), thus the time it takes for the Crystal Report Viewer control to actually show the report is very long. I would like to display like a waiting dialog window WHILE the report is loading its records telling the user to wait for it to load.
2. Another idea would be to show the number of records currently loaded (and continuously updated as the report loads them) from the total number. This is actually shown in my reports when i open them with Crystal Reports 10, but NOT with the Viewer control on the form! How can i make it show this?
Since there doesn't seem to be any way to load old VB6 (ActiveReports) reports in .Net, I need to recreate dozens of reports in .Net. I'd like to do this in the least painful way possible.In VB6, the original authors simply did something like this for every report:
GetAllUsers() returns an SQL string which selects a bunch of fields; those fields are then used in the report.Now:How can I do something similar in .Net (either using the built-in Crystal Reports, or the built-in "Microsoft Reporting Technology")?I can't get "Database Expert" to recognize globalConnectionObject (an ADODB.Connection object); and if I fill a dataset and do
report.SetDataSource(dataSet)
It tells me "The report has no tables."How do I populate a Crystal Reports report!? (the connection string/data location is not known at compile time)
I've recently made the switch from the Data Report to Crystal Reports 10. I've rewritten the reports our software uses and they are working fine in a nominal reports location.I have heard that Crystal Reports can be compiled into a single executable file which can be called through vb.net, rather than loading the report from a location.
I already installed crystal reports in my vb 2010. (i got it from the sap website) but crystal reports won't appear in the toolbar. i could add a new report, but i can't put it in my design form cause just like what i said, there's no crystal reports in the toolbox. i already checked crystal reports in the customize button of toolbar, but still it won't appear.
I want to create a Crystal Report for particular engineer installation details. In that report I want to show to no of installation details for particular engineer.Report model looks like this:
totalnoofinstallation assignto c_address c_mobileno package_det frm_date to_date 3 FE01 Ramnagar 232345 xx 25-04-2012 05-04-2012 SQL Server table data look like this:
I want to create a report based on some criterias such as dates or names. For example, the user will select the dates from a combo box above and the report to be displayed in some type of container such as a panel for example. Is that possible? My software is like some inventory program, basically just counting no of items in the container and the ones that were delivered. Then at the end of the report, I need to mention the number of items that are still in th container and the ones that were delivered.
I am in the process of creating a reporting module. I am stumped on trying to load a report from an existing saved report with an OpenFileDialog. The report that is selected will not load into the CrystalReportViewer. I receive the following error:
Private Sub OpenToolStripMenuItem_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles tripMenuItem.Click ' Open an existing report file.
