How to send Multiple values for one formula field in crystal reports through vb.net? - Visual Basic Discussion Boards

Hi,
could you provide more info.... whats you code like?

thanks
Anoop

Anoop Brijmohun wrote:
could you provide more info.... whats you code like?

Gosh - you're as bad as the first guy. His code is irrelevant. He doesn't have SQL Server installed.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

What database are you trying to connect to?

ive got 2007 and 2003 access files
non of them work
when i try to connect using connectionstring i recieve a message box with no message in it!!! and only one ok button!!

Member 4262317 wrote:
and only one ok button!!

Well, one should be enough. Poke tongue | ;-P

"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)

Well, here's some info that would have been useful hours ago. Why mention SQL Server at all, if you're not using it ?

What is the connection string you're using ? Can you open the DB using Access on this machine ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

You will need to post the connection string you are using so that we can see if the problem lies there...

Hai All,

Im creating 2 formula fields in my crystal reports for displaying empname and salary like this,

abc 100
xyz 200
pqr 300
in code behind im passing values to crystal report like this,
vb.net code
j=0
for i=0 to noof emps
rptDocument.DataDefinition.FormulaFields(j).Text = ds.Tables(0).Rows(i).Item(i)
j=j+1
next
It is printing only

pqr 300
ie, It is over writing every time and im getting only last record how to get all emp records at a time..?

Thanks,
Aswath.

Thanks,
Aswath

Hai,

Any Answer to my problem..........?

Thanks,
Aswath

To a new (VB.NET 2005) version of my application WDS I would like to add a "direct recording to MP3" feature.

WDS is about talking digital books, please see www.wds-books.com for the old VB6 version.

I looked at several commercial controls (Active Audio Record, Alvas Audio a.o.), but these seem to heavy and I fear distribution problems (dll's, regsrvr).

All I need is a simple micro to mp3-file recording feature, no choice of device or quality is necessary. Just something like:

RecordStart(filename), RecordPause(), RecordResume() and RecordStop().

Has somebody developed anything similar, or give me some hints on where to find info?

Thanks in advance for your kind reaction.

Fred Worms

There's no mp3 encoding built into .NET, so you need an extra component to do the encoding for you. Then, if you want to do it yourself, you will need to use DirectX to do it.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Thank you Christian for your quick reply. Vielen Dank.

Extra control: I looked at three of these. Example programs do not work, or work on Vista, crash with XP. I lost lots of time in the past using controls of small firms.
I hoped to get a more detailed reaction from someone experienced in this respect, e.g. from Qualtar, who published an article on a somewhat similar LAME encoder subject.

I would like to address Qualtar directly, however, I have the impression that this is not possible(I know very little about forums).

I do not like at all your attempt to be funny at the end of your reply.

Kind regards,

Fred

Fred Worms

Hi all, i want to ask a question about datareader. I have a user control its inherits ListView. And I have a table has 500000 records. For performance fill the listview, when form_load i fill first 20 records. When user click scroll down add to 21 record. Every click add to next record. How can i do this with DataReader. And how can i hand event to scroll click. Please help me. My code below;

User Control ;
Dim x As Integer
Dim dbConn As New SqlConnection("server=" + _ServerName + ";database=" + _DatabaseName + ";uid=" + _UserName + ";pwd=" + _PassWord)
Dim strQuery As String = "SELECT * FROM ListeKontrol"
dbConn.Open()
Dim myCommand As New SqlCommand(strQuery, dbConn)
Dim myReader As SqlDataReader = myCommand.ExecuteReader()
While myReader.Read And x < 20
MyBase.Items.Add("")
MyBase.Items(x).SubItems(0).Text = x.ToString
MyBase.Items(x).SubItems.Add("ListeAck")
MyBase.Items(x).SubItems.Add("Alan1")
MyBase.Items(x).SubItems.Add("Alan2")
x = x + 1
End While

S.A.A

cmpe orko wrote:
"SELECT * FROM ListeKontrol"

This is the wrong way to go about it. If you have 500 thousand records, you need to think about it a little more than this. Your best bet is to write a stored proc that takes a page number and a number of records per page, and request the page you need every time. A dataset that you bind to makes more sense than using a loop and a datareader.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Thanks my friend, but i don't understand clearly. How get page number or some range of records with stored proc. Can I get some row index with sql.

S.A.A

Yes, you can get a row index, if you have an identity column and you don't delete records, you can use that.

http://blogs.x2line.com/al/archive/2004/05/29/325.aspx[^] was my first google hit

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Thank you my friend.

S.A.A

I have created a form and i have added a label,the label is supposed to be template in which 99 new labels would be generated,at the moment i can only generate one label clone of the label template.here is the code

Private Sub frmBackTrack_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
obj = New Labels2
'instantiate new checkbox class
Dim MyLabel As New Labels
'assigning the properties of the new object
With MyLabel
.Text = ("Label2")
.Left = Label1.Left
.Top = Label1.Top + Label1.Height
.Size = Label1.Size
'.BackColor = Color.Azure
End With
'adding checkbox control to the form
Me.FlowLayoutPanel1.Controls.Add(MyLabel)

End Sub
please assist me to generate the other labels

I'm not sure what you need here, except to suggest you look into for loops. You really should buy a beginners book and work through it, the concetp of a loop is pretty starting level.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

hai friends

to store a key in windows rwgistry

that too in "HKEY_CURRENT_USER"

i used the following code.....

Application.UserAppDataRegistry.CreateSubKey("Software\Microsoft\Keyname")

oke its working..

but the key is storing along my application details..

say my application name:appxyz
company name: compxyz
Version :1.0.0.0
first it is creating a key with company name
and within company name... the sub key is ...version

then with in version .... it is creating .... software\microsoft\keyname..

i dont want to happen this....
by any one can find out the key...
bcoz they know my company name...
they will search for it in registry
and looks for the data...

my requirement is like this ...
i want to create a key(s) in "Hkey_Current_User"
but in differnet places...

plz help me...

thanks in advance
bye

vijay
devulapally_vijay@yahoo.co.in

What you want to do is nasty, you should put the keys where people can find them, but I get why you'd want to hide stuff, for security, etc. Get rid of the Application. stuff and use the raw APIs that allow you to access the registry where-ever you like. There's tons of articles here and on google.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Use the Registry classes instead of the Application shortcuts. This will give you much greater control over what you need to do.

Documentation on the Registry class[^] on MSDN.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

I have a table with long columns header .
I must show columns in 2 or more lines .
please help me how I can set the janus GridEx column Header wordwrap true .
en.Mahdi

Did it occur to you to ask here[^] ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

it is better that you answer me .
i know you can not answer to me .
jam kon kazo koozato .

is how you replied to me via email. I am replying here so you don't get my email address.

No, I don't know. Nor does anyone else. We don't use this grid. That's why I suggested you ask people who DO use it.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )