I am trying to feel my way through setting up reports with my VB app. I have tried Crystal and regular reports and I'm not getting any data in either. Is there a good tutorial anyone knows of that might be helpful? I have looked at the Microsoft/MSDN guide, but it didn't address my absence of data. Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Good tutorial for using Crystal Reports with .NET? 3
- Thread starter artyk
- Start date
- Thread starter
- #21
So, the dataset still has to be filled after adding it to a form? I told you I was new. 
That makes sense, I just didn't think of that with respect to the reports. I've been getting along decently in my forms, for the most part, but reports (at least this way) are new to me. Thanks for the guidance! I'll try it and let you know.
That makes sense, I just didn't think of that with respect to the reports. I've been getting along decently in my forms, for the most part, but reports (at least this way) are new to me. Thanks for the guidance! I'll try it and let you know.- Thread starter
- #22
That worked! Thanks a ton! A small side question, is there any way to make the report come up faster? I have a pretty decent machine (one that is better than most of the ones that my app will run on) and it still takes several seconds to display.
Awesome, I'm glad I was able to help.
Regarding performance, there are a number of things that can effect performance.
The biggest thing is the size of the dataset, only fill the dataset with the records that are needed, don't fill the dataset with the whole database and filter the records with CR.
What database are you using? If it's Sql Server you will always have a performance hit of a few seconds when you first make a connection because of the high overhead of the connection, subsequent connections are not delayed because of connection pooling, you may want to fill the connection pool when the form opens.
Make sure your fill queries are based on indexed columns
I think you mentioned that you will be running a number of different reports. Assuming that the delay is in the database fill and or the connection, you may want to set up your connection and fill your database when the form opens, then give the user a choice of reports to run. The form will be delayed when it opens but when the user runs the report it will open quickly. The delay will still be there but to the end user the program won't have that sluggish feel.
Perrin
Regarding performance, there are a number of things that can effect performance.
The biggest thing is the size of the dataset, only fill the dataset with the records that are needed, don't fill the dataset with the whole database and filter the records with CR.
What database are you using? If it's Sql Server you will always have a performance hit of a few seconds when you first make a connection because of the high overhead of the connection, subsequent connections are not delayed because of connection pooling, you may want to fill the connection pool when the form opens.
Make sure your fill queries are based on indexed columns
I think you mentioned that you will be running a number of different reports. Assuming that the delay is in the database fill and or the connection, you may want to set up your connection and fill your database when the form opens, then give the user a choice of reports to run. The form will be delayed when it opens but when the user runs the report it will open quickly. The delay will still be there but to the end user the program won't have that sluggish feel.
Perrin
- Thread starter
- #24
Yes, I'm using SQL Server. Basically I have a form that allows users to select different report parameters before the report viewer form actually loads. I just put all the code to load the TableAdapters in that form so it only has to happen once, as you suggested. Thanks again for your time and help! I appreciate it.
- Status
Similar threads
