|
hi,
i know what u said..
but i need solution for only using morethan one tables in crystal report..
and
how to pass two different parameter field(ie. two diff table) in crystal report..
still now i didnt get anything...
very urgent..
plz
Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
Mail To : foreverkans@gmail.com
|
|
|
|
|
What I gave you earlier IS the solution for passing more than one table:
In order to pass in two tables, you need to use a DataSet object. This is how you declare one named ds:
Dim ds as New DataSet
Then you have to add your tables to it. If your tables are called dtTable1 and dtTable2, this is how you would add them to the DataSet
ds.Tables.Add(dtTable1)<br />
ds.Tables.Add(dtTable2)
Then you pass the DataSet into the reportDocument object, like this:
reportDocument1.SetDataSource(ds)
If this code isn't working for you, you're going to have to give me more information about why it isn't working and what error messages you are getting.
|
|
|
|
|
Mr. Kannan:
your question is not clear .
Do you want to add these parameters in the report from the crystal report designer or what?
if so, you can do this using field explorer in the left part of the report you will find field explorer and inside it parameter fields right click on it and click new for adding new parameter.
Regards
Aiman Farouk
|
|
|
|
|
Hi everyone!
I have 5 different languages string tables in resource file of my application. Now I want my application to pick my desired string table from resource file. How can I do that?
Thanks.
|
|
|
|
|
try this [^]
You are best person who knows about your problem.
-------------------------------------------------
More pain more gain
|
|
|
|
|
Hi!
I am writing an application in VB.Net (2005) using the datarepeater control in bound mode using the bindingsource/tableadapter scenario. It's working fine but I would like to incorporate a search facility.
I have tried the example from help and this works fine for exact matches but not for partial matches similar to the partial match in SQL using the "LIKE" statement.
The code that I adapted from help is -
strSearch = txtSearch.Text<br />
foundIndex = VwTasCompaniesBindingSource.Find("CompanyName", strSearch)<br />
If foundIndex > -1 Then<br />
DataRepeater1.CurrentItemIndex = foundIndex<br />
Else<br />
MsgBox("Item " & strSearch & " not found.")<br />
End If<br />
I have looked just about everywhere but I cannot find an example of how this could be acheived.
Any help will be appreciated!
Regards,
Alan 
|
|
|
|
|
Hi, i have a question about DataGridView in VS2005!
So i bound my DatagridView with Data through a Stored Procedure in SQL
the last column of my grid is a checkbox!
The user scrolls through the gridview and checks everything he needs...
at the end of my form i have a button, when i click this button
i need the checked rows from the datagridview in my further program!
So i do not need to update my Database or tableAdapter, i only need the rows, which are checked!
Can anybody help me,
don't know where to start and don't do much of programming...
Thanks
A.
|
|
|
|
|
One possibile solution is to use the Rows property of the DataGridview.
Iterate over the collection and test if the column you are interested in is checked and if so, extract what data you need from that row, into a collection or whatever.
Look up the Rows property in MSDN.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
I have created a custom action which requires a reference to a dll say dll1, that dll in turn requires reference to another dll say dll2.
Now I have a deployment issue of how to install dll2 before custom action takes place.
I got the file not found exception for that dll from custom action.
I have tried manually copying dll2 in system32 folder and my installer worked fine.
|
|
|
|
|
any help you want with this issue is entirely dependent on what method you use to deploy your application. What do you use?
|
|
|
|
|
Sorry I forgot to mention, I am using vs 2008 deployment project. I have added a custom action to it. My main project is in vb.net.
Mithun Shitole
"Free Your Mind"
http://www.technoyaari.com
|
|
|
|
|
Hi,
We are looking for a way to order a lot of data the way you can do in Vista Explorer.
It looks like a listview (detail), but you can click the dropdown arrow in the header and you get a few options like Sort, Group, Stack, and have checkboxes to filter.
Since this component already exists in Vista it should be possible to add this to Visual Studio, or am I totally wrong here ?
I've been googling for a while now but am not able to find something like this. I've seen some vista_api libraries but this mostly just changes the looks of the listview to vista, but doesn't add the functionality of the sort, group, stack and filter dropdown in the headers.
Does anybody have an idea ? Or should this be developed in a custom component from scratch ?
|
|
|
|
|
I doubt you'll find this as a seperate component in Vista. There may be third party companies that put out a control like this, but I have no idea if anyone does. The last option is to write it yourself. You may have to also come up with the custom collection to hold the extra data you need for the various display modes you want.
|
|
|
|
|
Okay Thx,
I'll have to do that then.
A bit stupid rebuilding something that already exists.
Robbie.
|
|
|
|
|
Yeah, but it has to exist in a usable form. AFAICT, it's not. There is no COM registration for it, nor a .NET assembly. Without either of those, it's pretty useless.
|
|
|
|
|
I have an application in VB 2005 where in I have a data grid. The datasource of that datagrid is changed frequently. when I minimize the applicaton window, the window is restored as and when the datasource of datagrid changes. What I want to do is that, if I minimize the window then it should not be restored untill I restore it. how to keep the windiw state unchanged untill and unless user dose it.
|
|
|
|
|
I suspect we need to see your code to try to understand why this is happening, I doubt it is just something that happens automatically.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
you are correct Christian Graus. This is happening automatically.I can not put my code here, but I will explain what exactly I have done. I have a button "Get Data" on windows form. I have a list of job codes in by database. On cick of "Get Data" button I am getting data related to those job codes and writing them into an Excel file. Before writing the data into Excel I am displaying it in a datagrid so that user can check the data if he wants. For every record the datasource of the dategrid changes.
When I minimize the window so that this application writes data of all the job codes into excel and I can perform some other task, the window of this application is restored when ever the datasurce of datagrid changes. I want it to run with out restoring the window.
|
|
|
|
|
Well, the obvious thing to do, is check the window state, and not update the datasource if you're minimised. I mean, if the framework is showing the window, and it's not your code, then you need to stop doing the thing that causes the window to be shown. You can update the datasource on the event of the windowstate changing.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
hi,
i am new developer in vb.net.
i have two table one is job,another one is party tables.
job
Id
jobNo
VechNo
joamt
party
id
VechNo
Name
Address
PhoneNo
both table common fields in Vechno.
i will pass both jobno and vechno fields.
when both fields same to display information of two tables to crystal report.
how will get information?
example for single field paramter,
cryRpt.Load(path1 & "\" & REP_NAME & ".rpt")
With crConnectionInfo
.ServerName = path
'.ServerName = path1 & "\SIMdb2003.mdb"
'.DatabaseName = "YOUR DATABASE NAME"
'.UserID = "YOUR DATABASE USERNAME"
'.Password = "YOUR DATABASE PASSWORD"
End With
CrTables = cryRpt.Database.Tables
For Each CrTable In CrTables
crtableLogoninfo = CrTable.LogOnInfo
crtableLogoninfo.ConnectionInfo = crConnectionInfo
CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next
crParameterDiscreteValue.Value = PARAM_NUMBER
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields
crParameterFieldDefinition = crParameterFieldDefinitions.Item(PARAM_NAME)
crParameterValues = crParameterFieldDefinition.CurrentValues
crParameterValues.Clear()
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)
'crystal report viewwr CRV
CRV.ReportSource = cryRpt
CRV.Refresh()
Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
Mail To : foreverkans@gmail.com
|
|
|
|
|
Hi CP ,
I want to handle the Numeric Up / Down events in the printpreview control i wnat to make the viceversa of handling hte pages in Up/ down control . Presently the Up one is used for next page access . I want to make the down button to work in that way .
Is it possible ??
and i am havign 5 pages i want to show the 3 page first and change the page number in Up down control
Is it possible ??
Regards
|
|
|
|
|
There are no such events exposed by the PrintPreviewControl. I think you'd have to create your own version of the control to get what you want.
As for your second requirement, I think you might want to look into the StartPage property of the PrintPreview.
|
|
|
|
|
I've been doing some volunteer work involving bio lab data, and we're trying to convert some old VB 6 code to VB .NET. I'm not very knowledgeable about pre-.NET VB, and the existing project is rather large, with more than 100 modules, most of them around 20kb but some as big as 700kb.
I'm not really at liberty to say anything else that might be used to identify what the project is, so I need to be selective about what source code I share. Some names and parameters below have therefore been changed.
Anyway, I'm trying to use the Visual Studio upgrade wizard, but when I do, it will stop when it gets to parsing the file "PROBLEM.FRM" (it's not really called that) and says "upgrade failed."
If I check the contents of the solution directory, there's just one file - a log. The bottom of it looks like this:
<br />
<File<br />
OldPath = "I:\nmsource\PROBLEM.FRM"<br />
NewPath = "I:\nmsource\nm5.NET\PROBLEM.vb"<br />
FileType = "Form"<br />
Upgraded = "False"<br />
/><br />
<Issue<br />
Type = "Global Error"<br />
Number = "69105"<br />
/><br />
</UpgradeLog><br />
What would be the next thing to do? I've looked at PROBLEM.FRM, and I don't completely understand what it's doing, but I can't see anything obviously wrong with it.
|
|
|
|
|
i_kant_spel wrote: I'm not really at liberty to say anything else that might be used to identify what the project is
Unfortunately, I'm not at liberty to give you the solution to your problem, even though the answer is obvious. 
Not really!
Unless someone else comes along with specific knowledge of this error, I can only suggest that you should, if you have not already done so, peruse the topics under this[^]. Particularly the Upgrading Applications Created in Previous Versions of Visual Basic | Preparing a Visual Basic 6.0 Application for Upgrading article.
Sorry not to be of more help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I've never heard of the problem, and it looks like neither has the rest of the world.
I would start by reading this[^] and reviewing your VB6 code to make the upgrade easier. The upgrade wizard is not perfect, and there is no other tool that will do this for you. So, you have to make it easier for the wizard to do the conversion. There's something in the VB6 code that the wizard cannot handle.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
