Reporting Services - Recovering Source Code
Mar 7, 2008
Hi all,
I am in a situation where some reports were developed by a colleague who left the company.
The reports were published on the server but since the code behind the reports was deleted inadvertently.
We don't have documentation about them.
My questions are:
is there a way to recover the source code?
is there a way to produce a report showing a list of the reports and the underlying data straucture/stored procedure, even in cases where the RDL is missing (i.e. from the published report)?
Many thanks in advance
Massimo
View 9 Replies
ADVERTISEMENT
Jul 29, 2015
We had a server give out on us completely. All that is left is a back up of the SSRS database. We have been able to get a new SSRS environment working but the symmetric key doesn't seem to work. Reports will run if we delete all sensitive data through the Config manager and reenter the connection strings into the datasource but if we can get the symmetric key saved in the ReportingServices database to work correctly it will save us a ton of effort. Can we make use of the symmetric key saved in the ReportServer.dbo.Keys table?
View 2 Replies
View Related
Dec 10, 2007
My requirement for the parameter is multivalue parameter with a text box. for example when user enters aa15 it need to include product aa15. when the user enters aa15, aa16, zz15 than it needs to include all the three products. the last case is when the user enters AA** than i need to inclued all the products start with AA. when i use default multivalue parameter with data source analytical services than i am getting a drop down box. I dont want that. I need a text box where user can enter the value.
1. In sql we have a like key word to query . for example select * from product where product like "AA%".
what is equavalent mdx query to get such results ?
2.How to impliment the multivalue parameters without using dropdown box?
View 1 Replies
View Related
May 15, 2007
Hi all,
Till now all the reports for our application was created in Reporting Services 2005 with SQL Server Database(OLTP) stored procedures.
Most of the reports take 10 to 15 report Parameters and all are multi valued.
Now because of the slow response time,we have decided to use OLAP cubes data source. We have created the OLAP cube in Microsoft Analysis Services.
Can someone tell me how to use the report parameters to query the Cube.
Any links,books for reference would be of great help..
Thanks,
Looking forward to your replies
View 3 Replies
View Related
Jan 22, 2008
Hi,
I'm getting the below mentioned error when i tried to open the sample reporting services code in Visual studio 2005
The application for project 'C:Program FilesMicrosoft SQL Server90SamplesReporting ServicesApplication SamplesFindRenderSave SamplecsFindRenderSaveFindRenderSaveCS.csproj' is not installed.
Make sure the application for the project type (.csproj) is installed.
In the Project types in Visual stuido i dont have Visual Basic projects or Visual c# projects.Please let me know how to install these projects types on the existing Visual studio and pls give me the link for downloading these project types.
Regards,
Prabhanjana
View 3 Replies
View Related
Jun 6, 2007
I created a class library which uses a web reference
My SSRS report uses the class through its custom code
I copied the dll & dll.config of the class library to the VS2005 private assembllies and the report works
I copied the dll & dd.config to the reportserver bin and gave the assembly full trust by adding the necessary code group
I even added a code group the give the dll.config file full trust as well
Yet on Repost server, the report does not work
Any ideas
I suspect it is a permission problem
View 4 Replies
View Related
Apr 24, 2015
Can we call custom code in parent report, which written in the subreport.
View 5 Replies
View Related
Aug 30, 2007
Does anyone know if this box will accept VB.Net code or just VB code (old style) .... nothing indicated within the applicaiton IDE ....
Thanks ...
View 1 Replies
View Related
Apr 9, 2006
Hi
I have created an SSIS Package which provides Data to a DataReaderDestination. Next I have uncommented SSIS support in rsreportserver.config and rsreportdesigner.config
After that I have set up a shared Datasource in ReportServer and created a Report using that DS of type SSIS.
/FILE D:ETLReportingDataService.dtsx
When trying to see the report using http://localhost/reports I get a message that tells me that the package fails to execute. It does so well when debugging, so my guess is that there is some security issue.
It also does not work in preview dialog in VS. The error message there is "Cannot read the next data row for the data set dsSSIS. Object refernece not set to an instance of an obj.
I haved tried several sec. config-scenarios for the shared datasource. No change
I am using sql 2005 std, march sp1 ctp
Does anyone have a clue what could be the cause of my problem
Thaks in Advance
Alex
View 2 Replies
View Related
May 15, 2015
I've been getting this error message a lot in recent days and I really don't know why.
When I preview the report in Visual Studio, the report runs without error.
When I integrated the report to run within the application, I kept getting the following error message:
"The source of the report definition has not been specified"...
View 4 Replies
View Related
Jan 19, 2007
Hi all.
I have a Application developed on VB2005 with the reports (processed local) from Microsoft Reporting Services 2005.
I would like to know how can i use the value of a variable to be displayed on a textbox on my report.
Thanks for the help.
Best regards.
dp
View 7 Replies
View Related
May 21, 2015
Below is code I am using to create a heatmap in SSRS. THe code seems to be working well except for one glitch. Sometimes numbers in the "middle of the pack" are white. Obviously they should be one the of colors listed below. Why numbers would be white when I declared only white for IsNothing.
Public Function GetHeatmapColor(ByVal textBoxValue, ByVal minDataSetValue, ByVal maxDataSetValue) As String
Dim colours As String() = New String() {"White","DarkGreen","Green","ForestGreen","LimeGreen","YellowGreen","Yellow","Gold","Orange","DarkOrange","OrangeRed","Red"}
If IsNothing(textBoxValue) = True Then
Return colours(0)
[Code] ....
View 6 Replies
View Related
May 11, 2007
Hi,
I have a problem that seems impossible to resolve in RS but i need to be sure.
I'm creating an Embedded Code in VB of course, and i need to run a query within my code to be able to continue the rest of the code depending on the result of my query.
The problem is there is no adodb.recordset or adodb.connection like in normal VB.
So i created my query like as string:
Dim Sql as String
Sql="Select ..." into "from ........where...."
At this point if it was in normal VB,
i would do
MyConnection.Execute(SQL)
and then i will get the answer in my recordset.
I need to know if there is a way in RS to run my query since I cannot use use adodb ....
If it's not really possible, is there way to go around this problem????
Thanks for the Help
Mike
View 1 Replies
View Related
May 19, 2015
I want to run SSRS report directly by connecting Excel as a data source. The report runs properly from SSDT, but when it is run from Report manager, some users cannot access the Excel connection and the report execution fails. I am using SSRS 2012 and Excel 2010.I have created the ODBC data connection in SSRS and when I use 'Windows Integrated Security' option for credentials, the connection gets successful. But the problem is that all users does not have permissions to access the Excel inline, but they should get the report working.How can I store the credentials to access the Excel in SSRS with a specific username and password?
View 4 Replies
View Related
Apr 3, 2008
I have set up a report on reporting services and deployed it on a server. (server A)
The data comes from 2 databases - one on Server A and one on server B
I can view the reports when logged into Server A, but if I try to view them from a networked PC I get the following message:
An error has occurred during report processing.
Cannot create a connection to data source 'byvshs01'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Byvshs01 is Server B.
However, if I remove the data from server B from the report, I can view it ok. So it seems you can view data from a DB located on the server that hosts the reports, but not if the DB is located elsewhere.
Is there any way around this?
View 6 Replies
View Related
Apr 21, 2015
An error has occurred during report processing. (rsProcessingAborted)...The execution failed for the shared data set 'DataSet1'. (rsDataSet ExecutionError )...Cannot create a connection to data source ' Data source for shared dataset'. (rsErrorOpeningConnection)...the above error message I get on the published report, but everything works fine when I do a preview in Visual Studio.How can I see exactely what is wrong?
View 22 Replies
View Related
Nov 5, 2015
When Datazen caches a data source, it sometimes says that the data was truncated. What factors are involved in the truncation and what I might be able to do to expand the size of cached elements to avoid truncation? My only current solution is to make the data source "Real Time" rather than cached.
View 3 Replies
View Related
Jan 19, 2007
Is Custom code of Sql Reporting services will only support VB Coding? Can't we use Java Script coding into the custom code of SQL Reporting services?
View 3 Replies
View Related
Apr 2, 2008
I have tried several times to install Reporting Services 2000. I get 75% done and then receive the following:
Setup Error
An error has occured during setup. An error has occured while performing the following setup action. Please select help for more information about this error. You may be able to skip this action by selecting ignore, or retry the action by selecting retry. Selecting cancel will end the installation of SQL Server.
Configuring Microsoft SQL Server
Error Code: 1603
I have followed the resolution and continue to receive the above error. The server is running Windows 2003 standard edition, IIS 6 is installed and working, MDAC 2.8x installed, MS SQL 2000 and service pack 4 installed and working.The domain controller is SBS 2003 SR2.
Any help or direction would be appreciated
View 2 Replies
View Related
Jul 2, 2015
I have SCCM 2012 R2. I'm working on a custom report, using MS SQL Server Report Builder. I have other custom reports that work fine....they prompt for a collection and return results just on that one collection. The problem with the one I'm working on now is that it runs fine except for that....it prompts for a collection, lets you choose one collection,returns the desired info on each line, but it returns all systems, not just the one collection you selected. IOW, I'm having trouble getting the "where" clause to work right.
Here is the code for a report that works (it returns the selected collection and counts the patches needed by each machine):
select
CS.Name0,
CS.UserName0,
CS.ResourceID,
case
when (sum(case when UCS.status=2 then 1 else 0 end))>0 then ((cast(sum(case when UCS.status=2 then 1 else 0 end)as int)))
[code]....
Here is the code for the report that I'm having trouble with. What you see runs but it has none of the collection selection code I've tried since I haven't gotten it to work:
SELECT
DISTINCT(CPU.SystemName0) AS [System Name],
CPU.Manufacturer0 AS Manufacturer,
CPU.Name0 AS Name,
COUNT(CPU.ResourceID) AS [Number of CPUs],
CPU.NumberOfCores0 AS [Number of Cores per CPU],
[Code] ....
get the collection selection code to work in the second (processor count) sample?
View 14 Replies
View Related
Sep 11, 2013
I've made a Report porting from SS2008 to SS2008.
In a textbox I use a:
Number -> Custom Format
like these:
=Code.FormatString(Fields!NumDecRpt.Value)
but gives me the "Unrecognized identifier" red squiggle.
My FormatString function (in the rdl file) is this:
Public Shared Function FormatString(ByVal Decimals as object) As String
dim format = "N0"
if not (Decimals is nothing or Decimals is System.DBNull.Value) then
dim decs as integer
decs = Convert.ToInt32(Decimals)
if decs>0 then
format = "N"+decs.ToString()
end if
end if
return format
End Function
What's wrong with this?
View 11 Replies
View Related
Apr 10, 2008
I have tried several times to install Reporting Services 2000. I get 75% done and then receive the following:
Setup Error
An error has occured during setup. An error has occured while performing the following setup action. Please select help for more information about this error. You may be able to skip this action by selecting ignore, or retry the action by selecting retry. Selecting cancel will end the installation of SQL Server.
Configuring Microsoft SQL Server
Error Code: 1603
I have followed the resolution and continue to receive the above error. The server is running Windows 2003 standard edition, IIS 6 is installed and working, MDAC 2.8x installed, MS SQL 2000 and service pack 4 installed and working.The domain controller is SBS 2003 SR2.
Any help or direction would be appreciated
View 5 Replies
View Related
Dec 19, 2006
I have data on server A and the report server on server B.
I have created reports that I can run through report manager (on server B).
I have depolyed the reports but when I try to run the reports on client computers I get the following error:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'ABCD'. (rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied.
I have tried setting different credentials ... windows security, specified username and password to credentials not required ...
All give above error.
TIA
View 4 Replies
View Related
Aug 2, 2011
Is it possible to configure a datasource using data from a web service (java) requiring basic http authentication?
View 4 Replies
View Related
Jun 16, 2015
i have to to combine two dataset in single matrix my sample scenario in below attached for reference.
in this first matrix values from one server and second one is another one server.
how to connect these to for getting desired result of thrid matirx.
in this 1,2,3,4,5,6 is in column grouping
how to solve this in using LOOKUP or CUSTOM CODE
View 9 Replies
View Related
May 12, 2015
Could we use SSRS Shared Dataset as a source to the SSIS package?
View 3 Replies
View Related
Apr 28, 2015
I have a question about ssrs security. In report manager I have set a list of users as browsers, and the builtin administrators are content manager in the parent folder where reports are. A user that is not an administrator and neither a user I added, has access to reports.
I'm thinking this person is having access because the data source of the reports use a administrator account to connect to the analysis services using the option Credentials stored securely in the report server with the 2 checkboxes marked (use as windows credentials when connecting to the data source and impersonate the authenticated user).
I simply marked this option because SSRS is in 1 server and SSAS in other and I think kerberos need to be configured and I haven't looked into it, but I think the report access is separated from the data source.
View 2 Replies
View Related
Dec 18, 2007
Hi
This is the code which I have written in code window.
Public Shared Function CalcLocalFactor(ByVal CalcLifeCode As Integer, ByVal CalcFiscalAge As Integer, ByVal CalcLifeYearsUsed As Double, ByVal CalcLocConvention As String, ByVal CalcSRate As Integer) As Double
Dim locCalcFiscalAge As Integer = 0
Dim locFactor As Double= 1.0
Dim locFactor1 As Double = 1.0
Dim REM1 As Integer = 1
Dim DEP As Double = 0
Dim YR As Integer
Dim HALF_YEAR As Double
Dim LINEAR As Double
Dim MACR As Double
If CalcFiscalAge > CalcLifeCode + 1 Then
locCalcFiscalAge = 0
locFactor = 1.0
End If
If (CalcLocConvention <> "HALF-YEAR" And CalcLifeYearsUsed < CalcLifeCode) Then
locFactor = Math.Round((CalcLifeYearsUsed / CalcLifeCode), 4)
End If
If (CalcLocConvention = "HALF-YEAR") Then
for YR = 1 to CalcFiscalAge step 1
If YR = CalcLifeCode + 1 Then
locFactor1 = 1
Exit For
End If
If (YR = 1 Or YR = CalcFiscalAge) Then
HALF_YEAR = 2
Else
HALF_YEAR = 1
End If
LINEAR = Math.Round(REM1 / (CalcLifeCode - YR + 1.5) / HALF_YEAR, 4)
MACR = Math.Round(REM1 / CalcLifeCode * CalcSRate / HALF_YEAR, 4)
If MACR >= LINEAR Then
DEP = MACR
Else
DEP = LINEAR
End If
locFactor1 = locFactor1 + DEP
REM1 = 1 - locFactor1
locFactor = locFactor1
Next
End If
Return locFactor
End Function
I'm calling this code in a Report Parameter like below:
=Code.CalcLocalFactor(Parameters!CalcLifeCode.Value,Parameters!CalcFiscalAge.Value,Parameters!CalcLifeYearsUsed.Value,Parameters!CalcLifeYearsUsed.Value, Parameters!CalcSRate.Value )
It is working fine for the first record where as for other records, the value is not getting changed. i.e. the first records value is coming repeatedly for all other records also.
How can I dynamically change the parameter values of the function?
Parameter is not accepting directly the field names, hence I used other parameter to initialize the field and used that parameter for this.
Ex. Parameter Name ; FieldPurchDate (internal) FieldName : PURCHDATE
Other parameter: FieldInDate (internal) FieldName : InDate
While initializing the new parameter CalcPurchDate,, I used an expression for this: Parameters!CalcFiscalAge.Value
=iif(Parameters!FieldPurchDate.Value is nothing, Parameters!FieldInDate.Value,Parameters!FieldPurchDate.Value)
and using this CalcPurchDate for processing of the parameter:
These are some of the things , I am doing ....
Please let me know how to fix this issue...
Thanks in advance
Regards,
Radhika
View 3 Replies
View Related
Apr 20, 2015
I have a SSRS report that parses RTF to TXT and displays it in a report. The report works fine and everything displays correctly. The subscription email, however, contains a report with errors: Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture= neutral,PublicKeyToken=b77a5c561934e089' failed.The report contains embedded code as well as references to System.Security and System. Windows. Forms. I've updated .....Reporting ServicesReportServer ssrvpolicy.config and ....Reporting ServicesReportManager smgrpolicy.config to change permissions to FullTrust.
View 2 Replies
View Related
Apr 16, 2007
Hi, all experts here,
Thank you very much for your kind attention.
As we know the limited features on SQL Server 2005 Reporting Services, but we can build advanced features for it with coding on it. Would please any experts shed me any light on it in a summary like what advanced features could be added with coding on SQL Server 2005 Reporting Services?
Thanks a lot in advance for your kind help and advices. And I am looking forward to hearing from you.
With best regards,
Yours sincerely,
View 3 Replies
View Related
Jul 16, 2009
I am building a webapp that calls an SSRS instance to display a report based on another servers web service.I can make a call from the ssrs server using this in the RDL:
<Query>
<Method Namespace="http://machine/webservices" Name="HelloUser">
<Parameters>
<Parameter Name="user">
<DefaultValue>Craig</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
</Query>
This works no problem. but.. I want to have the user parameter "Craig" be a parameter passed in from the web app. If it were a regular SQL data source you would put @user in the query. How do you do it with XML text queries?
View 5 Replies
View Related
Nov 3, 2015
When I click on the DataSet Query Desginer there is an Error Source:.NetSqlClient Data Provider. why this error comes and I have executed the SQL query in SSMS succesfully and the result comes. However this is causing the report from the report manager to fail.
View 8 Replies
View Related
Nov 29, 2010
I am attempting to pass report parameters to my query. My report's data source is a WCF web service. I can run normal queries fine, but I have found that without the know-how to pass parameters to my query I am limited with my capabilities.
Assume a string parameter named "Name" with a specified default value of "Jmachol90", how would I pass that into the following query at the designated place:
<Query>
<Method Namespace="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09" Name="SecurityPrincipalsGetRequest">
<Parameters>
<Parameter Name="Criteria" Type="XML">
<DefaultValue>
[code]....
View 17 Replies
View Related
