New answers tagged

1

You already are not using the "same license" for both servers. SSRS is part of the SQL Server license (Standard Edition and above), but it's only covered by your SQL Server license on the same server. IOW, if your report server is on Server A and SQL Server is on Server B, you need to license them both. So yes, if you have acquired a license for ...


0

By default this is not the best place to ask about licensing questions. You should contact a Microsoft partner to get a better answer. Said that, if you have two SQL Server licenses, you can install a new SQL Server using one license and keep the actual SSRS using the old license. IICR, you cannot install two different SQL Server services on two different ...


0

Microsoft makes a reporting migration tool. Reporting Services Migration Tool . One drawback is that the Target server must be SharePoint integrated mode.


1

If you are formatting cells based on group totals and not a row value, you need to use an aggregate and indicate the correct row group scope. In this sample, "UserName" is the name of the row group scope on the Row Groups section of the Grouping pane =IIf(Sum(Fields!CountFailures.Value, "UserName") >=1, "Pink", "White&...


1

Rather than using the rsconfigtool.exe Gui application you can use rsconfig.exe from the command line. It is located in the same Shared Tools directory. rsconfig.exe /? allows you to see the available command line arguments.


0

Done. Defining a parameter 'param2' whose values are integers and captions are strings, the point is the MDX query: select {[Measures].[ID Distinct Count]} on COLUMNS, non empty filter({[DIM ANESTH].[ID].MEMBERS }, [DIM ANESTH].[ID].CURRENTMEMBER.MEMBERVALUE = @param2 ) on ROWS from BDD_PAT_ANESTH


Top 50 recent answers are included