Interop problem using Crystal Reports 8 with VB 2005 - Visual Basic Discussion Boards

First Prev Next

Re: VB.Net MDI Child form loading issue...

dan!sh 3-Mar-09 7:04

dan!sh

3-Mar-09 7:04

Double buffering, Suspend and Resume layouts are the option I can suggest. Clever fetching of data might help as well. "When" depends on the functionality of your application. Moreover, if you are using a grid, use Dataset. Using reader wont do any change.

After said all this, wait for other replies. I am not sure if my reply is 100% correct.

Time is the best teacher; unfortunately it kills all of its students.

जय हिंद

Re: VB.Net MDI Child form loading issue...

Navneet Hegde3-Mar-09 10:57

Navneet Hegde

3-Mar-09 10:57

Hi!
On which Event of Form are you fetching the data, Can we Wink | ;)

know that?

Thanks!

Develop2Program & Program2Develop

Re: VB.Net MDI Child form loading issue...

Tej Aj3-Mar-09 20:04

Tej Aj

3-Mar-09 20:04

Thanks for replying,

I am fetching data during form load event.

How to create records that have an AutoNumber field

ivo753-Mar-09 6:21

ivo75

3-Mar-09 6:21

I have a table with 5 columns and one of this column is Autonumber. When I try to insert record give me error. This is my code

strQuery = "insert into rabotnici values(?,?,?,?)"
param1 = New OleDbParameter("@rabotnik_name", OleDbType.VarWChar, 100)
param1.Value = ComboBox1.Text
param2 = New OleDbParameter("@obekt_name", OleDbType.VarWChar, 100)
param2.Value = ComboBox2.Text
param3 = New OleDbParameter("@data_rabota", OleDbType.Date)
param3.Value = DateTimePicker1.Value.ToShortDateString()
param4 = New OleDbParameter("@nadnica", OleDbType.Currency)
param4.Value = FormatCurrency(0, 2)
aCmd = New OleDbCommand(strQuery, aCon)
aCmd.Parameters.Add(param1)
aCmd.Parameters.Add(param2)
aCmd.Parameters.Add(param3)
aCmd.Parameters.Add(param4)
'aCmd.Parameters.Add(param5)
aCmd.ExecuteNonQuery()

aCon.Close()

here i not insert data to autonumber field, because this field is autonumber

Re: How to create records that have an AutoNumber field

ivo753-Mar-09 7:05

ivo75

3-Mar-09 7:05

oooo here is the problem
strQuery = "insert into rabotnici (rabotnik_name,obekt_name,data_rabota,nadnica) values(?,?,?,?)"

it worked

Re: How to create records that have an AutoNumber field

Tej Aj3-Mar-09 7:32

Tej Aj

3-Mar-09 7:32

I have used Autonumber field in SQL Server DB. In it I did not use to create parameter for the autonumber field.
The syntax is like this for SQL Server DB
Lets say I have 3 fields from which 1st one is autonumber field

strQuery = "insert into Student(FirstName,LastName) values(@fname,@lname)"

param1 = New SqlParameter("@fname_name", SqlDbType.VarChar, 100)
param1.Value = txtName1.Text
param2 = New SqlParameter("@lname_name", SqlDbType.VarChar, 100)
param2.Value = txtName2.Text
Conn.Open()
Cmd = New SqlCommand(strQuery, Conn)
Cmd.Parameters.Add(param1)
Cmd.Parameters.Add(param2)
Cmd.ExecuteNonQuery()
Conn.Close()

NOTE:
> I have mentioned the Database ColumnNames in which I want to insert the
parameter values.

You too try passing Column Names in the insert query I think so doing so will
solve your problem.
Tell me whether this solution worked or not.

Re: How to create records that have an AutoNumber field

ivo753-Mar-09 7:36

ivo75

3-Mar-09 7:36

yes I passing the autonumber column in query thanks

Interop problem using Crystal Reports 8 with VB 2005

Jon_Boy3-Mar-09 5:34

Jon_Boy

3-Mar-09 5:34

Ok, before the criticism starts, I need this app to be able to work in Win98. We are being forced to support legacy systems and O/Ss.

I need to call a report using the CR8 via interop. Any report that doesn't utilize a subreport works fine. On reports that contain subreports, I cannot successfully set the .SubReportToChange

with CrystalReport1
 'This is where the error occurs. Source: "Exception from HRESULT: 0x800A4FB5" 
 'SourceTrace: "   at Crystal.CrystalCtrl.GetNthSubreportName(Int16 n)\r\n   at AxCrystal.AxCrystalReport.GetNthSubreportName(Int16 n)"
  .SubreportToChange = .GetNthSubreportName(0S) 'If tried hardcoding the subrpt name which also doesn't work.

  'All this code works fine from reports that don't have subreports
  .set_LogonInfo(0, "blah blah")
  .set_StoredProcParam(0, strTableTemp)
end with

Not sure what to do. .GetNthSubRptName requires a short value but always errs off. Can't set the .SubRportToChange to the actual name because it errs off as well w\ HRESULT: 0x800A4FB6.

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Convert VB6 Project to VB.NET

Pasan1483-Mar-09 4:28

Pasan148

3-Mar-09 4:28

I want to convert one of my VB6 Project to VB.NET 2005. If it possible how to do that.

Re: Convert VB6 Project to VB.NET

ABitSmart3-Mar-09 5:44

ABitSmart

3-Mar-09 5:44

Yes, it is possible. See here[^] or here[^]

Re: Convert VB6 Project to VB.NET

Steven J Jowett3-Mar-09 5:45

Steven J Jowett

3-Mar-09 5:45

Inthe Tools menu of Visual Studio you will find an option call "Upgrade Visual Basic 6 code...". Never used, but should be a good place to start.

Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Re: Convert VB6 Project to VB.NET

dan!sh 3-Mar-09 7:09

dan!sh

3-Mar-09 7:09

Never tried the options others mentioned. But make one thing sure, any tool will not give you a 100% correct code. Not just syntactically but performancewise as well. Also the ways of doing things in VB6 and then in VB.Net has changed. So you will definitely need to inspect code manually.

Time is the best teacher; unfortunately it kills all of its students.

जय हिंद

Reporting & Printouts

LostMonkey3-Mar-09 3:06

LostMonkey

3-Mar-09 3:06

Hello all,

I'm currently writing a Windows Form app, from scratch (VB & SQL2005). It's a client/server job and I want to add some reporting that will query information on my SQLServer 2005 database.

What I want is for users to be able to individually or batch print picking lists, despatch notes etc, but I don't want to have to shove a reportviewer onto the windows form to achieve it (which is what I am currently doing as a halfway house).

I want a user to both be able to click a button on a form to print an individual document for that job, or select a menu option to do a batch print off of all jobs that haven't been picked.

In VFP (my 'native' language you might say) I would simply author a set of reports then in my code select out my data for the report I wanted to run and then DO the report. This would send the report to preview or direct to the printer. The reports are compiled into the EXE, so no need to bother with paths etc.

Is it possible to build reports into your project so that I don't have to Load() them with a file path...I would rather DIM them and then send to print...

Again I'm not sure if what I ask is actually do-able...can anyone suggest the best method to use?

Thanks in advance,

LostMonkey

Re: Reporting & Printouts

Mycroft Holmes3-Mar-09 17:04

Mycroft Holmes

3-Mar-09 17:04

Hmm I no longer do much reporting but Iwould do the batch process on another thread from the main one. Not sure how the viewer form reachs to being hiddden when processing but it's something to try.

We use Reporting Services and manually launch subscriptions from the client, the server processes and logs the results. Same report can be launched by the UI for individual printing.

Never underestimate the power of human stupidity
RAH

Re: Reporting & Printouts

LostMonkey3-Mar-09 22:47

LostMonkey

3-Mar-09 22:47

Cool! An answer from the more intelligent Holmes brother!! Cheers Mycroft.

I messed around with this and found that I could add a Crystal Report to my project.

Then in code, all I needed to do was: -

Dim oCrystalReport As NameofMyReport

Then I could issue a

NameofMyReport.PrintToPrinter(1, False, 0, 0)

To get the unpopulated report out. So all I'm getting is a blank report with no data but the layout (titles etc) are there.

Next step is to get the data in!

Boy, I never thought I'd see the day when I would miss good ol' VFP's Report Designer bless it!!

LostMonkey

Re: Reporting & Printouts

Mycroft Holmes3-Mar-09 23:36

Mycroft Holmes

3-Mar-09 23:36

You are going down the path of insanity, given a choice of using Crystal and eating a bowl of worms - most here would seriously consider the worms.

There was a discussion here, I'll look for it later, along the lines of which report engine to use for stand alone reports (no server installation etc) the winner was DevX and SSRS, the loser by unanimious vote was Crystal.

Never underestimate the power of human stupidity
RAH

Re: Reporting & Printouts

Mycroft Holmes3-Mar-09 23:39

Mycroft Holmes

3-Mar-09 23:39

Try this thread

clickety[^]

Never underestimate the power of human stupidity
RAH

Re: Reporting & Printouts

LostMonkey4-Mar-09 0:04

LostMonkey

4-Mar-09 0:04

Thanks Mycroft

You have probably saved me a lot of time that I might have spent piddling into the wind!!

I shall crack on with some SSRS tutorials then.

Mixing C# and VB in a console application

ksportz3-Mar-09 1:30

ksportz

3-Mar-09 1:30

I'm a newbie so apologies if I'm asking a dumb question.

A colleague showed me a web site VS2008 solution which had a mix of C# controls and other modules in VB code.

I've created a Windows Forms based application and I've found some cool classes in C# that I'd love to use.

Is there any way to do this in the same application.

I'm using VS2008 with .NET 3.5

Thanks in advance

Re: Mixing C# and VB in a console application

Eddy Vluggen3-Mar-09 3:18

Eddy Vluggen

3-Mar-09 3:18

Right click on the node called "References" in your solution-explorer to add a reference to the C#-assembly, and you're good to go Smile | :)

I are troll Smile | :)

Re: Mixing C# and VB in a console application

ksportz3-Mar-09 4:47

ksportz

3-Mar-09 4:47

The C# project is in it's own project so not quite sure which file to add as a reference?

Thanks in advance.

Re: Mixing C# and VB in a console application

Eddy Vluggen3-Mar-09 5:05

Eddy Vluggen

3-Mar-09 5:05

You can either add;
- the generated assembly file, as found in the bin\debug folder,
- the complete .csproj file (by choosing the menu File, Add, Existing Project)

The first method is the easiest to perform, the second method compiles the C# code if you build your own code (updating everything that has changed in the C#-project)

Good luck Smile | :)

I are troll Smile | :)

Re: Mixing C# and VB in a console application

dan!sh 3-Mar-09 7:12

dan!sh

3-Mar-09 7:12

ksportz wrote:
I've found some cool classes in C#

AFAIK there should not be any difference in the classes available in C# and those in VB.Net unless you wrote it.

In case you have written it and its just a matter of using classes, then create a class library project, compile it to a dll and add as reference.

Time is the best teacher; unfortunately it kills all of its students.

जय हिंद

DateTime

Assaf823-Mar-09 0:31

Assaf82

3-Mar-09 0:31