not getting specific report 1

[bhaskarsurya]

i am using vb and sqlserserver and crystal report
i need a report which need five tables so i create two views for the report. one view has single entry for a one field (say sales no. ).and other has multiple entries for it.my problem is that iam getting coplete report i.e for all sales no.. i want report for only one specific salesno.
pls tell me how can it work

 

[nagornyi]

In reporting this task is performed with parameters. You need to specify a salesno parameter in your report and use it for data selection.

 

[synapsevampire]

You might construct a data set within VB and pass it to Crystal (that depends on technical information which you didn't supply, such as the standard question about version numbers, how you're invoking reports, connectivity, etc.).

Or you can construct a record set within VB and pass it to Crystal.

Or the alternative nagornyi suggests would be to have a salesno parameter within Crystal and either collect and pass the parameter from within VB, or allow the Crystal Viewer to automatically prompt the user.

Here are the sample applications, but you need to decide how you want to do this, again, this is based on what version VB and Crystal you're using, the breadth of Crystal versions and means to implement are wide and deep:

http://support.businessobjects.com/fix/samplescr.asp?ref=default.asp_selectlist

-k

 

[synapsevampire]

Sorry, this:

"Or you can construct a record set within VB and pass it to Crystal."

should have read:

Or you can construct a record selection formula within VB and pass it to Crystal.

-k