report data source

hi all...

i made report depeand on a relationship between 2 tables

ok

my problem now ...

i want to make a report depeand on a relationship between 2 tables but i will handle the tables name at run time
so them will change from time to time

please ... i wait ...Create a stored procedure having that code and design the report using that sp.
At the front end supply table names to sp

report by multiple parameter with OR relationship

I am trying to create a report with three parameters (date, license number and application number). I want report by License Number or Application number in the date that I put in. I trying following in Record Selection:
1.
{Command.LICENSE_NO} = {?License Number} or
{Command.LICENSE_ID} = {?Application Number}

2.
if isnull({?License Number}) = false then
{Command.LICENSE_NO} = {?License Number};
if isnull({?Application Number})=false then
{Command.LICENSE_ID}={?Application Number};

** license_id is the application number(number). license number(string)

but both of them do not work. somehow I can not leave Application number empty.

Please Help!!!As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.|||As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.

I have tried using 0 as default, but for some reason. I still can not leave application number empty. I used exactly same as your code

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

but search will not start if I leave application parameter empty.

any thought?

Thanks for your help|||As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.

Got it working with your code!!!

Thanks your so much!!

report builder - need help reporting from multiple tables

I created a data view and model that has two tables joined (one to many
relationship). When I go into report builder, I see both entities
available for me. When I click one of the entities, I am able to select
that entities data items to drag onto my report. However, the other
entity disapears. If I delete all the fields from the report, both
entities are available again. So it appears as if I can have as many
entities defined as I want, but can only use one at a time to report
on. I know I am doing something wrong because I have seen samples that
do what I am looking for - I just can't figure out how to do it.its because you don't have relationship between your 2 tables.
if you have some relation, in this case you can go from table A to table B
"directly"
else you have to go through other shared tables (with unexpected results)
"steve" <stevensherman@.comcast.net> wrote in message
news:1165065154.712904.183760@.f1g2000cwa.googlegroups.com...
>I created a data view and model that has two tables joined (one to many
> relationship). When I go into report builder, I see both entities
> available for me. When I click one of the entities, I am able to select
> that entities data items to drag onto my report. However, the other
> entity disapears. If I delete all the fields from the report, both
> entities are available again. So it appears as if I can have as many
> entities defined as I want, but can only use one at a time to report
> on. I know I am doing something wrong because I have seen samples that
> do what I am looking for - I just can't figure out how to do it.
>|||Thanks for your reply. I do have the relationship defined in the
reporting services model. Do I need to depict it somewhere else or am I
missing setting a property or something?|||Once the ralationships are defined in the datasource view, that is all
it takes. Report builder recognizes the relationship and will let you
select from both tables. If the tables are not joined in the datasource
view, then you will only be able to select attributes from one table or
the other - but not both.