I have a reportviewer control which is displaying an rdlc report that is bound to an Access table. In all of the date fields it is showing the time "12:00:00 AM". How can I remove this? Is it done through the reportviewer, the report or the binding source?
View 2 RepliesI want to create a column on a crystal report. I am binding crystal report to .net class object collection at run time. Now one of the columns I need to bind to the object collection property which is another object to it's property.
View 1 RepliesI am using VB.Net and crystal Report in VS2008. On Crystal Report I have a database(SQL20005) Column "Address".
I have used "Can Grow" option for that Column to change. But it resizes Vertically. I want to change its Width as Address have different data.
I am using VB 2008 & Access Database
for one of my DateTime field in data table i need to Remove it's Time part permently. I have tried following code but Syntax error received.Remove Time part from DateTime Field in MS Access Permanently?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click[code]...
Until recently my reports working ok, only after I convert it to vs 2008 all my reports not display in proper manner or shown error.The most noticeable is previously to hide the Pageview control in crystalreportviewer can be done easily. After this conversion all the codes failed me :(Another error is Invalid Pointer or Invalid Parameter. All report was working fine in VS.2003
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]...
This is my code for displaying data, but there's always the TIME on my date column
[Code]...
I USED THIS CODE :
Private Sub ButtonX1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX1.Click
Dim myReport As New CrystalReport1()
[Code].....
how to delete row in a CSV file where there is a null value in a partcular column? I am using VB. There are three columns I am using Post Date, Account Number, and Credit Amount. I want to delete all rows with null values in the Account Number column. I am very new to VB, took one class. I am using the Microsoft.VisualBasic.FileIO.TextFieldParser?
View 1 RepliesAm using a crystal reportviewer to generate my reports. Every time the report is loaded, the 'Main report' header is displayed; but, i don't want it displayed because it does not look smart.
View 1 RepliesI have a massive viewstate hidden field that is causing my application to be unworkable. I have tried:
EnableViewState="false" on every control
EnableViewState="false" in page directive
Page.EnableViewState = false in Page_Init
[code].....
I am trying to remove all spaces from a text field when a form is submitted so that the contents of the post code field match those in a database...
If drSet5c.Tables(0).Rows(0).Item("post_code") = UCase(Replace(tbPostcode.Text, " ","")) Then
response.write("Postcodes match")
[Code]....
So if the postcode in the database is AB12CD and the user types AB1 2CD the space is removed on submitting the form and the match statement shows. This is not working though.
Everything was working fine but suddenly started getting this error. I have the following code
ReportName = Application.StartupPath & "" & ReportName & ""
Dim ReportForm As CrystalDecisions.CrystalReports.Engine.ReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument
ReportForm.Load(ReportName) - I get error at this line
The path & other things are right. Till yesterday it was working fine & now I started getting this error, the only change I made in the report was I added a field.
I'd like to adjust Report field height at run time.In the 2nd image, at the 3rd and 4th row of "Wine" column, if the data length is enough for a line, I'd like to adjust its height into a line (And also bottom line object be followed by it). Otherwise, let it be two lines. Please share me which property I'd set.
PS: In page header, I use box object. But in Details section, I just use line object because in report footer, I need to show Total amount. If I use a box in these three sections, there is the box is expanded the whole page without having detail rows at the last page.
I have a RDLC report with a list that contains a table. I require a calculated column whose value depends on values from previous rows. Outside of a report I accomplish the same thing using code in a DataGridView's DataBindingComplete method.
From within a report how do I refer to specific cell values from previous rows? embedded code, but I have not had luck (#Error).
We are bysy with making a crystal report in vs2005 / 2008
We want to print the address of a bussiness, see picture-1.jpg
If field-2 of the second record isnt filled in we get the the result see picture-2.jpg
In the crystal report we don't want to show the empty information of field-2, see picture-3.jpg Is it possible to create this in a crystal report?
am a beginner in vb.net 2005 i have to generate a crystal report in vb.net from a textfield that the user enter and the following report should be generated depending on that query..
View 1 RepliesI have a crystal report that fails on a formula field but I cannot see why.
Here is my code:
Code:
Public Function CreateReportPDF(ByVal dsReport As DataSet, ByVal CrystalReportPath As String, _
ByVal reportSize As String, ByVal landScape As Boolean, _
ByVal dsParameters As DataSet, ByVal filePath As String, _
ByVal fileName As String) As Boolean
[Code]...
I'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 have a sales report (crystal reports), and it's launched from the APP, but I need to pass the value of 2 textbox and 2 labels to a sales report fields.
View 1 Replieshow to pass the value to the formula field in cyrstal report
View 1 Repliesi have stored the sort field parameter value in the variable szYes_No.I have to pass this value to crystal report, i used the code given below but not work--
Dim FieldDef As FieldDefinition
FieldDef = frmReportDisplay.cryRpt.Database.Tables.Item(0).Fields.Item(szYes_No & "{REP_i_fORMAT.Mem_Name}")
[Code]....
how can i pass sort field parametr to crystal report.
passing multiple values in a parameter field in crystal report viewer, I already set it to allow multiple values. When the code below executed it only displays the last record and not all of the records that appeared. here's my codereally need this one! Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
dt = New DataTable
sda = New SqlDataAdapter("SELECT * FROM KEMPMASTER", sqlcon)
[code].....
i made 2 reports but when i execute report so is always ask for username and password. please assist me that how to execute reports directly without inserting everytime username and password?
View 8 RepliesI am using VB.NET's TextFieldParser (Microsoft.VisualBasic.FileIO.TextFieldParser) to read a delimited file. However, when I try to read in a field with consecutive newlines within the field, the consecutive newlines are turned into a single new line. I would like the consecutive newlines to be preserved, but am unsure how.Here's an example file that I am reading in with exactly one field. The quotes are part of the file's content and there are three newlines (including the two consecutive newlines following line 2):
"This is line 1
This is line 2
This is line 4, which follows two consecutive newlines."Here is the code that I am using to parse and read in the file:
Dim reader as New Microsoft.VisualBasic.FileIO.TextFieldParser(myFile, System.Text.Encoding.Default)
reader.TextFieldType = FileIO.FieldType.Delimited
reader.SetDelimiters(",")
[code].....
how to create a report in VB .net 2008 using microsoft report viewer?
View 2 RepliesI work with VB 2008
I need to design my reports by users
please tell my the best way,or the best report type
I am exporting data from an sql table to an excel spreadsheet in Visual Studio 2008. There is a field that is date/time that I only need the time part of (hh:mm). I am using the Convert command to do this, but I am getting the error 'Undefined function Convert in your expression'. Is there another function I should be using? Or am I missing and Import command at the top?Here is the code (field TimeofFall is the one I am having trouble with):
Imports
System
Imports System.Data
Imports
[code]....
I'm using the Dynamic LINQ library code sample to dynamically return some data. The number of columns I'm returning is variable depending on user input. I'm enumerating the IQueryable into an IList. What I need to do is step through the Ilist one field at a time. I can get one row at a time by iterating through the IList's rows but I can't for the life of me pull one field out of the collection.For example, here I'm returning two columns (hard coded for testing but in prod it will be variable depending on what fields the user chooses):
Dim Dynq = dc.dt _
.Where("RUN_ID = """ & runNumber & """ and Upper_Pressure > 95") _
.OrderBy("Upper_Pressure") _
[code]....
Now I can pull a field out of the Ilist if I know the column name with something like:
something.Run_ID.ToString
but I wont know the columns I'm using until runtime and dynamically inserting it in a variable that's set at runtime doesn't work.So in Summary I have a Ilist that looks something like this
1 | Auto
2 | Auto
3 | Manual
4 | Manual
and I'd like a way to return
1
and then return
Auto
and then
2
etc...
what i am suppose to do here is - get the openDate(when the ticket was created) and the resolveDate(when the ticket issue was solved) from the database and use this formula - TurnAroundTime = ResolveDate - OpenDate my report UI consist of a texbox where u can search for the ticketID and get the data. the data displayed will be the openDate and the ResolveDate..with this 2 records, i want to get the turnaround time so i have another button which is calculate when i click on calculate i want the system to use the formula to get the TurnAroundTime..so behind my button i have this code:
Code:
Protected Sub btnCalculateTurnArnd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCalculateTurnArnd.Click
Dim clsTickets_Obj As New clsTickets
[Code]...