Good day! I want to know how to pass a value to reportviewer textbox. I want to pass the value of a datetimepicker to reportviewer textbox. How can I do this? Both reportviewer and datetimepicker are in the same form. any help is much appreciated. Thank you.

Member Avatar
Member Avatar
+1 forum 3

hi everyone im really new to report viewer in vb.net and i wanto import the data from an excel file to the reportviewer in vb.net can anyone help me out? here is waht i tried so far: Private Sub ViewReport_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local Me.ReportViewer1.RefreshReport() End Sub Private Sub ReportViewer1_Load(sender As System.Object, e As System.EventArgs) Handles ReportViewer1.Load ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local conn = New OleDbConnection conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strExcelPath + ";Extended Properties=Excel 12.0;") 'dta = New OleDbDataAdapter("Select * From [Sheet1$]", conn) conn.Open() adpt = New OleDbDataAdapter("select * from [Sheet1$]", conn) rs = …

Member Avatar
Member Avatar
+0 forum 4

Hi guys, Need help for this, i'm developing an application and here's what im trying to do: -I have a search box where i can type and search for a data(With DataGridView). then after i searched & found that data when click it on DataGriView as highlighted, data will be viewed on ReportViewer. All i need is Code for Searching in database(MySQL) and function on how to pass it to ReportViewer. Thanks.

Member Avatar
+0 forum 0

Hello, I'm currently working with a program that using the reportviewer in VS 2012. I have been looking online since yesterday, trying to find any kind of tutorial on how to switch between reports. I have this so far, but it doesn't work. I have another snippet I've been trying to work with, and it too is having issues. This code directly below doesn't throw any errors, the set after it does. //i don't use these blocks of code at the same time... this.reportViewer1.LocalReport.DataSources.Clear(); DataTable dt = new DataTable(); dt = this.DataTable1TableAdapter.GetData(); string name = "DataSet1"; // this must exist …

Member Avatar
Member Avatar
+0 forum 2

Hi I have problem in Report viewer. I am using the expression to filter the value. I explain my scenario. I want sum the amount for particular category. I have student database. I need the sum the paid amount for exam fee only. =SUM(Fields!Amount.Value, "DataSet1") . It sums all amount. But I need to sum EXAM FEE only. Please help me how to do this Thank you Maideen

Member Avatar
Member Avatar
-1 forum 3

Hi I have an issue in asp.net using vb code I am using Visual Studio 2012 with MSSQL 2005. I have problem in adding Report viewer, Version=11.0.0.0. I have an error "'ReportViewer' is ambiguous in the namespace ". Please anybody help me to solve this issue maideen

Member Avatar
Member Avatar
+0 forum 2

Hi to all I want use one reportviewer for several reports each with a parameter. This person has done it here http://www.sourcecodester.com/visual-basic-net/load-rdlc-report-using-report-viewer-programmatically.html without parameters. How can it be used with parameter for each report. when I change line 15 to da.Fill(ds.Employees,txtEmployeeID.text) (where txtEmployeeID holds employee ID as a SQL parameter), code runs but no report. I get the error "An error occurred during local report processing. The report definition for report 'Employees' has not been specified. Could not find the file C:\Users\...\Bin\Debug\Employees.rdlc" And curiously my report path is C:\Users\...\Desktop\MyReport\RepTrial\RepTrial\Employees.rdlc Some say that if we change the report's Build Action property …

Member Avatar
+0 forum 0

Hi, I'm updating an application to .net from VB 6.0. It uses crystal reports to display reports but we get issues around versioning and having to have the client install Crystal so we would prefer not to depend on Crystal. I was originally going to use an XMLReader object to read in XML generated by a SQL query and a XSLT stylesheet to transform into the reports and I had this working BUT: 1. Currently I'm the only one who knows how to generate the XML through a SQL query 2. I'm also the only one who really knows how …

Member Avatar
Member Avatar
+0 forum 1

How to pass value to reportviewer table Good day! I want to know how to pass a value to reportviewer table. I want to pass the values of a listview to reportviewer table. How can I do this? Both reportviewer and listview are in the same form. any help is much appreciated. Thank you. i want codes in VB.net

Member Avatar
+0 forum 0

Good day to everyone! I would like to ask how to create a custom receipt, say a delivery receipt, where the data to be used in the header portion will come from direct input of a Windows form. I've found one here but it is for VB6. Any guide will be appreciated. Thank you.

Member Avatar
+0 forum 0

I have two tables, tblstudent having fields [studentId,rollNo,classId,studentName], tblclass having fields [classId, division,className]. The two tables are referenced by field classId. I want to fill tblstudent. Also I want the table tblClass should be filled at the same time. This is for creating reports. Can any one help me..

Member Avatar
Member Avatar
+0 forum 5

In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that takes SQL code. I need to get the value of cmbxYear.SelectedValue into the WHERE clause of the TableAdapter. Does anyone know how I can access/pass the variable value from the form into the DataSet TableAdapter SelectCommand WHERE clause? (I am open to other ideas of how to filter an rdlc …

Member Avatar
Member Avatar
+0 forum 2

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data.Sql; using System.Data; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; namespace test { public partial class WebForm1 : System.Web.UI.Page { string username; string fname; protected void submit_Click(object sender, EventArgs e) { username = nametxtbox.Text; fname = fnametxtbox.Text; CrystalReport1 report = new CrystalReport1(); using (SqlConnection con = DALHelper.GetConnection()) { SqlCommand cmd = new SqlCommand("testsproc", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@username",username); cmd.Parameters.AddWithValue("@fname", fname); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet1 ds = new DataSet1(); da.Fill(ds, "users"); CrystalReportViewer1.Visible = true; report.SetDataSource(ds.Tables["users"]); CrystalReportViewer1.ReportSource = report; CrystalReportViewer1.RefreshReport(); try { con.Open(); int count = cmd.ExecuteNonQuery(); } …

Member Avatar
Member Avatar
+0 forum 1

Please tell me "I am Using c Sharp window form and crystal Report" I want Display the record User input windows form.i.e If user Input in textbox CustomerID 1.It should show the record in crystal Report only Customer Id 1.

Member Avatar
Member Avatar
+0 forum 1

How to create report in core java

Member Avatar
Member Avatar
+0 forum 3

Good day, I have a ReportViewer showing a report that is bound to a dataset. The dataset gets its data from a Access database backend. I have a separate form that allows the user to add/update/delete data. My problem is when the user makes changes to the data using the data entry form, the report does not reflect those changes. I have to close the entire program and reopen it before the changes take effect on my report. Can somebody help? [CODE]Me.transactionsTableAdapter.Fill(Me.transactions._transactions) Me.ReportViewer1.RefreshReport()[/CODE] I've been doing some readings online, and it seems that I need some code that rebinds data …

Member Avatar
Member Avatar
+0 forum 7

hi , i ma using the reporting service in MS SQL express 2008. but in the company i don't have the admin previlages to upload and create reports to the server. if i was to ask from the administrator to grant me the previlages what previlages does he have to give to me??? please reply thanks

Member Avatar
Member Avatar
+0 forum 8

Hi everyone! How to save image from picturebox to Datatable and display to crystal report. Any idea would help. Thanks and regards to all programmers!

Member Avatar
Member Avatar
+0 forum 3

Hi there, i have a question in C#.NET report viewer. i save the phone number in the database as (234) 233-1346 . so if the use doesn't type in a phone number it will be saved as [() - ] which is show in side the squared brackets, without the squared brackets. in the report it sows as () - for the number that are not inserted. how can i avoid it and leave a blank over there?? please can someone help me!!!!!!!!! thanks

Member Avatar
Member Avatar
+0 forum 2

I developed a web application using vs 2008, cr XI and sql server 2000. When I do click in my web application's “Print Privew” button from the browser after publishing the project, I can see all pages properly, but when I print, only the first page is printing even if i select page from 1 to 5. the second problem i am facing, navigating from one page to another page, it is taking too much time. is there any way to preview the from the client side instead of server side.

Member Avatar
+0 forum 0

friends i am using reportviewer in asp in which i show the record through stored procedure and the prooblem is that i used a textbox and a search button in textbox i insert date. i want that after the given date all record shown in report viewer here i paste my code in this code only one record shown in report but same result after every search plz help meeee... [CODE] protected void Button1_Click(object sender, EventArgs e) { string a=TextBox1.Text; ReportViewer1.Visible=true; SqlConnection thisConnection=new SqlConnection(ConfigurationManager.ConnectionStrings["base93ConnectionString"].ToString()); SqlCommand cmd=new SqlCommand("Executepasswath"), thisConnection); cmd.Parameters.Add("@lookdate",a); cmd.CommandType=CommandType.StoredProcedure; DataTable dt=new DataTable(); SqlDataAdapter adp=new SqlDataAdapter(cmd); adp.Fill(dt); System.Data.DataSet thisDataSet=new System.Data.DataSet(); …

Member Avatar
+0 forum 0

I'm trying to figure out how to pass a parameter to a report in VB... [URL="http://screencast.com/t/MjBhYjYxOTM"]http://screencast.com/t/MjBhYjYxOTM[/URL] I've looked at the microsoft library on the report viewer class, but it's only slightly better than a boat anchor... does anyone have any other useful tips on how to figure this out?

Member Avatar
+0 forum 0

I installed Microsoft Report Viewer Redistributable 2008 and use report viewer control in the C# express 2008 win forms, also i installed Microsoft Report Viewer Redistributable 2010 and use it in the C# express 2008 win forms, but in c# express 2010 when i add reportviewer (2008 and 2010) to win form it is not visible at design-time, why?

Member Avatar
+0 forum 0

Hello Everyone , I am working on [B]vs 2008 RDLC report[/B], i need to use [B][COLOR="Red"]two table which are from a single store-procedure[/COLOR][/B], when i am added a table adapter it is reflecting the first table, so how can i use the second table in the report....

Member Avatar
+0 forum 0

I have a problem getting the report to do a page break on a multi column report. This is a staff photo report with four columns and should do a page break (not column) on change on the office location - so far I get it to do a column break at the end of the office location but refuses to do a page break. I have goggled and tried all the possible recommendations? Any help will be greatly appreciated.

Member Avatar
+0 forum 0

Hi all I have Created a software using Vb.net and Ms-Access using VS2008. I am using ADVANCED INSTALLER to create a .exe Package and get its deployed. It works well in my machine but in the Destination machine , I get an error as shown below: [CODE] System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' [/CODE] I have Googled for the solution and I find out that the error is because of missing the following assembly files: [CODE] Microsoft.ReportViewer.Common.dll …

Member Avatar
+0 forum 0

I had created a report using Reportviewer control(VS2008+MS-Access), the report displays all the records from Access Db correctly but i need to sort the records and display. [B]Sorting by Date(Ascending) that too the records prior to Today's date should not be displayed[/B]

Member Avatar
Member Avatar
+0 forum 1

I had created a report using Reportviewer control(VS2008+MS-Access), the report displays all the records from Access Db correctly but i need to sort the records and display. [B]Sorting by Date(Ascending) that too the records prior to Today's date should not be displayed[/B] Another query "Is it possible to edit and Update the records during runtime?"

Member Avatar
+0 forum 0

The End.