I have a Javascript Function provided by our .NET Developer Team.
This code has to be used in a "Text Box" and in Text Box "Action Property" this will be added in the "Go To URL" section.
But Since i have no understanding of Javascript i am not been able to add it.I tried a method of adding this code in the expression section, but it gives error of "End of statement" in Preview section.
how to call javascript function in SSRS Reports?
View 3 Replies View RelatedI need to hide the address bar in the SSRS report pop-up using the JavaScript. I tried using below property
"&rc:Toolbar=False"
="javascript:void(window.open('https://dev/PWA/ProjectBICenter/_vti_bin/reportserver?https://dev/PWA/ProjectBICenter/Report Library/ProjectStatusReport.rdl&rv:Paramode=Hidden&rc:Toolbar=False&rv:HeaderArea=None&vuidProjectUID=Fields!ProjectUID.Value','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
What I am missing using this property?
We are setting up a new reporting environment for our client and as part of the deliverable I need to achieve the following two things.
1. Most of our reports are snapshot reports and all the data needed gets populated into transaction DB tables from a batch program. Some of batches run monthly and others on request, we use a scheduling tool to run these batches. For monthly running batches since I know when they run, I have scheduled snapshot report for the respective dates. But the batch that run on request have no fixed schedule so my question : Is there a way I can invoke or kick off a particular SSRS snapshot Report as soon as the batch completes running. For example if a on-request batch program finishes running today at 6PM , I would like to create a snapshot report as soon as the batch finishes running. Is this achievable ?!
2. As I mentioned above most of the reports are snapshot reports and client wants Report history of 10yrs. We have about 170 reports on the whole which run monthly/daily/yearly. Is there a best practice known in maintaining all the reports and where to store them?
We are using MS SQL Server Reporting Services 2014.
I am using the QRCode4CS class [URL] .... to generate QR codes.
I can use the following code to successfully return a bitmap image to a picturebox in a Windows Form Application.
public class CreateQRCodeClass
{
public static Image CreateQRCodeImage(string inputString)
{
QRCode4CS.QRCode qrcode = new QRCode4CS.QRCode(new QRCode4CS.Options(inputString));
qrcode.Make();
[Code] ....
In trying to adapt the same code (below) to display a QR code in an SSRS report I get the error "There is an error on line 1 of custom code: [BC30311] Value of type 'System.Drawing.Image' cannot be converted to '1-dimensional array of Byte.'
Here is the custom code I am using.
Public Function QRCode(ByVal RetailerId As String) as Byte()
Return QRCode4CSCreateQRCode.CreateQRCodeClass.CreateQRCodeImage(RetailerId)
End Function
Here is the revised custom assembly.
public class CreateQRCodeClass
{
public static byte[] CreateQRCodeImage(string inputString)
{
QRCode4CS.QRCode qrcode = new QRCode4CS.QRCode(new QRCode4CS.Options(inputString));
qrcode.Make();
Image canvas = new Bitmap(86, 86);
[Code] ....
What data type can I successfully return to SSRS to display the image?
Is there any way to get SSRS 2014 report viewer to run in standards mode? We currently host SSRS report viewer in a standards mode IFrame. Seems to work fine for all browsers but IE8. In IE8, the report detail is missing.
I'm guessing that SSRS Viewer on IE 8 requires Quirks mode.
I noticed this article which states that SSRS 2014 Viewer only works in quirks mode.
Rendering issues with SQL Server Reporting Services reports in Internet Explorer
How do you get the SSRS viewer to run on IE8 in standards mode?
I am trying to open a pop up window in SSRS without any parameters (just need it to go to this report) and when I click on the link from the main report nothing happens. I have done countless numbers of these with passing parameters, just never without. Am I missing something painfully obvious?
="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"&"/Billing Reports/links/ICDQuick)"
I have 3 SSRS 2014 (Dev, UAT and Prod). I would like to change background colors of each environment and customize the title 'SQL Server Reporting Services' to ' SSRS Development'.
I prefer to implement both, a background color change and a title change. The reason for this is to clarify to end users which environment they are working with.
Where can I make those minimal changes in SSRS 2014.
I'm selecting the last latitude & longitude input from my database to put into the Google maps javascript function.
This is how I retrieve the longitude:
<asp:SqlDataSource ID="lon" runat="server" ConnectionString="<%$ ConnectionStrings:LocateThis %>"
SelectCommand= "SELECT @lon= SELECT [lon] lon FROM [location] WHERE time = (SELECT MAX(time) FROM [location] where year < 2008)">
</asp:SqlDataSource>
I wish to input the latitude & longitude into the JAVASCRIPT function (contained in the HTML head before the ASP) something like this:
var map = new GMap2(document.getElementById("map"));var lat = <%=lat%>;var lon = <%=lon%>;var center = new GLatLng(lat,lon);map.setCenter(center, 13);
However, lat & long do not contain the retrieved result but rather a useless System.something string.
How do I assign the retrieved results to these variables and port them over to Javascript as required?
Many thanks!
Hello,
Have a problem here needs urgent help. We are on SQL Server 2005, just recently installed SP2. Not sure if the problem is related to that but just now I tried to delete a user from a report (Properties > Security > Delete) I got a JavaScript error exclaimation mark at the bottom of my browser, when I clicked on it, it showed javascript error: 'return' statement outside of function.
The delete user function worked well all along until today, our IT installed SQL 2005 SP2 last week, not sure if it is related. Any solution? (uninstalling SP2 is not an option). and all other javascript functions worked well except the remove user in the security setting..I have no idea what is wrong..
Please advise!! HELP!!!!!
Thanks in advance.
casey
I am playing around in a test environment with SQL Server 2014. I have a question about the default location of the report server databases when you have multiple report server instances installed on one server.
I did a very simple install of SQL Server 2014 with the database and Reporting Services in Native Mode (install only) features selected. Accepting the default locations, I ended up with the following locations as you would expect:
C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVER
C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVER
Running the Reporting Services Configuration Manager, I created the Report Server database. After creating the Report Server database, the related files will be located below in the SQL folder as I would expect.
C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATA
Next I installed another instance, which I called Test, of SQL Server 2014 like I did above. I now have the following folder structure the Test instance as I expect.
C:Program FilesMicrosoft SQL ServerMSSQL12.TEST
C:Program FilesMicrosoft SQL ServerMSRS12.TEST
Running the Reporting Services Configuration Manager, I select the Test instance and create the Report Server Test instance database.
My first thought would be that the Test instance Report Server database would be in the following location:
C:Program FilesMicrosoft SQL ServerMSSQL12.TESTMSSQLDATA
Instead this database is located with the default instance Report Server database:
C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATA
I need to create a website which has login details and then shows a list of reports for my clients?
Clients are external so would be website based with a login screen.
Ive successfully cloned an SSRS VM Server within a scale out deployment to REPLACE a current physical machine. This wasn't too difficult.
The issue im having now is in creating a new SQL 2014 Environment with 3 SSRS nodes. Ive taken the time to build one up. Changed all my config files, installed all components etc & tweaks needed within my company...
I have now hit a brick wall though. Ive cloned this first server twice to give me 3 nodes. This is a new environment so the issue I have is that the rsreportserver.config files all now have the same InstallationID. I dont have any existing nodes to overwrite these files with. So when I attach the nodes to the database they will update the keys table with the same InstallationID as the first node and none will work.
Any way to force the SSRS setup to re-generate an installation ID - by repair maybe? Or is this something I can manually just make up?
Writing a SQL Function as below
the input parameter for function should be datetime of sql datetimeformat
and out put should be a string = yyyymmdd1 or yyyymmdd2
The last character 1 or 2 based on below condition
if time is between 6AM and 5.59PM then 1
if 6PM to 5.59AM then 2
I have rather simple CLR function:
[SqlFunction(IsDeterministic = true, DataAccess = DataAccessKind.None)]
public static SqlString GetUserName()
{
return (SqlString)WindowsIdentity.GetCurrent().Name;
}
When I get result from .NET console app, I get correct answer "JungleSektor". However, when SQL Server executes this code, it gives me "NT ServiceMSSQL $ SQL2014". How to get correct result?
I have 2 databases on the same server
One has a function, the other has the tables and views
using dba
select dbo.function(t.column) as x from dbb.dbo.table as t
gives m an invalid object name of dbo.table
using dba
select top 1 * from dbb.dbo.table works fine.
also if i create the function on the same db it works.
Hi,
I'm having problems navigating from one report to another one if the second report has a multi-valued report parameter. When I navigate to the second report, I don't pass any parameters, but I get an error "parameter is missing a value" for the multi-valued report parameter. I have it setup as allow "multi-value" and "blank value". Any idea what the issue might be?
Thanks.
I need to grab the value of the ReportFolder built-in global filed to a particular report on Report Manager, i.e., the full path to a particular report, when the user runs/executes the particular report, SSRS. Once I get this I need to process the path and get the Parent folder to the report and pass that to a stored procedure to do some business logic.
View 0 Replies View RelatedI have a report which works fine with visual studio but when i uploaded the same into report server and tries to access it through IE or chrome or anything its dam slow.
how to get rid of this issue?
I am passing a field value from main report to a parameter in a drill through sub report. But some field values contain 'special characters'. Those field values that contain special characters are not working for drill through. Javascript code to include special characters to pass to sub report parameter?
View 3 Replies View RelatedI'm trying to create a simple function that will do a count on a table. I want to pass the table name in form of a parameter to the variable and this function will return the count as an int. See my function below...
CREATE FUNCTION count_rows (@tablename varchar(100)
RETURNS int AS
BEGIN
DECLARE @emp_count AS int
declare @declaration varchar(100)
[Code] ....
The errors I am getting are as follows:
Msg 102, Level 15, State 1, Procedure count_rows, Line 3
Incorrect syntax near 'RETURNS'.
Msg 102, Level 15, State 1, Procedure count_rows, Line 10
Incorrect syntax near '@declaration'.
Msg 178, Level 15, State 1, Procedure count_rows, Line 14
A RETURN statement with a return value cannot be used in this context.
I have a heavy database , More than 100 GB only for six month .every Query on it takes me along time and I dont have enough space to add more indexes.by a way I decided to do partitioning. I create a partition function , on date filed and all Data records per month was appointed to a separate file.And is partitioning only for Future data entry?
View 9 Replies View RelatedWe have an application that can spit out our Facility Structure into the following format. However, we have a need to take that data and feed it into another system. However, as you can see it is organized in a PARENT / CHILD structure.
Indent Level Key:
1System
2Facility
3Service Line
4Division
5Department
If you notice, each additional row is the child row to its parent above it as long as the Indent Level Key continues to increment. Once we start going back up the structure we essentially have a new Division/Service Line/or Facility depending on how far back we jump on the Indent Level for that next row. Here is some sample data.
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#Test_Data','U') IS NOT NULL
DROP TABLE #Test_Data
--===== Create the test table with
SET ANSI_NULLS ON
[Code] .....
Is there any way to find Report server database name using T-SQL?
I have SQL server report server instance and authentication credentials.
I can use sys.databases but in case of user had changed ReportDb name at the time of configuration this approach will not work then How I can find?
Hi,
I have several reports for users to view on our Intranet. After installation of SQL 2005 SP2 patch, I cannot delete user or user's authority from Report in Properties Tab. An error message was shown on the status bar. It indicated that JavaScript Error: 'Return' statement outside of function. Seems something wrong with the 'Delete' funciton in SQL 2005 after update. The other functions worked fine. Could you point me out how to fix it or need to install any updates / hotfix. Thanks a lot!
Regards,
Kenneth Lai
Programmer
Error Pic
Message Box
I have a report that gets a Customer_Number parameter and sends a mail with that customer's data.I want my users to be able to get this report's results by sending an email to a certain email address with a customer number in the topic.
View 1 Replies View RelatedI got into confusion while working on DB Growth report for 2012 databases which has compression on.I am analyzing the DB Growth based on MSDB..dbo.backupset table which stores the backup information.
But here it gets tricky, In Previous versions we use "backup_size" column to get actual backup size and estimate the db growth based on the previous all backup file info. But now since compression is on in 2012 the "backup_size" colmuns gives a compressed file size(If i am right) so how do you know the actual backup size to estimate the db growth over a period of time??
We have reports in SharePoint integrated mode which are really slow when compared to native mode. I have been asked to research and give info on what exactly causes the delays.
Any articles which give me information as to what happens when a report is run from SharePoint server and where does it log.
My sa account can not see the tables in the db. but can connect to the server
View 2 Replies View RelatedI know select * into ##tmp1 should work but I get a database connection error.
View 9 Replies View RelatedI ran the Upgrade Adviser Report on a Server and it identifies the Proxy's as being deprecated.
What action is needed?
Object Type: ProxyObject Name: sa-apro-cms
Object Type: ProxyObject Name: sa-apro-payroll
Object Type: ProxyObject Name: sa-pi-sql-agent
I create a report base on categories and sales of goods. Now I have Daily Info about all Products.
But I Need to present this report base on weekly periods. in pivotal format.
I family with pivotal format but change between daily report and weekly report is ambiguous for me.
I found an article on connecting SQL server using JavaScript. http://www.devarticles.com/c/a/JavaScript/Combining-North-Pole-with-South-Pole-JavaScript-with-SQL-Server-2000/
Do you people think it's possible? i try out the code already but something wrong with it. I just copy and paste it to a html file but it comes out with error. Do I miss out something? Thanks.
SY Tee