I want my application to be able to print details from the databse. I hava a report already in the program but it displays the list off all persons in the database. I want to create a form where i can use a query and the result of the query would be printed on the report.
View 2 Repliesi know how to generate the Datareports through Data Environment by Firing a query
View 1 RepliesI'm having a problem with my crystal report with regards to report footer. I want to display the data from the table, column name "Remarks" in report footer but when I try to call the data it doesn't show the remarks. I'm using VB 6 and mdb files as my back end. Is there any command or fundamental that I've missed?
View 1 RepliesI need advise on how to solve this scenario. I am not sure whether I should use any Report Application such as Crystal Report or I can just simply use datagridview.My scenario:In a new form, a table will show a least 3 columns.
First, ItemID
2nd, Total Quantity Sold for the Current Month
3rd, Total Quantity Sold: Last month
ItemID Current (Nov) October
ABA1 100 85
ABB1 80 90
Hence, I can compare the figure of the current month with the past few month.Right now, I do not have any problems building SQL_String for calculating the Total Qty Sold for the Current month and display it via DataGridView. But I am not sure how to additional column that calculate the Total for the past few month
I am trying to convert a VB6 Data Report (.dsr file) to a Crystal Report through the migration process within Visual Studio. I have read articles that reference adding a Data Report to a Project from Visual Studio 2005/2008 and that it will convert the Data Report to a Crystal Report, but I have not been successful in doing so. Does the VB6 Data Environment need to be converted too? Has anyone been able to do this successfully and if so, how?
View 1 RepliesCan you look at my coding and let me know what I'm missing or doing wrong?I have a SSRS report that is called from a ReportViewer control and the ProcessingMode for this control is Remote. The report also has 1 parameter in it's DataSet.In the code I placed a MsgBox to make sure the code is finding the parameter and returning the parameter name. I am trying to stick the value of 10 into the parameter for playerID 10. Data for this player does exist.
I believe I need to add some more code to make this work but I'm not sure what else to add.
When the code executes the report is displayed but no data is shown in the report.
[Code]...
I m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 RepliesI just started learning VB.NET about a moth ago (I have been taking classes, so its been about 5 days worth of classes) and I decided to work on this project idea I had. Essentially, it's a database to keep track of anime and manga that I, or whoever else uses it, have watched/read.[code]...
However, now I want to make it so that when one selects a specific title in the list box, it will show the data in the tags below the <series> tag that matches the item selected in a label. One thing I just thought of is than since the list box gets populated in the order that the series are in, it could be easier to go in order from first item equaling the first <series> and so on.
how to retrieve data from SQL Database using SQL Connection by selecting the individual value in a ComboBox which the data in the ComboxBox is also retrieved from the SQL Database using DataBound. A 'Display' Button will be clicked to display the data in a TextBox, based on which value the user had selected.
Below is my current
Private Sub displayBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles displayBtn.Click
'Create Connection
[Code]....
I'm using an OleDbDataReader to loop through my imported excel file and it gets everything in the file except for the first row. How can I specify that I want to see this header row?
[Code]....
I cannot get my combo box to populate using a select statement from mysql database.
[Code]...
NB: I'm using Visual Basic.NET?My form has 2 DataGridView controls. One of these is bound to a DataSet, the other isn't visible - at least not until the user selects a uniqueidentifier cell in the 1st grid.When the user makes this selection, the 2nd grid will become visible and display the row from another with the same id as the one selected in the 1st grid.So, basically, I want to dynamically display data in one grid based on user selection in another grid.My code looks like this so far...
Private Sub RulesGrid_CellClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles RulesGrid.CellClick
Try
FlagsGrid.Visible = True
[code]....
I have a DataTable with about 64 columns, including "UserAnswer", "CorrectAnswer", and "QID_Lookup". I am building a LINQ that will select all the rows that have a correct answer (user answer matches correct answer), but I only want to select rows that have distinct "QID_Lookup".
[Code]...
The problem is that the result set includes duplicate QID_Lookup values. How can I include only distinct QID_Lookup values? keep in mind that there are 64 columns, so if I can avoid it, I wouldn't want to list each column individually for selection.
[Code]...
I'm doing an application where I open a specific process. And after opening that process I need to send data to him like username and password.
[Code]...
Is there a way to prevent a user from entering data into a ComboBox, rather then selecting, or can anyone suggest a routine to catch and prevent entries so the user can be made aware the they are not acceptable?
View 7 RepliesOn my app. there is a lot of labels created by code (Please see my post "Filter text before Data Binding) how can I by clicking on one of this labels have the app respond by bringing up a text box bound to the same field so that changes can be made to that field?
View 3 RepliesI have a datagridview with data in it, i have set it so you can only select the row and one at a time.However, i need to get the data from one of the cells in the selected row, i have tried this
View 2 Replieshow I can reference a report variable in the Report Properties Code Window of a local report? I have tried Variables!Claimant.Value (for a variable called Claimant) but I get an error "Reference to a non-shared member requires an object reference." I have tried qualifying it with Report. and also with the report name in front of it but I get errors with this also.I have the variable CLaimant defined in the Variables section of the Report Properties.
View 3 Replieswhen i try to add new data source aftre selecting the table & befor finishing i got the message..An error occured while creating the new data source
An error occured while generating the data source and in error window following error does come Custom tool error: Failed to generate code. Failed to generate code. Invalid access to memory location. [code]
I've been looking everywhere for an answer to a simple question, but i'm having issues, so i thought i'd join and post here. I'm having issues with a simple concept. I load information from a SQL database, and i want to add a 'Passport' link URL relating to column cells called 'name'. It basically selects the name, and inserts it into the link fields to be opened. But i cant find a way to work it. I thought i could do it with something like:
[Code]...
I have a datasource linked to a table in a database.When I wnated to display this data on a form, I just dragged the datasource onto the form and it did everything for me, including the code to fill it;
Me.ProjectFileTableAdapter.Fill(Me.ProjectFileDataSet.ProjectFile)
My problem, is that this program will have multiple users, and I don't other users to be able to see each others data. So the problem with the above statement is that it fills the table with ALL the data in the datasource. How can I make it only display data that is for a specific user?Here's the code that is used to fill the tableadapter:
Private
Sub
frmViewCurrent_Load(ByVal[code].......
Currently we are using a VB script macro created in word to create some fairly simple forms based off of data entered on a data entry form. I am very new to VB, and I have been able to create many applications using forms, but I have absolutely no history creating reports. I have been reading up on the reports, and it looks like they are designed to use with data sources like tables. I merely want to take either data from the entry form, or from data derived internaly from processing the user entered data and populate a defined report "form". I have been searching, but there is so much on printing reports, that I feel overwhelmed. I am not looking for the exact answer as much as a link or place to look for a sample for what I want to do.
View 2 RepliesI work as a console technician for an audio company in the north eastern United States. My job is to prep and manage all of our audio console before they go out on tour. form to the report?
View 1 RepliesI have a report viewer in a form, and when I run the project I want to watch the values from the fields which they are coming from a DataSet.
The Dataset comes in full into my form. I have install the Report Viewer as Microsoft says BUT!
I am a newbie to .net and am using vb.net 2005 and ms access. I've made a crystal report but the prob is the report displayed has only the headings and no data... and this happens when I add more than 1 table, single table report works properly.
I've used
Dim cryRpt As New CrystalReport1
CrystalReportViewer1.ReportSource = cryRpt
CrystalReportViewer1.Refresh()
and
Dim cryRpt As New ReportDocument
cryRpt.Load(My.Application.Info.DirectoryPath & "CrystalReport1.rpt")
CrystalReportViewer1.ReportSource = cryRpt
CrystalReportViewer1.Refresh()
as the codes...
i have a system that will search a data and print it, the problem is that everytime a search the data and shows its result when i try to view it using crystal report it shows a wrong data... the crystal report shows the very last entry that the user added and ignored the previous data.
heres my code;
Dim frm As New PClearViewer
PClearViewer.Show()
[code].....
I am preparing a crystal report for library system...two tables..
1)BookIssueDetail:
fields : grno ,bookno,issuedat
2)studentMaster
[code]......
this is my code...this work fine when i have only one table in my dataset but when i have 2 or more table in my dataset then my crystal report cpe blank.no field is displayed....all d report dislay all the field when i have only one table in my dataaset.i dont know i m missing a big ort small point here but this thing is killing me...my almost proj is done but i am stuck on this thing..
I have an MS data report in which I have dragged items from dataset. In fact my datareport has items from two datasets and this is the problem. My report comprises two parts, Header and detail and each part need different datasource.
View 1 RepliesI have an Access database with a table called Events.I created a new VB.net 2008 project and created a MicrosoftReportViewer control. I also added a "Report" component (which created a .rdlc file).I am easily able to drag things from my Access database I added to the data sources onto the report. However, one part of the report I would like to add data to a Matrix that I calculated with VB (ie it is not in the database). The database has a list of names and a bunch of times associated with each name. and then I calculate some fancy stuff based on those times. I would like the matrix to be a list of names (from the database) on the rows, a list of dates (which I specify in the code) on the columns, and the data of the matrix I also calculate.
View 3 RepliesI�m working on a project that saves records to a datatable/dataset. I then serialize the dataset to save it, and deserialize to show the records in a datagridview, I add more records, serialize, deserialize etc etc. � I�m using binary formatting. I added the dataset/datatable from the toolbox and selected �untyped� for the dataset. I want to print out this table and other text. Do I need to draw a report using graphics on to a page and then programmatically add the data from the deserialized file, or is there a better way to design and add data to a report? I�ve looked at crystal reports and report viewer and I cannot see how to programmatically add data using them � they both talk about connecting to a SQL or ADO database which mine isn�t.
View 5 Replies