crystal reports - reporting prob.

[kuldevbhasin]

hi guys.
i am using vb.net 2008 and crystal reports that comes along with it
now my prob is that i have 3 tables connected into 1 table there might b data in the other 2 tables or there might not b like if a client has additional place of business if he has then the report is perfect but if a client is not having the no. of additional places and hence the data is not found in that particular table for that reason the entier report comes blank. similarly the 3rd table is for processing job. the client may or may not have any processing job...and hence it may b blank that effects the entier report.....

i am really confused as to what should b done.
pls. help me out with it ....

thankx a lot...

[Hack]

The easiest solution (and one which will require no programming code on your part) is if the business has no additional places of business add the word "None" in those fields, hence, no blank fields.

[kuldevbhasin]

The easiest solution (and one which will require no programming code on your part) is if the business has no additional places of business add the word "None" in those fields, hence, no blank fields.

thankx for ur reply. but this wont work for me coz in another place i have to calculate some charges and the charges would b for those where i select a category and thus it selects the percent
say there r 5 items and only 2 r chargeable and hence the 3 items r without the category
now my prob is that as the category is blank those items r not being displayed and only 2 itmes with category (category code is stored. category name comes from master)

hope u get what i mean....
pls. help me out....
thankx

[jggtz]

Why not solve it with code and create a new output table with the ready to print data

[kuldevbhasin]

Why not solve it with code and create a new output table with the ready to print data

hi...thankx for ur reply jggtz ...can u pls. explain a bit about ur solution ? do u mean that i create a report from 1 table where i dump the entier data ...is it so ?
i need 3 seperate details under diffrent heads so it would either b 2 details available or 1 or at times all 3 would b available so how can i dump the entier data into 1 table and diffrentiate between the 3 details to b displayed under 3 heads..?

thankx..