|
I really wonder why viewing report using crystal report in vb 2005 is very slow. It is not good if it is slow to crystal report.
Is there any solution with this? Is there any other kind of report that is better?
|
|
|
|
|
Hi,
I m working with vb.net 2005 and crystal report 10 .the time to load crystal report is very high.it takes a minute to load a simple report.
the code i used given below.
if anyone know to solve this problem, please give me reply.
Dim repDoc As New ReportDocument
Dim subRepDoc As New ReportDocument
Dim crSections As Sections
Dim crSection As Section
Dim crReportObjects As ReportObjects
Dim crReportObject As ReportObject
Dim crSubreportObject As SubreportObject
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As Table
Dim crLogOnInfo As TableLogOnInfo
Dim crConnInfo As New ConnectionInfo
repDoc.Load(CrystalStrReport) 'Report path
crDatabase = repDoc.Database
crTables = crDatabase.Tables
For Each crTable In crTables
With crConnInfo
.ServerName = "Server"
.DatabaseName = "Sample"
.UserID = "sa"
.Password = "abcd"
End With
crLogOnInfo = crTable.LogOnInfo
crLogOnInfo.ConnectionInfo = crConnInfo
crTable.ApplyLogOnInfo(crLogOnInfo)
Next
crTable.Location = "Sample" & ".dbo." & crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
crSections = repDoc.ReportDefinition.Sections
CrystalReportViewer1.ReportSource = repDoc
CrystalReportViewer1.Show()
Gopakumar
|
|
|
|
|
how to add combobox in listview.very urgent.
|
|
|
|
|
Does anyone have an examples/ideas about how to format data using a datagrid in VB Net - maybe its not possible to do this with a simple data grid
My data comes from two tables w multiple records for the same id number and name. I don't want to keep repeating id and name fields
It comes out like this in the datagrid:
ID1 Name1 data group1 (several fields)
ID1 Name1 data group2 (several fields)
ID1 Name1 data group3 (several fields)
ID1 Name1 data group4 (several fields)
ID1 Name1 data group5 (several fields)
ID2 Name2 data group1 (several fields)
ID2 Name2 data group2 (several fields)
etc
I'd want to look something like this:
ID1 Name1 data group1 (several fields) data group2 (several fields) data group3 (fields) etc
ID2 Name2 data group1 (several fields) data group2 (several fields) data group3 (fields) etc
ID3 Name3 data group1 (several fields) data group2 (several fields) data group3 (fields) etc
OR maybe like this
ID1 Name1
data group1
data group 2
data group 3
data group 4
etc
ID2 Name 2
data group1
data group 2
data group 3
data group 4
etc
Thanks
|
|
|
|
|
It looks like Pivot Table...
I don't know if Datagrid Control in VB can does.
How about this.. you unbound your datagrid with your datasource..
You will create several collection/array to act as buffer/dataset for your data
Then you will put that data into datagrid cell like the way you want to.
It make sense?
|
|
|
|
|
Hi everyone!
I need put the splash scree to programme,which display infront some few minitues whenever start the programme.Can anyone help for this,its better if someone give me to any example codings or guid web site
Thanks
|
|
|
|
|
putting a splash screen that runs for a few minutes; don't you think a few seconds will do? the program users will get 'bored' if they have to wait for the minutes evry time they run the programme. go through some human interface design notes.
Regards,
Hesbon.
|
|
|
|
|
thank u
can u some example codings to me,bcouz if i put the splash scree its not running when i'm run the prgramme shold i use any coding for that?
|
|
|
|
|
Well, to have a splash screen, best practise in my opinion is to have a Sub Main procedure in a seperate Module. (You add a module to your project, by clicking Project - > Add Module...). You will also need to add another form, to be used as a Splash Screen.
Once in your Module Type something similar to :
Public Sub Main()
Dim fSplash As New frmSplash
fSplash.ShowDialog()
Application.Run(New Form1)
End Sub
And This is the coding for the Spalsh Screen Form (frmSplash)
Private Sub frmSplash_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Timer1.Interval = 3000 ' Approx. 3 Seconds.
Timer1.Enabled = True
End Sub
Private Sub frmSplash_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Click
Me.Close() ' Close when the Splash Screen is Clicked
End Sub
Private Sub Timer1_Tick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Timer1.Enabled = False
Me.Close() ' Close the Splash Screen after the time has elapsed
End Sub
That should give you quite a good idea on what to do. Now, the rest is up to you!
HTG
|
|
|
|
|
Yes it's working thank you very much.But how can i put any picture to splash screen.
|
|
|
|
|
It's a pleasure.
How do you mean get a different picture ¿
Like, do you want it on the form ¿ If that's the case, you must select the BackgroundImage Property of the SplashScreen and browse for your picture you want to use.
Just a note: You may not see the image in the design window on your form, only once you run it, you'll see the picture.
|
|
|
|
|
how to implement a for loop in visual basic
actually i want to run a reverse loop ie.
eg.in c it could br written as for(i=4;i>=1;i--)
plssssssssssss help
namy
|
|
|
|
|
For variable= .. to ... step -1
(..)
Next
|
|
|
|
|
Hello,
I'm wondering if it is possible to clear individual session("variables")??
Googling, looked on msdn, can't find...
Please help!
(please note: individual session variables! It's easy to drop em all, but I need to empty some in some cases)
|
|
|
|
|
You can just set it to nothing.
|
|
|
|
|
But it will still exist,
and if you have 10000 users with each session variables.....
I need a way to completely drop SOME of those session variables when i choose.
-- modified at 6:20 Tuesday 1st August, 2006
|
|
|
|
|
try this Session.Contents.Remove()
|
|
|
|
|
I am using Outlook express to read all the mails in the inbox.How can i know the connecting url of my outlook express.
Thanks in advance.
Regards
Anuradha
|
|
|
|
|
how to use functional keys as shortcut keys to open a form in vb
|
|
|
|
|
Main-menu -> shortcut keys -> you will find all the function keys to use .
|
|
|
|
|
how to put functional keys as shortcutkeys to open forms?
|
|
|
|
|
One way is create a main menu or a context menu and specify which shortcut keys should be used. Also, the obvious route would be to create an object that captures keypress events to launch the form you want.
-- modified at 11:29 Friday 28th July, 2006
Tyquaun
|
|
|
|
|
Hi Folks,
I have developed an inventory warehouse application (VB.Net UI) that uses a SQL 2000/2005 database. A Microsoft gold partner has asked me to seamlessly integrate my application with a Microsoft ERP application that also uses a SQL database. What I thought would be rather easy issue has really got me bogged down.
I was wondering how to handle this bridge between the two applications.
An example of the bridge would be:
A sales order/Order Lines record(s) are inserted into MS ERP database table(s), this record(s) needs to be replicated into my database (Sales Order/Order Lines table(s)). The Schema’s of the table(s) are not the same. If a record(s) are delete/updated then these actions would also have to be reflected in my database.
This would only be a one way replication, meaning my database can not perform inserts/Updates/deletes on the MS ERP database table(s).
I have look at doing this at the database level using SQL replication of a view, but I would like to write a windows service that the user can define the particular table(s)/Field(s) to bridge.
If you’re wondering why not just lookup the MS ERP database table(s) when needed, well part of the spec supplied to me was that the MS ERP database can be taken offline, but my application must still able to pick the outstanding ordered items that were in the ERP Database.
I would be grateful for you comments.
Regards Ian
|
|
|
|
|
If I am understanding you correctly, then you should just use a triggers on the ERP server and perform inserts, updates, and deletes accross databases.
You can do something like the following:
INSERT INTO DatabaseName.[owner].TableName (CompanyName, Phone)
VALUES ('Snowflake Shipping', '(503)555-7233')
- Where database name is, use your database name
- Where owner name is, use the owner name of your database. The default is dbo
- Where TableName is, use the table name on your database where you want to insert.
If I am correct in my assumption, then this solves your problem of processing data across databases easily.
However, The biggest problem you are going to run into is associating the records that are in the ERP database with your database. For that purpose, you should have ids that are in your database that corresponds to the ERP database. That way you can perform updates and deletes. If associating records through ids becomes a hassle, then you should probably use replication.
Tyquaun
-- modified at 23:55 Thursday 27th July, 2006
|
|
|
|
|
Thanks for the quick reply Tyquaun,
Your assumptions are correct. Your answer was on my list of possible ways to handle this task. I wanted to put this task out to the programming community to see what idea’s came back.
I thought of using COM+ distributed transaction, but this would not work because its not my UI that initiates the transaction,MS ERP system does.
The record id’s are not a problem because they do match the ERP database id's.
What if my database is not running on the same server as the ERP database?
Microsoft has three ERP applications and one of them does not use a MS SQL database, I just know they are going to ask me work with all three products after a period of time.
It may be helpful to reads of my post if I throw my idea’s in here as well.
1. Use SQL Replication
I am against this a bit because it almost needs the purchasing customer of my application to have a DBA on site to set this up or maintain the replication.
2. Place triggers on the appropriate tables of the ERP Database to replicate the required data to my database.
3. Use a COM+ distributed transaction (as I said above thinking this would not work)
4. Write a utility tool that would load the data from both databases into separate datasets then compare the ERP dataset (Master) to my dataset and replicate any ERP dataset (Master) changes. This utility could run as a windows service and load up the datasets every few minutes or so, I could also put UI into it that reads both the databases schema’s and lets an on site administrator select the table(s)/Column(s) to replicate.
I sort of like this idea because the ERP database could be anything as long as there is an ODBC driver for it, but speed could be a problem.
5. Use MSSQL DTS tool.
-- modified at 4:17 Friday 28th July, 2006
Regards Ian
|
|
|
|