Avatar of Briancslnet
Briancslnet
Flag for United States of America asked on

SSRS REPORT DATASET EOF RECORDS

Heres a good one for everybody;

I have a report which uses an SQL database.  I have 4 tables which are linked in the report.
The first table references the second table on a field called "Part_id".  What I want to select is those records in the first table which DO NOT exist in the second table.
I have tried "select...from..... WHERE Part_ID in secondtable IS NULL AND  blah.blah.blah...

the program just hangs in preview mode with reporting services.  Cannot seem to figure this out.
Any help or booting in the correct direction would be appreciated.
SSRSMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Mike McCracken

8/22/2022 - Mon
edlunad

You query does run if you execute it directly in your Sql Server?

Have you tried to restart the service SQL Server Reporting Services?
anandarajpandian

First check result set size,if it's more records,May be memory constraint in your pc.

Soln: Result set stored in Separate Table and use Table in SSRS.

Query:
seelct  PARTID from table1  
where not exists(select 'x' from table2 where  table1.partid=table2.partid)

Briancslnet

ASKER
Not sure we are on the same page, I will try to explain with more depth.

I have a table of Part numbers. I use this table as my primary table for an SQL query (i.e.  SELECT * FROM PARTTABLE)

I have a second table of existing orders.  We call these REQUIREMENTS

I am creating a report of PARTS which have NO requirements.

In addition I then need to extract specific data from 2 additional tables (i.e. a CUSTOMER table and a PARTDESCRIPTION table)

I have a very limited knowledge of SQL formats and hope somebody can give me  the syntax for a select statement, or at least send me in the right direction.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
edlunad

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mike McCracken

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.