what version is your sql server ?

2012?

i am posting the rdlc and the data file served me to execute the report

you will have to put the mdb on C:\ if you want it to work for...

ok good

i don't know if the logic is still correct, i put a max() on the copay and remove it from the group

here is the code:

SELECT HR.MRN MRN,

...

can you try this ?

i changed the join to an exists subquery

SELECT HR.MRN MRN,

HR.FIRST_NAME FirstName,

HR.LAST_NAME LastName,

...

ok no problem 🙂

can you repost your query with the last modification you made please ?

and try to select all the field from your join table, there must be a...

OK good you made some improvements on your suery

I looked at the result you got

I wonder why the birthday is different for the same line?

Maybe you have a...

OK but if you want to list all insurance you don't need any filter on the where clause for Insurance table

But if you need specific insurance to be listed then...

why do you need a where clause Insurance = Insurance X ?

If you do that of course you will get only lines with Insurance X

I don't get the logic you...

On which table is located Patient information and Insurance informtation ?

Hi

Can you post the complete query please?

Maybe you need to do a LEFT JOIN.

Is this the final result you wanted ?

see picture

I have managed to edit it using reportin builder

Is the finla result has to look like the demo or demo2 ? I am quite confused because what you write on...

You're welcome

Sorry it did not help

I am running out of suggestions

I hope someone else on this forum will solve this issue

Then you have to specify the full path of the dtexec located on the programfilesx86

It's to be sure it is not a 32bits/64bits issue.

I don't know what exactly is on your package

Maybe you use a driver which is only working on 32bits...