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).
I 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 am working on a 1-page report, that basically consists to select 1 record from table and bind values to proper fields (eg. =Fields!name.Value).However, I have one field in the table that will be just "Y" or "N".When this field will be "Y" I would like to show in the report "Yes, I do."; otherwise I would like to show "No, I dont."
View 1 RepliesI wrote some code to update the count of a field in a table, but it is very slow. So I'm trying to do it in a subquery to speed things up, but I'm not very good with subqueries. I'm getting the error "Subquery returned more than 1 value".
[Code]...
i have data coming from sql server with two columns like total items, total packed items. Now in datagridview i want to show another column to calculate %age.Total Packed Items / Total Items Is it possible to add calculated column in datagridview?
View 4 RepliesI have a DataGridView that call a stored procedure. One of the fields is a calculated field, ie Quantity * Price.When I run the stored proc on the server, the calculated field returns a result that shows 2 decimal places to the right of the decimal point. When I run the stored proc in the VB application to fill the DGV, the result in the calculated field shows up to 8 places to the right of the decimal place. Is there a way that it will show only 2 places in the application?
View 3 Repliesi am semester 2 in the "system information", as usual just like in semester 1, this hardcore lecturer just has some way to make us difficult he is giving us a one semester long assignment, and as you probably can see.i got mysql as my database to making a hotel system application.
1.now i am stuck with how to connect "crystal report" with mysql database table??
2.after connected, how shoud i display it?.
I have a gridview that displays a calculated field, based on a db source field it populates with.
can i sort by it? i can't seem to figure out how to do it?
example:
my templatefield looks like this:
<asp:TemplateField HeaderText="Category" SortExpression="category" >
<ItemTemplate>
<asp:Label runat="server" Text='<%# BuildCategory(DataBinder.Eval(Container, "DataItem.category")) %>'
ID="lblPrice"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
where category is party of the datasource, but what gets displayed is a calculated value - which is different from the category.what can i put in the "SOrtExpression" to make it sort by the new value - taht gets displayed?
How to check if string entered in a text box matches a field in a data table.I have a form with two text boxes for users to enter their Username and Password. When they enter their details and click the 'Login' button I want their details to be checked against data in a data table to see if they match or not. I am using an 'if...else' statement but can't work out the syntax to use. My code is as follows:[code]The fields I want to match the textbox strings against in my database table are called 'Username' and 'Password'.
View 2 RepliesWe are using Reporting Services to generate a purchase order, which is rendered as pdf before displaying on the screen. The report works well, as is, except that now we have to add a Terms & Conditions page to every PO. I've tried placing it in the footer, setting it to display only on the last page--this didn't work. I've also tried adding it to the body, setting the "Page Break Before" property to "true". This works, except that it looks like there is still space reserved for the header (i.e. the header's "show on last page" property is set to false). I can't get the Terms & conditions to fill the page. how I could attach or bind the pdf generated by reporting services with a pdf version of the Terms & Conditions sheet?
Note: We are using ASP & VB.NET 2.0, Visual Studio 2005, & SQL Server 2005.
I am building a data based application using VB 2008 an SQL Express. I need to create textboxes on my form using code, (With & End With) method. I need a simple code string that will allow the app to check if the field to wich the textbox wil be databound is Nul, If so the textbox will not be created.
View 8 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 am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
These things look about the same to me. Is there any reason I should use one over the other?
View 5 RepliesI want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
I have a query that I have to run that requires me to get rows from a table based on the value of a field in another table (which I have gotten earlier). I currently have it done like this (simplified).
[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].....
I have a form in whcih users will be able to select the required field that has to be printed.. can u tell me how to add field in CR at runtime ?
View 1 RepliesI am using VB 2005 pro and sql 2005 express.I have a form linked to a sql database. and linked a sql field to a textbox. All I get when the program is running is what is in the database displayed.
But what I would like to do is take a value from a textbox and add that to the chosen field database.
I am a beginner and looking for simple 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 have developed a windows database application in vb.net 2008 express and sql express 2008. Is there a way to create reports in the application?
View 7 RepliesFinally I can create a report using the crystal report viewer.How can I add a parameter or base a report on a query.
View 3 RepliesI've placed this on a VB2008 project but it's telling me adNumeric,adVarChar & adBoolean are not declared, I'm assuming I need to "DIM" them, but what as? plus I need each field to accept NULL values, how do I do this? Also I'd like to add a field for accepting images.
Code:
Dim cat As New Catalog()
Dim col1 As New ADOX.Column
Dim col2 As New ADOX.Column
Dim col3 As New ADOX.Column
[code]....
This error has me completely baffled. There is no indication (that I ca FinD as to what field won't handle the information. Heres the situation:I am using an Accees query to insert a new record in a table with 49 fields. Of these fields, 1 is an integer, 7 are booleans and the other 41 are text fields. The text fields represent either Time of Day or a Timespan.
My field sizes are:
For time of day 8 digits(example 08:00 AM)
For a time span 5 digits(example 03:30) I will never exceed 2 digits for
hours
I have checked every field in the dtatbase and they are all as noted. I am at a loss as to how to proceed.
I have an open database (dataset) with two tables. It is binded to toolboxes, but I have one field, what I have to calculate about other parameters. I have binding navigator, and I can set field values from controls (eg. toolbox). I can step my rows, with binding navigator. I can update my database. But how can I set field value from code?
I want a code line:
database.fields("fieldname") = something - or something like this
Rather than running numerous queries in Access I am trying to write a front end for a DB2 database. The Access database is getting to a size that it is causing Access 2007 to have reliability issues and frequent compacting is required. I have created the Dataset, the Table Adaptors, and the Connection String already, but when I put in a bit of code in to fill the Table Adaptors the remote connection I have to work is going crazy (chewed up about 180MB before I realised it was pulling data from work).
Before I started the project I copied the .accdb to my local PC HDD and I pointed the connection string to it, but it still looks like it is trying to pull data from the work network. If it was a small database I wouldnt be concerned but it is pulling major data every time I run it. I have only 2 out of the 4 Table Adaptors running and it didnt fill them even after 10 minutes.
Here is the code I was trying to run... Server name has been substituted for Server for obvious work reasons.
Because the tables are so large I was looking for a way to pull only the columns I need to from the tables, I tried adding .SOFT_ID to the first line of code but the TA spat the dummy message below...
Value of type 'System.Data.DataColumn' cannot be converted to Application_Name.DS_DB2Database.Server_SOFTDataTable'.
Code:
Me.TA_ServerSOFT.Fill(Me.DS_DB2Database.ServerSOFT.SOFT_ID)
Me.TA_ServerSOFT_FOUND.Fill(Me.DS_DB2Database.ServerSOFT_FOUND)
Me.TA_ServerHARD.Fill(Me.DS_DB2Database.ServerHARD)
Me.TA_ServerREF_SUP.Fill(Me.DS_DB2Database.ServerREF_SUP)
I would also like to pull just the data columns I need to speed up the query.
Note: In case youre wondering why I am not connecting directly to the DB2 database. I currently dont know where it is stored and while leveraging Access I am trying to put a level of separation between the app and the db for the time being, later I will try connect directly.
I added a parameter to the rdlc called paramTitleThen I tried this as a demo
Code:
Dim params(0) As Microsoft.Reporting.WinForms.ReportParameter
[code]....
This is my current code.
Code:
Set rs = cn.Execute("SELECT * FROM customer WHERE VsVslNo LIKE 'V16'")
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
[CODE]...
I have an applciation in VB.NET but when I try to produce the reports a popup message appears requiring login information.
I have attache the print screen of the popup message.