I have 2 tables Markers and Clients. Within the Marketers table i have Team Leaders as well. I want to print a report that will display a Team Leader and the Marketer with all the Clients for that particular Marketer, and then do that for all the Marketers under that Team Leader.
[Code]...
I have a list of postcodes in a query (ThisInstructorsPostcodes) and another query that pulls back sales referrals (LastWeeksReferrals)I am using the below syntax to perform the linq equivalent of LEFT OUTER JOIN so I always get a postcode back, even if there were no referrals for it.
dim final = from tip in ThisInstructorsPostcodes _
group join lwr in LastWeeksReferrals on tip.PostcodeID equals lwr.PostcodeID Into lwrgrp = group _
from lwrgrpq in lwrgrp.DefaultIfEmpty _[code].....
The results I am getting are so close to what I need, but I am getting a bunch of InstructorReferrals objects in the lwrgrpq column and what I want to do is simple sum of the all the 'Referrals' integers in those InstructorReferrals objects.I thought this would work:
dim final = from tip in ThisInstructorsPostcodes _
group join lwr in LastWeeksReferrals on tip.PostcodeID equals lwr.PostcodeID Into lwrgrp = group _
from lwrgrpq in lwrgrp.DefaultIfEmpty _
select new with {tip.AreaDistrict, lwrgrpq.Sum(function(x) x.Referrals) }
...but it doesn't - fails with the error: Anonymous type member name can be inferred only from a simple or qualified name with no arguments.I have only used this linq query structure in order to mimic the outer join behaviour of sql, does anyone know how I can fix this so that my grouped items are not anonymous types?
I am frustrated with this. Please help. I wanna do it like this:=Iif((Fields!Qty.Value * Fields!UnitCost.Value) + Val(reportitems!txtTUC.Value) = 0.00, "-", (Fields!Qty.Value * Fields!UnitCost.Value) + Val(reportitems!txtTUC.Value))
Is it invalid to multiply different types of item? if so, how can I make it? I just want to get the sum of (UnitCost * Quantity) to be the value of txtTUC.
[Code]...
I 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 Repliesin my app, I want to use reports. It's a long time ago, when I created my first report and that was in vb6. Now, I would like to use the report viewer control and the reports, created in vb.net. I use postgresql database with an ado.net connector (also I have dataadapters, datasets, datareaders, etc). I created a form and placed a report viewer on it and I added to my project the first empty report too.
[Code]...
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 created reports that print on my printer via Visual Studio 2008/VB 2008 Basic code. I want to be able to send these reports to other people via emai. I don't care how its done, but it seems that if I could get the report into Word 2007 the problem would be solved. What are your suggestions to accomplish my objective.Terry 01
View 1 RepliesIam workin wid crystal reports have a problem i jus want to create a crystal report dynamically not by using crystal report wizard rather by using a blank crystal report and connecting to the database server and generating the report from the database manually....
View 1 Repliesshowing multiple items from listview to my crystal report. Or something like after searching some items, the results are the one to be displayed in crystal report. I don't have any codes yet. I'm using OLE DB Connection.
View 3 RepliesI have a simple VB.NET 2008 app that users to edit fields in the database. Simple enough as a first "real" project in .NET, right?For one table, I am currently using a DataGridView so it can be edited straight up. However, instead of offering the user the entire table, I'd like to group the data by the 'CompanyNumber' column and use a navigator to page through. In other words, I'd like the DataGridView to show me all the lines related to one company, then click the "next" arrow to show the next company, etc.
View 2 RepliesI'm having trouble with a LINQ to SQL query getting the min value using Visual Basic. Here's the SQL:
SELECT RC.AssetID, MIN(RC.RecCode) AS RecCode, JA.EngineerNote from JobAssetRecCode RC
JOIN JobAssets JA ON JA.AssetID = RC.AssetID AND JA.JobID = RC.JobID
WHERE RC.InspState = 2 AND RC.RecCode > 0
[code]....
I'm trying to create a program that displays a calculation based on which radio buttons a user clicks on. I'm not getting any errors during writing or run-time, however only one particular calculation ever gets displayed. I'm not sure why, but it's as if I've gotten the program stuck on the section below. The Calories Label only displays the number 12 regardless of anything else being enabled.
weight = Val(WeightTextBox.Text)
activemale = weight * 15
inactivemale = weight * 13
[Code].....
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 have this dictionary..
Dim Rooms As New Dictionary(Of Integer, Of Integer)
Rooms(1) = 101, 102, 109, 110
Rooms(2) = 103, 104, 105
Rooms(3) = 106, 107
I want to know if i can obtain how many keys are in the dictionary For example, in this dictionary i have 3 keys, and if i use Rooms.Count it returns me 9 thats each pair of keys-values, but i want to obtain 3, each diferent value as key.
EDIT: Sintax error P.D: I cant use now because i have to use in a webservice filtered by IP, but VS2010 if i use count on the dictionary, tells me that will contain the number of the keys/value pairs.
I have this dictionary..
Dim Rooms As New Dictionary(Of Integer, Of Integer)
Rooms(1) = 101, 102, 109, 110
Rooms(2) = 103, 104, 105
Rooms(3) = 106, 107
I want to know if I can obtain how many keys are in the dictionary. For example, in this dictionary i have 3 keys, and if I use Rooms.Count it returns me 9 that's each pair of keys-values, but I want to obtain 3, each different value as key. Syntax error. I cant use now because I have to use in a webservice filtered by IP, but VS2010 if I use count on the dictionary, tells me that will contain the number of the keys/value pairs.
I need to sort my records by date (month & year) as displayed on my asp.net page; This is the code I currently have
<table width="40%" border="0" style="margin-left:auto; margin-right:auto;">
<tr><td><asp:Label ID="lblGridHeader" CssClass="TextFont" Text="" runat="server"></asp:Label></td></tr>
<tr>
[code]....
Given a simple DTO (AccountExpiry) with properties of 'AccountNo' and 'ExpiryDate' and a List of same created thus:
New AccountExpiry(123, New Date(2012, 4, 1))
New AccountExpiry(123, New Date(2012, 4, 2))
New AccountExpiry(123, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 2))
New AccountExpiry(124, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 4))
How do I use LINQ to retrieve the most recent entry per account. I have a feeling this will involve GroupBy and FirstOrDefault. It seems like...
From Item In Source Group By Item.AccountNo Into Group
Should return all of the data grouped appropriately, but It is unclear how I might apply .FirstOrDefault to each group.
I'm trying to do the following LINQ grouping, which works in the debugger (the results are populated in the GroupedOrders object. But VS 2008 gives me the following error at design time...
Name 'x' is not declared
Dim GroupedOrders = (From m In thisConsultant.orders _
Group m By Key = m.commCode Into Group _
[code]....
I am doing a little program that writes to an excel file then it prints the worksheet out using
WorkSheet.PrintOutEx()
this does print out fine but i now need to select a printer before it actually prints out. How can i do this?
I found out how to keep track of the currently expanded grouped rows by using 2 events:
- gridview.GroupRowExpanded
- gridview.GroupRowCollapsed
Where I increase or decrement an integer that keeps track of how many group rows are currently expanded. I am now tackling the problem of what to do if the user expands or collapses all of the group rows. I currently know when this is done by checking the e.RowHandle. Any way to find the total number of groups rows currently in the GridView (something like rowcount for normal rows) so I know how many to set the tracking integer to.
For Example: If my current count is 2 and the total number of groups are 15 then when the Expand All is fired the current count is set to 15 rather than 3.
I want to create an application where it capable to print a report like we normally do in word and save it in the pdf format. But the problem is i dont know how to create the report. I dont have crystal report or crystal report template in my Visual Basic 2005.
View 3 RepliesI have a listbox that prints 2 different values each line. The first one is String and the second one is an Integer, (although I've converted it to String). How do I extract the first String value? One is suposed to be able to mark one line, and remove the selected lines values from 2 different arrays, and for that I need the String value.
View 2 RepliesPrivate Sub btnPrint_Click(sender As System.Object, e As System.EventArgs) Handles btnPrint.Click
Dim PrintPreviewDialog1 As New PrintPreviewDialog()
[Code]...
Document1 is 3 pages long. When print preview comes up, it shows all 3 pages like it should. However, when I push the print icon on the print preview form it only prints the last page.
I have tried to create an amortization program The issue that I am having is that the program wants to print the same page over and over again. The first page of the printout runs through the "While loop" appropriately, but when the second page starts printing, it repeats the information that is on the first page. This is true of all subsequent pages I have included the printing portion of the code.
Private Sub cmdPrint_Click(ByValSystem.Object,System.EventArgs) Handles cmdPrint.Click 'Defines printed page
[code].....
Is there any unique computer ID that distinguishes a computer from other, like finger prints for human?
View 2 RepliesI have noticed that when I use drawstring to only print numbers, it just prints nothing. However if I put a letter in the string, it prints.
[Code]...
I have written a VB.NET program to open a word document and generate a .TIF file by printing it using the MODI printer. Usually the documents print fine. But, sometimes it appears as though all of the letters on each line are printed on top of each other which produces little square "blobs".[code]
View 1 Repliesi have a Janus grid, which has two columns and the rows are organized in a hierarchical order i.e. parent and child rows. One of the columns in the grid is grouped (by dragging the column in the group by box above the grid). I have a cell-changed event that is fired when a cell content is changed. I do this in the cell-changed event:[code]If i change the value, in a parent row, of the grouped column then the child rows are set to Nothing. After the last line in the above snippet, child rows of row are set to Nothing. On the other hand, this problem does not occur if i change the value of the other column (which is not in the group by box). The problem occurs only if i group a column and change its value not otherwise.
View 1 Replies