|
Hello !
i have a project with VB.net 2010 / Entity framework 4. How can i create a crystal report that include columns from different tables.
Table1 Table2
id1 id2
name value
city date
id1
i want to display on report : value date Name
i can make the query to get records that i need to display on report ,
with report wizard , i have created the crystal report ( CrystalReport1.rpt ) with fields from both 2 tables : value date name.
Now , this is my code :
---------------------------------------------------------------------
Dim report As New ReportDocument
report.Load("c:\Crystalreport1.rpt" )
Dim context As New myEntities
Dim query = From t In context.table2 where ....conditions
Select select t1.value , t1.date , t1.table1.name
report.SetDataSource(query.ToList)
Form1.CrystalReportViewer1.ReportSource = report
------------------------------------------------------------------------------
when the report is open , the columns value and date are filled with values , but the column name is empty.
What can i do ?
thank you.
|
|
|
|
|
You can use joins to retrieving values from both tables.
Why to worry when we have powerful joins in hand
|
|
|
|
|
i dont have problem to get records , i have problems to display data in report
|
|
|
|
|
Hi,
This is my very first post on here - so hello!
I graduated in 2007 with a 3rd class degree (I know, a poor result) in Computer Science. On friday, I have my first ever interview for a VB software developer position (I spent some time travelling after graduating, then did a teacher training course which lasted 2 years). I've tried to make up for the fact its a while since I graduated by reading up on programmings languages and practicing in my own time because I have forgotten a lot of it.
Any pointers with what I can expect in the interview? Will it just be the usual questions (why do I want to work for them, what are my strengths/weaknesses etc...) or am I likely to be tested on my knowledge of programming (e.g. what is a method? How would you code this?).
Knowledge of SQLServer is required too. I've only used MySQL - will SQLServer be easy to pick up or is it completely different?
Although its my first interview for a software developer job, I've had interviews for other jobs (mostly teaching). This is my 16th interview since June so I'm very nervous!
Appreciate any help or pointers. Thank you.
|
|
|
|
|
It's almost impossible to guess what questions you may get asked, as it all depends on the job description and the person doing the interviewing. I would prepare by doing some research into the company that is offering the post so you can answer some sensible questions about why you want to work there and where you see yourself in 2, 5, etc. years. Also make sure you are up to date with your VB knowledge and how it is used in whatever areas the developer job is targetted at. Dress smartly, act interested and above all, be honest and prepared to learn from the experience.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
I echo what Richard has stated. Another thing is continue to pursue learning. Such as myself with many years of coding experience I don't admit that I know everything, but I am willing to learn everything by studying new things often. (Not to sound like a suck up, but this site has some really good articles to improve your coding. Hence, why many developers visit this site so often.)
One final advice I would like to leave you with that would apply to any field is... know yourself. Be confident in who you are and everything else will fall into place.
My 2 cents. Go show them what you are made of! 
|
|
|
|
|
Depends on the interviewer.
If it is someone within the profession then they will probably ask some pertinent and salient questions, if it is a Human Racehorses flunky then probably just the usual old guff will come up.
Just be confident and positive and show a willingness to work, that is usually enough.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
Hi,
After tested with ComboBox, TextBox, Button as DataGrid child controls (Using DataGrid1.Controls.Add), I found that when all arrow keys pressed were capture by the DataGrid. I.e.:
- When I click on the ComboBox and then use the arrow (Up or Down) keys to move through the ComboBox items, the DataGrid1 handles it and I cannot move in the ComboBox, the ComboBox close its drop-down list, lost focus. Additionally, the DataGrid move to another item of its
- When set focus on the button or text box and then use the arrow keys, the same as above happened
I don't know why. I just want to know why, the root cause. Are there any formal documents said that, please show me.
Thanks in advance!
|
|
|
|
|
the problem is, i'm using DevExpress component and i'm trying to change column time format from 08:16:23.1408999 into 08:16:23.
i changed the format string into HH:mm:ss and format type into datetime but seven digit from the back isn't dissappear.
any idea?
|
|
|
|
|
Give this a shot and let me know if this works for you.
Date.Now.ToString("hh:mm:ss")
By the way I think the string format is case sensitive. Not a 100% sure on that, but when I tried "HH:MM:SS" it gave me the correct values except for the seconds which came back as "SS" instead of an actual number. Once I put the format in lower case it worked just fine.
Look at the Date Time example code from MSDN.
|
|
|
|
|
it is entirely case-sensitive.
Examples: MM is a month number, mm is a minute count, HH is hours in 24 hour format, hh is in 12-hour format.
MSDN holds all the details.
|
|
|
|
|
Thanks Luc for that clarification! I knew there was something I was missing.
That makes sense now.
|
|
|
|
|
You're welcome.
|
|
|
|
|
Hello !
in vb.net 2010 what references should add on my project , to work with crystal report ?
and what should i import on my form ?
i try to add all references with name starting with " CrystalDecisions....." , but when i try to use import on my form like this :
imports CrystalDecisions.CrystalReports.Engine
imports CrystalDecisions.Shared
imports CrystalDecisions.Windows.Forms
imports CrystalDecisions.ReportSource
i get error on all imports lines : " Namespace or type specified on imports doesn;t contain any public memeber and cannot be found"
what can i do ?
thank you.
|
|
|
|
|
|
Hi,
I need to know how to run an application from a central location?
Thanks and Regards
|
|
|
|
|
Double-click its icon?? Seriously, that's not enough information to go on.
Are you asking how to install it to a network share? How to share files the app needs? ...? ...?
|
|
|
|
|
1) Install software in server : (C:\Program files\MyApp)
2) Share that (C:\Program files\MyApp)
3) Browse that (C:\Program files\MyApp) from client machine
4) Right click on App Icon and click on "Send to Desktop"
5) It will create shortcut on client desktop
6) Run that shortcut.
Make sure that if you are using any database connection then it should connect using IP of Server instead of "local"
Thanks
Dr.Kitanjal
|
|
|
|
|
I have assigned my combo box with the information needed but my code to calculate is not working my button need to compute the total of runners that is added from my .txt, the average age of the runners and the total funds raised. Help would greatly be appreciated, I have been going at this all week, Let me know if you need more info.
Public Class frmContributions
'Class Level Private variables
Private _intLifeOfItems As Integer = 5
Public Shared _intSizeOfArray As Integer = 21
Public Shared _strInventoryItems(_intSizeOfArray) As String
Private _strName(_intSizeOfArray) As String
Private _decAmountRaised(_intSizeOfArray) As Decimal
Private _intAge(_intSizeOfArray) As Integer
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'The Form1 load event reads the inventory text file and fills the Combobox object with the
'inventory items
Dim objReader As IO.StreamReader
Dim strLocationAndNameOfFile As String = "e:\earthdayrun.txt"
Dim intCount As Integer = 0
Dim intFill As Integer
Dim strFileError As String = "The file is not available. Restart when the file is available"
'Verify the file exists
If IO.File.Exists(strLocationAndNameOfFile) Then
objReader = IO.File.OpenText(strLocationAndNameOfFile)
'Read the file line by line until the file in completed
Do While objReader.Peek <> -1
_strName(intCount) = objReader.ReadLine()
_intAge(intCount) = CInt(objReader.ReadLine())
_decAmountRaised(intCount) = Convert.ToDecimal(objReader.ReadLine())
intCount += 1
Loop
objReader.Close()
For intFill = 0 To (_strName.Length - 1)
lstRunners.Items.Add(_strName(intFill))
Next
Else
MsgBox(strFileError, , "Error")
End If
End Sub
Private Sub btnCompute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCompute.Click
'The btnCompute click event calls the contribution Sub procedures
Dim intCountOfRunners(21) As Integer
Dim intFundsRaised() As Integer = {175.5, 534.0, 1023.0, 655.5, 178.0, 633.0, 135.0,
178.5, 500.0, 122.0, 190.25, 16.0, 721.0, 463.0, 15.0, 189.0, 78.0, 0.0,
602.0, 10.0}
Dim intAges As Integer
Dim intAdd As Integer
Dim intTotal As Integer
Dim decRunners As Decimal
For intAges = 0 To (intCountOfRunners.Length - 1)
intTotal += intCountOfRunners(intAges)
Next
For Each decRunners In intCountOfRunners
lstRunners.Items.Add(decRunners.ToString("C"))
Next
lblCountOfRunners.Text = intTotal.ToString("C2")
lblTotal.Text = (intTotal / intCountOfRunners.Length).ToString("C2")
|
|
|
|
|
First of all, please enclose your code samples in pre tags. This will make your questions much easier to read.
I think this is your problem...
Member 8479418 wrote: Dim intFundsRaised() As Integer = {175.5, 534.0, 1023.0, 655.5, 178.0, 633.0, 135.0,
178.5, 500.0, 122.0, 190.25, 16.0, 721.0, 463.0, 15.0, 189.0, 78.0, 0.0,
602.0, 10.0}
Try changing the Integer type to Double
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Thanks Andy,
I tried doubles but it did not work, the results reading 0
|
|
|
|
|
Try setting a breakpoint in the code at the place I suggested. Press F5 and the program will stop at the breakpoint.
You will then be able to inspect the values of your variables and track down where the issue is.
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Hi,
I am trying to fill the gridview with the data from an Access table for a range of dates.
Dim cmd1 As String = "Select * from " & inpTable & " Where mdateTime = '29/09/2011'"
MsgBox("cmd= " & cmd1)
Dim da As OleDbDataAdapter
Try
da = New OleDbDataAdapter(cmd1, myConnection)
Catch ex As Exception ' Catch the error.
MsgBox(ex.ToString) ' Show friendly error message.
End Try
Try
Dim table As New DataTable
da.Fill(table)
DataGridView1.DataSource = table
Catch ex As Exception
MsgBox(ex.ToString)
End Try
myConnection.Close()
Command as it appears in the MsgBox
Select * from rawClimateData Where mdateTime > 30/09/2011 10:45:00 AM
The query works if I am not filtering the data base; however, with filter I get the syntax error "missing operator".
Any suggestion??
|
|
|
|
|
dates are in "sqldateformat"
#mm-dd-yyyy#
Jan
|
|
|
|
|
Rewrite this as a parameterized query and you won't have to worry about what "format" the datetime objects are in.
Just Google for ".NET Sql parameterized query" and you'll find tons of exampels.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
