dotnetrockz Posted April 10, 2012 Report Share Posted April 10, 2012 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.... Link to comment Share on other sites More sharing options...
mtkr Posted April 10, 2012 Report Share Posted April 10, 2012 Link to comment Share on other sites More sharing options...
JUJUBI_JULABI Posted April 10, 2012 Report Share Posted April 10, 2012 Create a new solution file .. then add ur RDL file into the solution and you can edit it in the designer. Link to comment Share on other sites More sharing options...
smartphone Posted April 10, 2012 Report Share Posted April 10, 2012 You can use report builder from the report manager to make these little changes.. Link to comment Share on other sites More sharing options...
siri_vennela Posted April 10, 2012 Report Share Posted April 10, 2012 Hi evarikina Already existing KPI report lo MDX use chesi one more row ela insert cheyalo idea undha ???? Link to comment Share on other sites More sharing options...
siri_vennela Posted April 11, 2012 Report Share Posted April 11, 2012 Calling anni valani villani pilavaka potha ikkada evarina ee report ela cheyalo chepochu kadha morning nunchi WFH petti mari think chesthuna ratamle Link to comment Share on other sites More sharing options...
Spartan Posted April 11, 2012 Report Share Posted April 11, 2012 [img]http://www.gifsoup.com/view2/1236730/brahmi-o.gif[/img] Link to comment Share on other sites More sharing options...
siri_vennela Posted April 11, 2012 Report Share Posted April 11, 2012 Monna edho manchi challenging job kavali anni post chesav kadha na report cheyyochu kadha free ga odhule bholedantha knowledge istha niku Link to comment Share on other sites More sharing options...
dotnetrockz Posted April 11, 2012 Author Report Share Posted April 11, 2012 [url="http://youtu.be/bDZHQKDlwv8"]http://youtu.be/bDZHQKDlwv8[/url] Link to comment Share on other sites More sharing options...
siri_vennela Posted April 12, 2012 Report Share Posted April 12, 2012 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 Link to comment Share on other sites More sharing options...
smartphone Posted April 12, 2012 Report Share Posted April 12, 2012 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]') Link to comment Share on other sites More sharing options...
siri_vennela Posted April 12, 2012 Report Share Posted April 12, 2012 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 ??? Link to comment Share on other sites More sharing options...
Recommended Posts