Re: Report Footer:Line Size(CR) - Visual Basic Discussion Boards

Re: invoke batch file from server

nlarson1114-Apr-09 5:33

nlarson11

14-Apr-09 5:33

sounds dangerous but...your server Smile | :)

look for aspexec.dll this will allow you to execute exe's/batches/etc from an asp page.

'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous

'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous

Excel file does not close in task manager

Anoop Brijmohun13-Apr-09 23:11

Anoop Brijmohun

13-Apr-09 23:11

hi guys,

The code below works fine except when i open the windows task manager, i can still see EXCEL.EXE Running.
how do i close or exit it, should not objFso.Quit() Close Excel?

thanks

 Dim objFSO, ObjWb, ObjWs As New Object
 
 objFSO = CreateObject("Excel.Application")
 ObjWb = objFSO.Workbooks.Open("c:\myapp.xls")

 For Each ObjWs In ObjWb.Worksheets
   MsgBox(ObjWs.Name)
   Application.DoEvents()
 Next


objFso.Quit()

Re: Excel file does not close in task manager

ChandraRam13-Apr-09 23:26

ChandraRam

13-Apr-09 23:26

Since you have work books open, it would probably prevent Excel from closing.

Re: Excel file does not close in task manager

Anoop Brijmohun13-Apr-09 23:31

Anoop Brijmohun

13-Apr-09 23:31

well this seems to work....
i have added this after the worksheets loop...

ObjWb.close()
            releaseObject(ObjWs)
            ObjWs = Nothing
            releaseObject(ObjWb)
            ObjWb = Nothing
            releaseObject(objFSO)

            objFSO = Nothing

        Catch ex As Exception
            MsgBox(ex.Message, MsgBoxStyle.Critical)
        End Try
    End Sub
    Private Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub

Re: Excel file does not close in task manager

Ravi Kumar Tyagi13-Apr-09 23:31

Ravi Kumar Tyagi

13-Apr-09 23:31

You also have to dispose the object

Re: Excel file does not close in task manager

Pankaj-codeproject14-Apr-09 2:40

Pankaj-codeproject

14-Apr-09 2:40

close the workbook also,
excel.workbook.close

Report Footer:Line Size(CR)

C#Coudou13-Apr-09 22:29

C#Coudou

13-Apr-09 22:29

mates,

i don't know where to post this, its about crystal report in visual basic.net.

I have a problem of the line size on report footer.
It will not follow the size(10) when page is more than 1.

heres the image: page 1 should the same line with page 2.

http://i40.tinypic.com/6enlmq.jpg

thanks in advance.

C# コードMicrosoft End User
2000-2008

「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Re: Report Footer:Line Size(CR)

Anoop Brijmohun13-Apr-09 23:22

Anoop Brijmohun

13-Apr-09 23:22

Hi,

if i am not mistaken, i would say that you have a drop shadow on your grid.

the last line is the bottom of the grid.
that bottom line will only display once .i.e at the end of the report/data.

so when you have data for only one sheet, you actually see the bottom of the grid on the same page.
when there is more data than one page then the bottom line will be on the last page.

notice on your grid that when 2 pages then the last line on first page is same size as all the other lines.

thanks

Re: Report Footer:Line Size(CR)

C#Coudou14-Apr-09 13:59

C#Coudou

14-Apr-09 13:59

exactly. i have a line at the end of the report. that is why i put a line in a report footer. the page 2 is correct but page 1 the line doesnt show.
any suggestion, how will i add a line in every end of a report?

thanks mate.

Re: Report Footer:Line Size(CR)

Tom Deketelaere14-Apr-09 5:28

Tom Deketelaere

14-Apr-09 5:28

Print the report and check if its still there

I'v noticed that sometimes it will do this in preview but when printed it is the actual size.

Re: Report Footer:Line Size(CR)

C#Coudou14-Apr-09 14:02

C#Coudou

14-Apr-09 14:02

Tom Deketelaere wrote:
Print the report and check if its still there

yes i print that report but the same problem because i thought its only in preview. anyway, the problem is how will i add a line in every end of a report, any suggestion?

Re: Report Footer:Line Size(CR)

Tom Deketelaere14-Apr-09 20:56

Tom Deketelaere

14-Apr-09 20:56

Do you want a line on the end of every page or just at the end off the report.

At the end of every page: add a line to the section 'page footer'
At the end of the report: add a line to the section 'report footer'

Re: Report Footer:Line Size(CR)

C#Coudou15-Apr-09 13:37

C#Coudou

15-Apr-09 13:37

thank you for immediate reply.

Tom Deketelaere wrote:
At the end of every page: add a line to the section 'page footer'

I used this one but the problem is how can I show a line at the bottom of my detail section after the last record of the page? Depending on how many records, the line will need to appear at the end on each page to form a box around the detail output.

Re: Report Footer:Line Size(CR)

Tom Deketelaere15-Apr-09 20:55

Tom Deketelaere

15-Apr-09 20:55

You could try adding a new section

Or add the line to the page footer (on top)

I'm not that used to CR so can't really be specific.

Problem of Combobox

nazimghori13-Apr-09 21:09

nazimghori

13-Apr-09 21:09

hello every one

i am having problem of combobox my code is..
this code works in VB6 but in Vb.net how can i pass itemdata to particular text

cmbmonth.add("January")
cmbmonth.itemdata(0)=1

i m beginner..
so please help...

Re: Problem of Combobox

Dalek Dave13-Apr-09 23:41

Dalek Dave

13-Apr-09 23:41

I can see nothing particularly wrong with that, so long as you are using the correct capitals.

cmbmonth.ItemData (0) = 1

However we need to see more code, are you setting it up correctly? If nothing is set it will default the ItemData to -1.

------------------------------------

"I am always serious about what I do, not necessarily about how I do it."
Tom Baker

Re: Problem of Combobox

nazimghori14-Apr-09 0:54

nazimghori

14-Apr-09 0:54

I tried the same code u wrote it shows the error message like

'ItemData' is not member of 'System.windows.forms.combobox'

please suggest what to do with this error....

thank u in advance...
Smile | :)

Re: Problem of Combobox

Jay Royall14-Apr-09 1:31

Jay Royall

14-Apr-09 1:31

ComboBoxes are handled differently in .Net than in VB6, so much so that it is beyond the scope of a forum post to explain. If you Google for VB.Net combo box tutorials I'm sure you'll find something.

But saying that, it seems like you want to populate the combo box with the months of the year, right? What I would do is create a user defined structure called Month with 2 properties, MonthName and MonthNumber and then bind the combo box to a collection of Month structures, setting the ValueMember and DisplayMember properties of the combo box.

Hope this helps.

(you could also do it by populating the ComboBox with strings and by using ComboBox.SelectedIndex - 1 to get the month number but I think this may be regarded as bad practice.)

Re: Problem of Combobox

Johan Hakkesteegt14-Apr-09 23:55

Johan Hakkesteegt

14-Apr-09 23:55

For your purpose you could use the DateTimePicker control, and set the CustomFormat property to MMMM

The DatTimePicker looks like a combobox, and with the CustomFormat property set to four M's, it will show you the name of the month. When opened it shows the user a calendar.

In your code you can access the chosen month's number (an integer) like so:

DateTimePicker1.Value.Month

If you need to do more with dates, the DateTimePicker value is of type Date, so you can access a lot of other values from a chosen DateTime. Like DateTimePicker1.Value.Day, DateTimePicker1.Value.Hour, DateTimePicker1.Value.Year, etc.

My advice is free, and you may get what you paid for.

Run msi thru bat file...

p_196013-Apr-09 19:38

p_1960

13-Apr-09 19:38

Hi,
May i know how can i invoke msi thru a batch file....

Re: Run msi thru bat file...

Ravi Kumar Tyagi13-Apr-09 23:19

Ravi Kumar Tyagi

13-Apr-09 23:19

Edit the bat file with following command

msiexec /i "FileName.bat"

Re: Run msi thru bat file...

Dave Kreskowiak14-Apr-09 5:23

Dave Kreskowiak

14-Apr-09 5:23

The general command line is for an unattended install with a minimum GUI:

msiexec /i installername.msi /qb

If you need to add a Transform file:

msiexec /i installername.msi TRANSFORMS=transformname.mst /qb

All the available options for MSIEXEC can be found by just typing MSIEXEC into a Start/Run box.

A guide to posting questions on CodeProject[^]

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

Re: Run msi thru bat file...

nlarson1114-Apr-09 5:25

nlarson11

14-Apr-09 5:25

You can run any windows.exe from dos by putting the word 'Start' infront of it.

start myfile.msi

or

start notepad.exe

or

start http://www.yahoo.com

etc

Visual Interdev Issue: Not Opening Giving Error

priyaahh13-Apr-09 19:32

priyaahh

13-Apr-09 19:32

Hi Friends,

I am using Microsoft Visual Interdev 6.0 in my system. It was working fine. But for the last 2 days i am facing problem, that when I click Visual Interdev 6.0 to open its giving error:

"Development Environment has Encountered Problem and needs to Close. We are sorry for the inconvenience."

I tried uninstall and install again. Still I am facing the same problem. I have Visual Studio 2003 installed in my system and with that interdev was working fine for the past 1 year. Please Please help me. Because formating system and installing again is a rock work. Please friends help me..give me ur suggestions...

Thanks in Advance.

Re: Visual Interdev Issue: Not Opening Giving Error

Dave Kreskowiak14-Apr-09 5:06

Dave Kreskowiak

14-Apr-09 5:06

Visual InterDev isn't supported anymore, and hasn't been for quite some time now. This[^] Google result is about the best you're going to find for such an old app.

A guide to posting questions on CodeProject[^]

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.