how to get the report list with one modified table ?

When i modify one table schema, how could i get the report list that lists
all the reports reference the table i modified ?
Thanks for any help.Hi Abel:
AFAIK, there is no easy way to do this. It might be an interesting
utility to write...
--
Scott
http://www.OdeToCode.com/
On Fri, 1 Oct 2004 00:07:02 -0700, "Abel"
<Abel@.discussions.microsoft.com> wrote:
>When i modify one table schema, how could i get the report list that lists
>all the reports reference the table i modified ?
>Thanks for any help.

How to get the most out of expressions in SSRS 2000?

Hi. I am increasingly frustrated over my inablility to find much reference material on using expressions in SSRS 2000. In my WROX book, there is mention of the immediate if (IIF(condition),true_action,false_action) and I saw somewhere about a SWITCH statement, but I can find little else. I have been so spoiled by Crystal Reports very comprehensive programming tools, but I would really like to use SSRS. Can anyone direct me to a resource that provides a complete description / reference for expression syntax?

Thanks VERY much!

Tom Stanley

I have tried to find stuff on BOL for reporting services but it hasnt helped much. Google is much better. Here's one sample:http://www.sqlservercentral.com/columnists/bknight/reportingservicesconditionalformatting.asp

Also, if you have the latest BOL Version, you can filter by Reporting Services and look for Expressions and they do have some sample scenarios.

How to get System.Query Namespace

Hi all,

I tried to do the Linq sample program, Already i have added System.Query namespace. But I am getting some error

like No reference to System.Query.

In my system , i have installed VS 2005 and .Net Framework 3.0.

Apart from the this, please tell me , whether any software are required

Regards and Thanks

Thirumurugan

Using/import statements can only reach the assemblies that are known to the application. In some cases you must explicitly add a reference to an assembly to be able to use it. To use System.Query you need to add a reference to that assembly. Right click on the solution and choose references. Click add and System.Query.dll should appear in that list.

|||

I tried same what you mentioned but still i did not get System.Query reference.

|||

What do you mean? Did it not appear in the .NET tab when you click on add reference? Then it is probably not registered correctly in the GAC... Do you see any other 3.0 assemblies in the list?

sql

How to get Reference from CompositePrimaryKey field ??...

I have one table nameMagazine_Details,it has a composite primary key

Create table Magazine_Details(MagazineTitlevarchar(60),MagazineTypevarchar(20),IssueTypevarchar(25),IssueNumbervarchar(10),Qntyint,Qnty_in_Handint,[Date]datetimeconstraint PK_Magazine_Details_Compositeprimary key(MagazineTitle,IssueNumber))

Another table isMagazine_Issued and i want reference from Magazine_Details table. but i am auable to create foreign key constaraint inMagazine_Issued table.

create table Magazine_Issued(Member_IDvarchar(100),MagazineTitlevarchar(60)references Magazine_Details(MagazineTitle),IssueNumbervarchar(10)references Magazine_Details(IssueNumber),IssueDatedatetime,Magazine_Statusvarchar(10))

Hi,

If you need to create the foreign key constraint, you also need to add the CONSTRAINT clause and constraint name.

create table Magazine_Issued
(
Member_ID varchar(100),
MagazineTitle varchar(60) CONSTRAINT FK_MagazineTitle_Details_Issued FOREIGN KEY (MagazineTitle) references Magazine_Details(MagazineTitle),
IssueNumber varchar(10) CONSTRAINT FK_IssueNumber_Details_Issued FOREIGN KEY (IssueNumber) references Magazine_Details(IssueNumber),
IssueDate datetime,
Magazine_Status varchar(10)
)

|||

after trying to create Magazine_Issued Table following error comes.

primary or candidate keys in the referenced table 'Magazine_Details' that match the referencing column list in the foreign key 'FK_MagazineTitle_Details_Issued'.

Could not create constraint. See previous errors.

|||

miazaidi:

after trying to create Magazine_Issued Table with above script following error comes.

primary or candidate keys in the referenced table 'Magazine_Details' that match the referencing column list in the foreign key 'FK_MagazineTitle_Details_Issued'.

Could not create constraint. See previous errors.