No,

I am trying directly via SSRS

Thank you very much for your replies.

I have solved the issue with your help..

Thank you very much for your great helps. I will try to solve other issues. And believe that it was a great vision to learn something.

Regards

I have modified your code like below.Because the main idea here is to get individual sums of lfisno columns.

I have also added the lfisno column to the dynamic SQL section

Unfortunately...

Oh..What can I say.It is really a crazy perfect solution.

SELECT m.smodel,c.smodel AS col,m.lIlaveMaliyetTutar * c.lbrutfiyat/1000 AS RESULT

INTO #subresults

But the value 1000 is the sum of the lbrutfiyat values. How...

I think I have found something, and my resultset is as follows:

lfisno smodel ...

I will try to explain it for the stock code XXXXXX row:

SUM of HA values is 1000. (100+500+400)

'159 010 100' ---> 166.67 x (100/1000) = 16.667

'159 010 106'----> 166.68...

Sorry,

my insert statements like below:

INSERT INTO mytest values('XXXXXXXX','9999999',2,'FA',1,166.67)

GO

UNION ALL

INSERT INTO mytest values('159 010 100','9999999',4,'HA',100,0)

GO

UNION ALL

INSERT INTO mytest values('159 010 106','9999999',4,'HA',500,0)

GO

UNION ALL

INSERT INTO mytest values('159 010 105','9999999',4,'HA',400,0)

GO

UNION...

Waynes,

Thank you very much for your reply and also I am sorry for my mistake.

here is my table structure:

create table mytest

(

smodel varchar(50),

lfisno varchar(50),

nstoktipi int,

sfistipi char(50),

lbrutfiyat float,

lIlaveMaliyetTutar float

)

I have inserted some...

Thank you very much for your great helps.

I have also tried to set them as a single dataset. And my MDX query is like below:

SELECT [[Measures].[Satis Miktari] ON Columns,

{STRTOSET('[Dim...

Thank you very much for your reply.

I have tried to apply your code but I got the following error:

SELECT [[Measures].[Satis Miktari] ON Columns,

{STRTOSET('[Dim Time].[Week Of Year].&[@MyWeekParamater]') ,

STRTOSET('[Dim Time].[Week Of...

Hello,

This is a cross-tab report format.You can also use PIVOT command in SQL Server 2005 environment.

Here is a link for you:

http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/

I hope it helps you

Ok...You are exactly right..

Thanks again

It works like a ferrari... 🙂

Now I will try to extend this procedure by using "business days=working days" of a week..Is it possible to use working days of a week?

THANK...

Oh god!!!!!

Where were you :):):)

Well, viewer count exceeded 700 🙂

Thank you very much for your replies (also thanks to all readers..:) ).If it possible I would like to ask...