Comments by Reji Ab (Top 31 by date)

Thanks,. But I am using the built in dialog in crystal report viewer. So I don't have any control on it

Thanks for your reply. Those examples shows text box with list box. I just want to use list box only

Thanks for your reply. But I still need to install msm package in the client machine.
In Visual basic 6 there is a built in report named Data report. If I want to install the data report in the client machine I just need to register two dlls in the client machine. So can I get the dlls to register in the client machine just to run the crystal report same as in the case of data report, instead of running the package if possible

Open the report in database->Set location
Leave only table name in location (not servername.dbo.tablname) for all of the tables you are using in the report

Sandeep,
Thanks for your reply. I just want to assign to another parameter field in the sub report, not to any of the database fields in the sub report

<script> function populate() { document.submit.form(); ///now write the coding for onclientclick event window.open('Default6.aspx','List','scrollbars=no,resizable=no,width=420,height=330'); return false; } </script>

After submitting the form it never executes the second part of the function window.open.....

It works but popup blocking issue still there

window.open works well without popup blocking if I use it in client side. The problem here is I just want to show it after executes the server side script

Thanks Tharaka. I want to show an asp page as popup. Div popup shows only a popup window

Thanks Tharaka for your reply. I looked into the link and I can see RegisterClientScriptBlock and RegisterStartupScript both used in server side if I open the popup from the server side popup blocker blocks it. I don't want to do that. If I use javascript:window.open ..... in onclick it shows an error.
Can u please provide me the sample code to pop up window without blocking.

CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField) causing null value reference error. The other code works by instantiating both parameterfield and discretevalue for each parameter

What is wrong? . Same to you as well

Your reply is wrong there is grid in the form. I found the solution
just call application.doevents() after invalidate then it fire the paint event. No need to wait for whole day

I want to paint the grid in form load event. Below is the bit of code in the load event. I want execute the paint event of the grid in the line "DbgridView.InvalidateCell(DbgridView.CurrentCell)"

For Each dr In dt.Rows If irow >= iTotalrows Then DbgridView.Rows.Add(1) End If DbgridView.Item(iColumn, irow).Value = dr("CT_DESC") If Not IsDBNull(dr("Assigned_Code")) Then selection = True rcdraw = DbgridView.GetCellDisplayRectangle(iColumn, irow, False) DbgridView.CurrentCell = DbgridView.Item(iColumn, irow) DbgridView.CurrentCell.Selected = True DbgridView.InvalidateCell(DbgridView.CurrentCell) End If irow = irow + 1 ' Exit Sub Next

There nothing wrong in the paint event. It works well after loading the form. I debug the code , it doesn't goes to the paint event when it executes invalidate in the form load event

I want to call the paint event in the load event of the form. Invalidate doesn't call the paint event in the load event of the form

It didn't work for me

Thank you, that works

Thanks for your reply. I already googled it but no help.

It happens in the formula code
ToText({rooms.RM_DIRYPOS}) + ToText({rooms.RM_ABBR});
were rm_dirypos and rm_abbr are defined as varchar(10) in sql server.

When I use vb.net 2010 it uses crystal report XI to run the reports.
when I open in crystal report designer it uses 8.5 to run it and it runs fine.

This report works well when running it from DELPHI application, it uses crystal report 8.5 to run it. So I am wondering is that an issue with new version of crystal report. Any ideas please help

I repaired the installation but one component failed to install, but still having the same problem.
when I tried to register the dll manually It shows following error :

"<the path of the dll> was loaded but the call to DllRegisterServer failed
with error code 0x80070005". I logged in as an administrator in order to register the dll through command prompt

Its showing an error when I tried to register the dll

In the database the data type is datetime(yyyy/mm/dd hh:mm:ss)
It appears as same format in crystal report as well but the data type is string

if you put DateValue({myTable.strDate}) in the selection formula it
shows an error message "bad date format". My question is why the datetime type changed to string type in crystal report?

SetDataBaseLogon() didn't work for me. Other code works, Thank you

Thank you