Thank u Kevin and coldcoffee for your help. I will try your logic and revert back to u.

Thanks a lot.

Sachin

yeah atif that is want i wanted to do. There are almost 100 rows and i m deleting manually.

If u can help me it will be a great help.

Thanks a lot for responding to my issues

There is no link in your message please post if any

Hi Raunak, I didn't find how to create linked reports.

Is there any other way of doing it.

Thank u for your suggestion. I will revert back to u once it is done.

Thank you

Hi,

Here are the steps

1. Click on layout tab of your report and select the table.

2. right click on the table you selected and select properties.

3. properties-->Groups-->Add--> and write...

Thank u Raunak. The expression in the first link you have given worked fine.

Thanks a lot.

Sachin

Thank u Lowell Thanks a lot man.

It worked fine. Big headache i was trying to solve this from afternoon 🙂

Thank u very much.

This is 2nd time you are helping me.

Thanks...

Really good suggestion will definitely work.

Thank you very much

kshitij kumar

Thank u Lowell for your answer but i have to pass a date value to this stored procedure from front end.

So in which shall i pass either in mm/dd/yyy or...

Thank you Lowell your logic really worked. Thank you so much. I was badly in need of this answer man.

Thank u again.

Sachin

ALTER PROCEDURE absent_report

@FROMDATE DATETIME,

@TODATE DATETIME

AS

BEGIN

CREATE TABLE #TEMP_ABSENT_TBL(CNO VARCHAR(20), EMPNAME VARCHAR(100), AB_DATE VARCHAR(15))

INSERT INTO #TEMP_ABSENT_TBL(CNO, EMPNAME, AB_DATE)

SELECT CardID, FirstName + ' ' + ISNULL(LastName, ' '), ' ' FROM Card

CREATE TABLE...

Hey Dave

Thanks a lot for your answer. Your logic may find solution to my problem.

Thank you very much man. I will check with your logic and revert back to...

I have got it done. I added send mail task and configured smtp with help of admin and it was successful.