|
Hi,
I want to print multiple values in the same Parameter Field of Crystal Report. I fetch data from table in loop and assign it to a Parameter Field. My problem is that it overwrites the last value, I want it to Display as New Value for the same Parameter Field in a new row. I'm writing the sample code below to make it clear.
For count = 0 To 2
crReportDocument.SetParameterValue(0, "Amit" & CStr(count))
crReportDocument.SetParameterValue(1, count)
Next
Now for the Parameter Field 0 and 1, the value printed in report is
Amit 2 2
But I want my output to be
Amit0 0
Amit1 1
Amit2 2
My requirement is such that I cannot bind Crystal Report to a datasource.(pity). I have to define Parameter Field and supply values to them through the code.
An early reply or suggestion will be highly appreciated.
|
|
|
|
|
Hi
I created an application using vb.net,which logs the error in event viewer. This application is working well at XP and windows 2003. But at windows 2000, it is showing error. Can any1 please tell me, what are changes i need to make in the system or code, so as to execute it on windows 2000.
Thanks in advance
Manish
|
|
|
|
|
First, Windows 2000 has to have at least Service Pack 4 installed.
Next, check to make sure that the account your running your app under has sufficient rights to write to the event log.
Lastly, you might want to post the error message your getting when you run your app.
Oh!! There are no changes you have to make to your code, it should work already with no changes.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have given Admin rights to internet user as well as ASPNET user.
I have also made changes in the registry of Event Log so as to allow guest.
Please let me know is there any solution for this.....
Thanks for your reply
Manish
|
|
|
|
|
The problem is, I don't know what you, or someone else, did to break it in the first place! This should be working by default!
Does the NETWORKSERVICE account have rights?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello,
I've created a call reporting app using SQL Express edition as the local data source, and have packaged it up, and deployed it on another machine. Once I installed it on the other machine, the program runs fine, and I can see that my data has populated in some forms.
How do I gain access to those tables? After my app installed, I only see an executeable to launch the program, and cannot locate the tables with data in it anywhere.
Thanks in advance,
Rashar
|
|
|
|
|
Search the drive for *.MDF and *.LDF and you'll find it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Please tell me that How One can rename, copy, delete, move etc a file already stored on one's hard drive by using the Visual Basic Program.
I am using Visual Basic 6.0
Mahtab Masood
|
|
|
|
|
|
Hi,
Can any one of you help me with the problem
I am trying to develop a simple application in Visual Basic using Microsoft Date and Time Picker Control Version 6.0 from the OCX File MSCOMCT2.ocx but after my entire project is ready and Try to run it after a day or two the MSCOMCT2.ocx file disappears from the References.
And have to recreate the entire project again since in references it does not add the msconct2.ocx gives an error Name conflict.
Please can any one help me on this. I have a project dead line to meet
Regards
Dixon
-- modified at 8:24 Thursday 21st September, 2006
|
|
|
|
|
I am creating a file with .ciio extension. Now i want to associate a particular icon with this extension. like other application do (word, pdf etc).
How can i associate an icon with a file type programatically?
|
|
|
|
|
You will have to add that info in the Registry for file association to the Icon
|
|
|
|
|
do u know the registry entries? or do u hav the code sample.
|
|
|
|
|
Some packagers like InstallShield have this ability to association icons to file types built in
Steve Jowett
|
|
|
|
|
Hi All,
I want to modify the app.config file using vb.net(means change the value of key). how to do this?
If you know please tell me.
thanks in advance
chetan
|
|
|
|
|
All you have to do is search the articles and you shall find[^]...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Public Sub ReadMyData(ByVal MyConnString As String)
Dim mySelect As String
Dim MyConnection As New SqlConnection(MyConnString)
Dim myReader As SqlDataReader
Dim myCommand As New SqlCommand(mySelect, MyConnection)
mySelect = "Select * from bobo"
MyConnection.Open()
myReader = myCommand.ExecuteReader()
While myReader.Read()
Console.WriteLine((myReader.GetInt32(0) & "' " & myReader.GetString(1)))
End While
myReader.Close()
MyConnection.Close()
End Sub
The above coding must retrieve and output the data from the database.
I am getting an error on 'myReader = myCommand.ExecuteReader()'
error :" Specified cast is not valid."
Please help
|
|
|
|
|
Lesesi wrote: Dim myCommand As New SqlCommand(mySelect, MyConnection)
mySelect = "Select * from bobo"
These are in the wrong order.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
in a string i need to find a "(quotation mark)and replace it with null
how to do this finding a quotation in a string and replacing
mail me at rajesh.batchu@cesltd.com
|
|
|
|
|
Do you really mean null, or do you just want to remove quotes ? The replace method on the string class will let you do it, just set the second parameter to an empty string ( assuming you don't want to replace with null )
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Ok hi guys.
Noob..
Wrote-up a small database application.
What im trying to do is to get a dropdown box to populate with the data from collum one of my sql database.
Lets say colum one is names , simply i would like to drop down the list of names and have the app collect the info for the name I select from the list.
Any help would be greatly appreciated.
|
|
|
|
|
Do a query to return that list, and make the return value the data source for your combo box.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks that makes sense but ,
When I try to add a new query it returns and error that the schema for the new does not match the one of the base query.
As i said im new so , I have no idea what that means.
I created the example query but it doesnt appear on the list of Data Sources.
|
|
|
|
|
OK - it sounds like you're at the mercy of the wizards. I have no idea how they work, I tend to write my SQL directly. Perhaps if you post the code, someone can help you ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi all,
I've been getting a strange problem with anchoring on my forms. I have a form where I put on a tabControl. I set it's anchoring to Top, Bottom, Left, Right. I put a number of tabPages on to the control. On the first tab I put textBoxes and comboBoxes. I set all their widths to 655 and their anchoring to Top, Left, Right.
When I run the app, the form appears and all the textboxes and comboBoxes have truncated from the right, the left hand side is fine. When I go back to designer it's truncated as well. The more I run it the more truncated it gets.
Has anyone else had this issue?
Thanks in advance for any help,
Dave
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
