create reporte in run time of programme

Question

0.00/5 (No votes)

See more:

hi..
im using vb.net and sql server for my projet. i got problem on it.
in this project user can add or drop tables in user interface as there own. i try crystal report for my projet. i follow this steps.
create new win; form and drag crystal report veiwer to it. then add new crystal report, using report wizard, create new conection, oledb(ado) ,sql native client,
then type server name and select the database, then i choose table and there felds. finally complete wizard and then back to report viewer and select datasourse as crystal report1. its work and display table data as report. then i got problem.when user create new table in this programe they cant get reports for new table. how i fix this.problem. please help.me. sory for my poor english and vb knowledgwe .
thanks!!!

Posted 5-Feb-12 5:50am

Amal anjula

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jamal Abdul Nasir · Answer 1 · 2012-02-05T06:23:00

as far as i understood your question i can say that you must create a general class for that which will have everything a crystal report needs...

for example... that class should include the following members... you can have more but these are the basic ones...

VB

CrystalReport (CRPT)
CrystalReportViewer (CRV)
Table
Query

on the other hand you must have function which will accept the following parameters...

VB

ShowReport(ByVal TableName As String, ByVal CRV As Object, ByVal CRPT As Object, ByVal Query As String, Optional ByVal ParameterValue As Object = Nothing)

and the rest is upto you...