|
hi,
how to add two different parameter field(two diff table) in crystal report?
Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
Mail To : foreverkans@gmail.com
|
|
|
|
|
Are you asking how to pass in a parameter into a crystal report (in the .vb code)?
If so, it would be something like this:
ReportDocument1.SetParameterValue("MyParmName", "MyParmValue")
Or are you asking how to setup the parameter in the crystal report document itself (the .rpt file)?
If so, in the field explorer right click on parameter fields and then click new. Give your parm a name and data type.
Or are you asking how to input more than one table? A table isn't a parameter. If you want more than one table you have to put the tables into a DataSet object and pass the DataSet object in as the DataSource.
Hope this helps.
|
|
|
|
|
ya im asking about 3rd one...
Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
Mail To : foreverkans@gmail.com
|
|
|
|
|
Do you still have a question or have you figured it out? The basic format is something like this:
Dim dtTable1 as New DataTable
Dim dtTable2 as New DataTable
<Insert code to set schema and fill the data tables here>
'This code declares a dataset and adds the tables:
Dim ds as New DataSet
ds.Tables.Add(dtTable1)
ds.Tables.Add(dtTable2)
'This code attaches the dataset to the crystal report:
reportDocument1.SetDataSource(ds)
|
|
|
|
|
sorry im new in crystal report..
plz write step by step...
Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
Mail To : foreverkans@gmail.com
|
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
