Ssrs Help Plz

[dotnetrockz]

nenu oka rdl file ni edit cheyyali like i need to remove some columns and add new ones...how do i do it?initila ga report ccreate chesinappudu designer lo add chesthamu kada...ala edit chese afcility untadha?

need help badly....

[mtkr]

[JUJUBI_JULABI]

Create a new solution file .. then add ur RDL file into the solution and you can edit it in the designer.

[smartphone]

You can use report builder from the report manager to make these little changes..

[siri_vennela]

Hi evarikina Already existing KPI report lo MDX use chesi one more row ela insert cheyalo idea undha ????

[siri_vennela]

Calling anni valani villani pilavaka potha ikkada evarina ee report ela cheyalo chepochu kadha morning nunchi WFH petti mari think chesthuna ratamle

[Spartan]

[img]http://www.gifsoup.com/view2/1236730/brahmi-o.gif[/img]

[siri_vennela]

Monna edho manchi challenging job kavali anni post chesav kadha na report cheyyochu kadha

free ga odhule bholedantha knowledge istha niku

[dotnetrockz]

[url="http://youtu.be/bDZHQKDlwv8"]http://youtu.be/bDZHQKDlwv8[/url]

[siri_vennela]

Report modification ii know

na problem already stored procedure use chesi KPI report chesanu

aa report loki i want to insert other row using MDX query not SQL

i want to know a way to merge both sql and mdx

[smartphone]

It can't be done in the report itself. Call the stored procedure from the report to get the third result set that you need for your final report. Inside the stored procedure, you can use call an SQL/MDX query by using the OPENQUERY function. You'll have to set up a linked server on the SQL Server box that uses an Analysis Services provider, like this:
EXEC master.dbo.sp_addlinkedserver @server = N'AW2008', @srvproduct=N'SSAS', @provider=N'MSOLAP', @datasrc=N'', @catalog=N'Adventure Works 2008'
You can then wrap an MDX query in an OPENQUERY function, and select "columnns" from the function by referencing the column in double-quotes - like this:
select "[Measures].[Sales Amount]" from OPENQUERY(AW2008, 'select [Measures].[Sales Amount] on columns from [Adventure Works]')

[siri_vennela]

Linked server is it some thing need to be done at server level ??

Right now your your 3 boxes like ssis ssas ssrs are lying in same server

Does it still need to be linked up ???