making report there in vb.net. i have a combo box there in my form. When user will run this form combo box will get ID number from database. When user will select ID number from combo box & click on show report button it will get information from database & it will show it there in report(report viewer). As a result user will be able to print this report.
View 1 Replies
how 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 Repliesi want to make a dynamic report in vb.net 2005 any one would like to i wish that at runtime i would be able to add some column or remove
View 12 RepliesIm designing a report with reporting services (not crystal) I add a table drag some fields to that table and that works great, now I need to add another table component and drag fields from another query (in the same dataset).When I try to test it it says:A data source instance has not been spplied for the data source Dataset1_SP1 (this is the second query).i need to list first elements from one query and then from another.
View 7 RepliesI m tryng to make report but its not working.i explain u to description of my project
i have 5 tables in form Payment,Receivable,Expense,Sale,Purchase and now i want to make debit credit form and its work that when i give a party name the report show me its statment
if the party is vendor show purchse from him and payment paid to him and if he is buyer so show him payment received and sale to him
I am working on an Excel report and I would like the top rows to be empty to allow for an image to be inserted. However, I do not want the image size to change the width of the columns and would rather the data below do that.
This is what I have so far:
If ComDset.Tables(0).Rows.Count > 0 Then
Try
[code].....
I want to know how can I get specific record to make report? For example I have student information there in my program. Its easy to create a report of all students. but if user wants to get & print specific record of a student what should I do? I have another question to ask. I have heard it that its possible to show each specific record there in each page by using NewPageAfter or NewPageBefore. I need to know is there any way that user will select ID number from combo box & when he will click on report button it will create report of that student what has been selected from the combo box?
View 1 Repliesmake a bug report in Visual basic 2010.
View 25 RepliesI am using MS Access Database at backend. In my application, I have a form, which does the search function for 3 fields, and the search is stored in a database and is then displayed in datagridview1 by the following commands.
Search
Dim dr As System.Data.IDataReader = cmd.ExecuteReader
Dim dt As New DataTable
[code].....
how to make a report which is from join tables!
View 13 RepliesI need to make a list box with 2 reports in it. Then i need to make a function that wil return the name of selected report, or if no report is selected then return "no report selected".After i made the list box i tried to make the function in the code builder: insert procedure -> function. I tried using an IF statement to make it that when a report is selected the report shows as in a msg... but it keeps saying something is wrong with my code.
View 4 Repliesi want to make crystal report of profit and loss statement i have a column of "vr_type" and there are 4 types in it "sale invoice", purchase invoice" now i want that put a 4 formula s where i select that "sum (vr_detail.debit) where vr_detail.vr_type} sale invoice it make Sum of al these types so kindly tell me what formula i should use to get the result in simply i want sum of sale,sum of purchase,sum of expense?
View 2 RepliesI'm Using vb.net 2008 i want display 2 different field in crystal report...here the code in form at vb.net 2008
If Not IO.File.Exists(path) Then
Throw (New Exception("Unable to locate report file:" & _
vbCrLf & path))
End If
[code]....
what i want is when i choose "TBL1" then at crystal report that only show the field from table one... = T1_CD then if i choose "TBL2" then at crystal report only show field and the data from table two... = T2_CD when i make file.rpt in crystal report i just can only drag field from table one.. how i can combine another field from table two?is neccesary that i must passing parameter from form at vb.net to crystal report?
I am using report.rdlc components in my application. I have one report where I have a tablix table embedded in a tablix list. The top of the list above the table contains all the group variables, eg customer name, customer address; the table contains the details, eg order details. I need to display the customer information again when there are too many order details to display on one page and I also need to display the order detail column headings again on the new page. So far I have played around with the Tablix properties and the Static row properties but no matter what I have tried I cannot get the headings to repeat.
View 1 RepliesIm using vb.net and I need to fetch data from two different tables and display it in form of report. These are the schemas and data of my two tables:
CREATE TABLE personal_details (staff_ID integer PRIMARY KEY, title varchar(10), fn varchar(250), ln varchar(250), mn varchar(250), dob varchar(50), hometown varchar(250), securityno varchar(50), phone varchar(15), phone2 varchar(15), phone3 varchar(15), email varchar(250), address varchar(300), confirmation varchar(50), retirement varchar(50), designation varchar(250), region
[code]....
My problem is that nothing displays on the report unless I take off either the training fields or the personal_details fields from the report.
When i pass the parameter and run the report it works fine as i close the form it closes the form is there any way so that i should be able to close the crystal report viewer and pass the parameter again and should be able to view report again.
View 1 RepliesI got a problem I want to print a report which is receipt having size 3 x 4 cm. i am unable to resize crystal report. i am using crystal report coming with visual studio.net 2008.
View 1 RepliesI created a button instead of the print button in crystal report because i need to record the report printed report serial number, date and time to the database. when i click on the button, dialog box appear. if i click on the ok button , system record the printed report details to the database and report printed successfully. but when i click on the cancel button , system again recording the printed report record.
[Code]...
I have created an application using vb.net 2008 and for reports Crystal Reports Basic for Visual Studio 2008 but the problem is, when I run the application in another machine away from developing box, I get the Load report failed notice. I don't have any idea on how I should approach this issue. I tried installing the CRRedist2008_x86 and CRRedist2005_x86 but still the problem won't go away.
View 3 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 have tride to generate report by using in built functions of report viewer. but it disply only the default color in to the legend. in my report i am showing chart report by using student marks and their name. the chrt bar color get changed as per the students marks means if student is pass then the the report bar display with green if failed then with red color i want to show the legend with student pass and fail status but on my x axis i have given a only a marks column value and it s showing only marks lable in legend but i want to show it with their status means pass with green color and fail with red color if anybody have the answer of this query plz reply immediatly
View 1 Repliesi want same custom header on every page when i print my report, how can i?
View 3 RepliesI am in a great problem, I have an application which working on mulity nodes but same report executing properly except one node. on that node when I trying the report after execution it giving 'numeric overflow' and the report not coming. the node also 32bit version. so what
View 1 RepliesI am the CEO of Virtual American Eagle airlines. I am looking for some help on how to make an automated PIREP system. PIREP stands for PIlot REPort. What I need it to do is connect to my site, make the pilot login, connect to FSX (Microsoft Flight Simulator X) and FS9 (Microsoft Flight Simulator 2009). It needs to track: that the engines are off, the speeds or takeoff, climb, cruise, and decent. Then I want it to track the time that the wheels hit the runway, the time that the engiines go off, then automatically put it into a list and with the push of a button, send it to our site.
View 10 RepliesI want to know how to create a report in vb.net 2005 through report viewer control
View 3 Replieshow to create a report in VB .net 2008 using microsoft report viewer?
View 2 RepliesI have a self referencial table Which contains fields Like ID, Name, Parent ID. By Using this table I wish to show records in crystal report Like a tree view format Like
View 1 RepliesI had created 5-6 crystal report in my vb.net project with back end sql server 2005 and i had given my path for crystal report. after this i had creted setup and deployed at customer machine but there it dosn't shows any report instead of it gives an error. for viewing report so how to come up with this probelm.
View 7 Repliesim trying to fetch rows in 3 TABLES using JOined Queries.im tried the query first in MS ACCESS and it worked but when i tried to show it in Crystal report it wont show its data. [code]
View 7 RepliesI am working on a windows application in VB.Net 2008. I have added a crystal report in my project. and I have draw a Crystal Report Viewer to view the report. But when I run this report It asks user name and password. (The snapshot is attached here) I have used the following code to set the log on info of report.
[Code]...
