Visual Basic

15-Jun-09 1:44

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

Kschuler15-Jun-09 8:55

15-Jun-09 8:55

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.

JC.KaNNaN16-Jun-09 1:20

16-Jun-09 1:20

ya im asking about 3rd one...

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Kschuler16-Jun-09 2:41

16-Jun-09 2:41

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)

JC.KaNNaN16-Jun-09 3:38

16-Jun-09 3:38

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

Kschuler16-Jun-09 3:47

16-Jun-09 3:47

I'm not sure how much more step by step I can get than what I wrote before. Why don't you try reading some articles on the subject to get familiar with the concepts and then play with it a bit.

Here are a few articles I found on CP that might help you:
How to use Crystal Report in your project?[^]
Generate a Crystal Reports report without a database[^]
Crystal Report Basics and Integration with DataSet[^]

Hope this helps.

JC.KaNNaN16-Jun-09 20:29

16-Jun-09 20:29

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

Kschuler17-Jun-09 3:00

17-Jun-09 3:00

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.

Visual Basic Multilingual Support - Picking Desired Resource

Aiman Farouk Mohamed15-Jun-09 22:07

Aiman Farouk Mohamed

15-Jun-09 22:07

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

vhassan15-Jun-09 1:32

vhassan

15-Jun-09 1:32

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.

Re: Visual Basic Multilingual Support - Picking Desired Resource

Baran M15-Jun-09 4:35

Baran M

15-Jun-09 4:35

try this [^]

You are best person who knows about your problem.
-------------------------------------------------
More pain more gain

Datarepater Control (Winforms)

Alan Bates15-Jun-09 1:20

Alan Bates

15-Jun-09 1:20

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 Confused | :confused:

DataGridView how to get items

alwinSCH15-Jun-09 0:31

alwinSCH

15-Jun-09 0:31

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.

Re: DataGridView how to get items

Henry Minute15-Jun-09 0:39

Henry Minute

15-Jun-09 0:39

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.”

How to deploy dll before custom action

Mithun.Shitole14-Jun-09 23:58

Mithun.Shitole

14-Jun-09 23:58

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.

Re: How to deploy dll before custom action

Kschuler15-Jun-09 9:00