I'm currently working on a system that requires monthly, quarterly and annual reports. I have no problem in generating/retrieving the data, my problem is the presentation. What is the best way to do it? I need the report to be:
View 3 Replies
Basically, I am looking for a method on how to preview reports from a datagrid or it can be from the access database which populates the data to the datagrid (then displays this in the datagridview) in vb.net vs 2010.I believe there are two methods using the ReportViewer or using Crystal Reports, but so far, I have no idea how to get them to work. The first idea would be favourable - using the data from a datagridview (which may of already been sorted, filter etc) and be able to produce a report on that.
View 1 RepliesMy day job is a firefighter and we work shifts. I'm trying to figure out the best approach to highlight days of the week in accordance to the shift schedule.
Where can I find a complete reference to the Monthly Calendar form?
I figure that is the best place place to start... unless you have another idea...
When trying to import CrystalDecisions.CrystalReports.Engine, and CrystalDecisions.Shared. I'm getting a green line. What might be the problem?
View 3 RepliesI'm very new to Crystal Report for Visual Studio 2010 hence, kindly give me step by step instructions to do the report on Windows Form. I'm using SQL Server for my Database (SQL Server 2008 Express) and Visual Studio 2010 Prof.
View 3 RepliesI 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?
View 1 RepliesI 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.
View 2 RepliesI 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.
View 6 RepliesWe had our Crystal Reports report sheets in 2008 working and when we moved to 2010, some of them which their datasources were binded to dataset and datatables are not working.
View 2 RepliesI have Visual Studio 2010 Professional, version
Microsoft Visual Studio 2010
Version 10.0.30319.1 RTMRel
Microsoft .NET Framework
Version 4.0.30319 RTMRelMy Labtop runs WinXpSp3 Pro, version
5.1.2600 SP3 Build 2600
Physical Mem 1024 MB
Processor X86, Intel 1862 MhzVS installation did not have Crsytal Reports, so i downloaded this single file from [here] as shown in the photo:After installation completed, i could not find the crystal reports any where in the VB2010, so i changed the .Net Frame work from Client profile to .Net framework 4.0 as i found in some blogs, but still did not solve the problem any how.[URL]..
I'm using MySQL with Vb.Net 2010 and Crystal Reports and to be honest I'm a complete noob when it comes to using Sql Queries. The problem is, I want to generate a report that will show the service fee from a transaction a person made while also showing the items bought, and their quantity and prices, basically a bill. I created a command from the data source I created in crystal reports and it contains this query:
SELECT t.transaction_code,t.fee,t.service_type,t.date_sched,total_bill, s.item_code, s.quantity_sold, i.item_description, i.price, CONCAT(p.fname,' ',p.mi,' ',p.lname),p.address FROM tbl_transaction AS t, tbl_sale AS s, tbl_item AS i, tbl_profile as p WHERE t.transaction_code = '{?trans_code}' AND s.transaction_code = t.transaction_code AND i.item_code = s.item_code AND p.id='{?p_id}'
[Code]...
I'm wondering if it's possible to check in the application start if the system has the correct assemblies installed to my application to work?Let me explain, i have a application that uses several reports, and to solve the problem of the first time open report, I run in another thread a dummy report. This works fine if the user has the crystal reports installed but if it doesn't the app stops working.
View 3 RepliesIs there any kind of limitation on UFL Dlls that are being used on crystal reports? Such as connecting to webservices, using interops, etc?
the UFL dll is working fine, once i started debuging it i noticed that i could not call the webservice, not even create an instance of the SoapClient.I did test the SoapClient from an Exe and it did work fine, just not inside this dll.
[URL]..
After downloading crystal reports for VS 2010, the code i used in VS 2008 generates a database login error
[code]...
- I added report wizard to the solution. - Then according to instructions i added fields to report.- But how I can attach the report to the Windows form ?- In Visual Studio 2005, I used crystal report viewer to attach reports on the forms.
View 2 RepliesApparently Crystal Reports doesn't come with VS 2010 Ultimate like I thought it did. When I went to create a new report, I got prompted to download it free and install it. Then, after installing it, I tried to recreate a report and got the same prompt to download it again.
View 2 Repliesdoes anyone knows how to develop dlls for crystal reports 2008?My OS is Windows7 x64 but i would like to develop dlls for x64 and x86, i won't mind to compile them separately.
View 1 RepliesI have Visual Studio 2010 Professional, version Microsoft Visual Studio 2010 Version 10.0.30319.1 RTMRel Microsoft .NET Framework Version 4.0.30319 RTMRel
[Code]...
After installation completed, i could not find the crystal reports any where in the VB2010, so i changed the .Net Frame work from Client profile to .Net framework 4.0 as i found in some blogs, but still did not solve the problem any how.
i am developing an application in vb.net having crystal reportsi have stored all my reports in a folder called report in my applicationbut initally when i executed i got a error msg like the report doesnot exixts in debug folderso i copied all the reports from report folder to debug folder & its workingany changes that i mke in report folder needs to be copied into the debug folder alsois it possible that the reports be executed from reports folder only & not from debug folder as everytime i need to make changes in the debug folderhow can i chnage the path to reports folder
View 1 RepliesWe 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...
View 4 RepliesI'm very new to Crystal Report for Visual Studio 2010 hence, kindly give me step by step instructions to do the report on Windows Form. I'm using SQL Server for my Database (SQL Server 2008 Express) and Visual Studio 2010 Prof
View 5 RepliesI want to use crystal reports 2011 in visual studio 2010. How can i use it?
View 1 RepliesI just purchased VS 2010 Professional. I was using 2010 Express and i used to use Crystal Reports 9 to create my reports. My problem is that CR9 does not allow me to connect to the new MS Access database (accdb). It only lets me connect to .mdb. I used to use .mdb but i have upgraded to MS Office 2010.
[Code]...
I have Visual Studio 2010 installed on a 64-bit OS with Crystal Reports for Visual Studio 2010 (obviously 64-bit edition as well). When I installed the runtime, their installation notes stated that if you develop 32-bit applications, you need install the 32-bit runtime, which I did. Testing the application and all is well.
However, this application is going to be distributed as x86 and x64. Now I have not yet converted my project to 64-bit, but should I now install the 64-bit runtime? How is this going to affect my 32-bit installation and report designs?
Secondly, when I distribute my application to the end-user, will they also be required to install the Crystal Reports runtime? Also according to their installation type (32-bit/64-bit)?
Lastly, I want to convert my project from x86 to x64. I understand you set this option by Build > Configuration Manager > (project) x64. Is it ok if I duplicate the entire project folder contents and setting only the duplicate project as x64?
Is it possible to see the page setup during print preview of crystal reports during run time?
Because there are times that we need to set the top and bottom margin of the report.
I have to update and old VB project made with Visual Studio 2005 that uses Crystal Reports to Visual Studio 2010. I've installed the Crystal Reports plugin for VS 2010. I can compile the program under VS 2010 but when I run it and try to generate a report I get many errors popping up from the Crystal Reports Viewer. When I compile and run the project in Visual Studio 2005 (with the old Crystal Reports plugin that comes with it) everything works fine.
The problem is caused by SQL Expressions that are SELECT statements that are not enclosed in parenthesis. This is a problem because there are ~250 SQL Expressions like that in the report file (and it's not the only report with this problem). When I look at the .rpt file in Crystal Reports 10 and use Database -> Show SQL Query the SQL Expressions have parenthesis around them despite there being no parenthesis around these statements in the SQL Expression Editor. When I do the same in Crystal Reports 2008 the SQL Expressions don't have the parenthesis included.
Is there a way to make Crystal Reports 2008 or the plugin in for VS 2010 automatically include the parenthesis around SQL expressions, or was this feature removed? If it was removed, is there anyway to enclose the SQL expressions in parenthesis other than editing each one manually?
i'm a freshman and was handed this assignment a short while ago and i'm having extreme difficulty figuring out why i keep getting the following error message whenever i click btnGenerate.Click on the form:Error1: Unable to apply this change while debugging. 'Private Sub GroupBox1_Enter(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles GroupBox1.Enter' was deleted that modifies 'Public Class Form1'. You must revert the change or stop the debugging sessionBasically the assignment is requesting that we build a 'Call Cost Calculator' and since im relatively new to this i've never worked with strings before and also get the follow errors:Warning2Variable 'sCountryBeingPhoned' is used before it has been assigned a value. A null reference exception could result at runtime.Warning3Variable 'sPhonePlan' is used before it has been assigned a value. A null reference exception could result at runtime.
My form codes:
vb
Public Class Form1 'heading Const sFormHeading As String = "Call Cost
[code]....
I reals because it's driving me mad and i'm honestly quite literally stuck and can't move on until i get this sorted.
How can we create a report in vb.net without using any crystal reports
View 11 RepliesOK, I have this loop I want to perform which involves the serial port. Not to get too specific I'm actually sending data to an external device within a loop The loop involves a Start number, increments by a Step and ends when it gets to Stop This repeats until I click a STOP button.
View 15 RepliesI 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.
View 2 Replies
