Hi all,
I have to create a dynamic report in vb.net.
I never had done something like this before.Users want to see tables name and when they choose the table they will select which fields should appear in report.
How should I do tha?
4 2686
What DB are you using? There should be stored procedures to list table names and field names that you can bind to dropdowns or checklists or whatever. Then it is just a matter of building the query string based on the user's input. If you used a checkboxlist, you could loop through all the items, and if it is checked, add that field to your query string.
The hard part might be the conditional statements. Study the format that Access uses for it's query designer. That might help.
Also, you should look into premade programs for this. For example, if you are using MSSQL 2005, you should look into SSRS.
Good luck.
What DB are you using? There should be stored procedures to list table names and field names that you can bind to dropdowns or checklists or whatever. Then it is just a matter of building the query string based on the user's input. If you used a checkboxlist, you could loop through all the items, and if it is checked, add that field to your query string.
The hard part might be the conditional statements. Study the format that Access uses for it's query designer. That might help.
Also, you should look into premade programs for this. For example, if you are using MSSQL 2005, you should look into SSRS.
Good luck.
Hi,
Thanks for reply, I as far as I know in vb.net I have to create Dataset and connect that dataset to my crystal report. If I want to give the user the ability to select the fields in run time how can I create dataset before(In design time)?
The other concern is how to design the crystal report? For example there may be a time user only select 3 fields to have report how can I put this 3 field in my report? What happens if user chooses to have 10 fields? I don't know how can I move columns in crystal report in order to have a good looking report?
I am using SQL2005 as database.
Please Help me to learn.
You should have mentioned that you were using Crystal Reports in the first place.
I've noticed that you post a lot, but rarely provide enough information in your first post. Please remember that we need to know this information for every post: Platform: Forms, ASP.NET, console, etc Language: VB.NET, C# Database Platform (if applicable): MSSQL Server, MySql, Access, Oracle, etc Other Important Software: Crystal Reports, 3rd party DLLs, AJAX extensions, AJAX toolkit, etc.
Please remember to provide these in every thread you start.
MODERATOR
You should have mentioned that you were using Crystal Reports in the first place.
I've noticed that you post a lot, but rarely provide enough information in your first post. Please remember that we need to know this information for every post: Platform: Forms, ASP.NET, console, etc Language: VB.NET, C# Database Platform (if applicable): MSSQL Server, MySql, Access, Oracle, etc Other Important Software: Crystal Reports, 3rd party DLLs, AJAX extensions, AJAX toolkit, etc.
Please remember to provide these in every thread you start.
MODERATOR
I will do that but I should make it clear that I am using crystal report viewer in vb.net.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Mir Nazim |
last post by:
Hi,
I m planning to use ZODB for an applicaton. Is any one aware of report
generators like Data Vision, Crystal Reports, fo python object
databases.
Some of you may have faced/solved similar problem some where.
Help appreciated.
Thanks
|
by: Sam |
last post by:
Hello everyone,
I have a table, which contains a picture column, I put URL info into it.
"www.myweb.com/1.jpg..."
I want to show this picture in my crystal report, I find
some samples show the "static" picture in Crystal report,
No "Dynamic" one.
Can Crystal Report do that?
Thanks in advance.
Sam
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to Create a Dynamic Crosstab Report
PRODUCT :Microsoft Access
PROD/VER:1.00 1.10
OPER/SYS:WINDOWS
|
by: deejayquai |
last post by:
Hi
I've created a crosstab query and displayed it as a sub-report in my
main report. This is fine until the data changes and the column names
become incorrect. I know I have to create a 'dynamic crosstab query'
but I don't know how to!! I've read the "How to..." on the Microsoft
site but it mainly gives an example rather than explain the...
|
by: Shourie |
last post by:
I've noticed that none of the child controls events are firing for the first time from the dynamic user control. Here is the event cycle.
1) MainPage_load
2) User control1_Load
user clicks a dropdown in UC1
_________________________
1) MainPage_Load
2) User Control_1 Load
| |
by: deejayquai |
last post by:
Hi
I'm trying to produce a report based on a dynamic crosstab. Ultimately
i'd like the report to actually become a sub report within a student
end of year record of achievement. The dynamic sub-report will capture
what grades the student has achieved in a list of different subjects
and the reason I need it to be dynamic is that students...
|
by: Dan Palm |
last post by:
I have a some online web report which are generated into html pages
from a SAP application. When the report is printed it prints over
multiple pages.
Currently, as there is no page break, the report is continuous and the
second, third, etc... pages do not have column headings. Can anyone
tell
me how can I make the column headings print...
|
by: creative1 |
last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however, working with complex reports is tricky
Assumption: Reader of this article have basic knowledge of creating data reports.
Creating a Parent-Child...
|
by: dlite922 |
last post by:
Before i spend hours coding this thing, i want to see if there's already a solution or one of you has built something close to it. Please suggest anything that may relate to any of the following
Goal: The user creates letter and report templates and executes it and it will print the letter and report based on the criteria (usually date range or...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |