Do anyone has solution.

Do anyone has solution.

Still waiting for the suggestions.

Try the MS forum:

http://technet.microsoft.com/en-us/library/ms159106.aspx

Have you trie the subscription part.

I came across something same problem and able to resolve it by using SLipStream method.

See this link: http://support.microsoft.com/kb/955392

Do you want to extract the only matching condition from Sub table or anything from Sub_data table. Use the current format:

*************************

SELECT md.number,sd.description

from main_data md

Right* Join sub_data sd on (md.vendor_id=sd.vendor_id...

Thanks, the error is:

----------------

[font="Arial"]An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'abc'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server...

Thanks Mike for the query. I appologise for wrongly mentioned info. Here is the correct way:

TId Ttype TAmt

-----------------

101 Cash 100

101 Expense -200

101 Credit -100

101 Debit 100

101 Expense...

Hi Mike,

Please see below:

Select Tid (int), Ttype (varchar(50)), Tamt (float) from GeTbl;

Result (Current)

------------------

TId Ttype TAmt

-----------------

101 Cash -100

101 Expense -200

101 Credit -100

101 Debit -100

101 Expense -150

102 Credit -50...

Verify if the database has being already created. Remove it and try to Re-create it from RS Configuration MGMT.

Hi Mark,

The Query what you provided worked fine. but now when I'm trying to add a new condition in the same query, it didnot work.

The Condition are Under same ID:

1)...

Thanks Mark, it worked for me...:w00t:

Thanks Mark, I will test my code using this way, and will confirm you little later.

The Output will be:

Id Type Amt

-----------------

101 Cash 100

101 Expense 200

-- 101 Credit -100 (skip)

-- 101 Debit 100 (skip) IGNORE these 2 entries under id=101, as Debit+Credit=0

101 Expense...