Reporting Services :: SSRS Reports Migration And Management Between Environments

Aug 13, 2015

How to manage the progression of SSRS reports from DEV > TEST > USER > PROD...I can see that you COULD manage this all from within VS however then all the control is in the developers hands and even though you can control access with permissions and stuff, its not very user friendly to provide a tester or business area manager or project manager with VS just so they can publish reports as they are approved.Are their any such tools to manage migration between ssrs servers or something that you could have a user test a report and then do something like "approve/promote" it to the next environment, or is this something we would need to create ourselves?

I can see that there are a few things that allow PROJECTS to be migrated (powershell scripts and something about octopus deploy) but these all seem to be too "big" for our organisation - we generally develop reports as a "logical group" (project) but migrate them individually or in VERY small groups (5 is probably the maximum), however keeping tabs on what report is at what version in what environment is causing our DBA massive migranes...Maybe there is something we can do from TFS or perhaps we need to build a utility app?

View 5 Replies


ADVERTISEMENT

Reporting Services :: KPI In SSRS Reports

Apr 29, 2015

I have a Manager dashbord  report.In this report 1st page contains some tables and 2nd,3rd page contains line charts with tables.Actually what we need is in 1st page tables are pretty simple,we need to add kpi's and shown these tables in kpi. kpi in ssrs and how to add kpi in ssrs reports?

View 2 Replies View Related

Reporting Services :: Publish MDW Reports On SSRS

Jun 1, 2015

Is there a way to publish the MDW (Data Collection) reports (Disk Usage history, Query Statistic history, and Server Activity history ) on SSRS server?! 

It is not logical for all who wants to view the mentioned reports to open the SSMS !  

I've already check [URL] .... there, the writer is suggesting to recreate the reports from scratch on SSRS, that if I could figure their queries, which I don't think the only way that we have!

View 3 Replies View Related

Reporting Services :: SSRS - Join Two Different Reports

Jun 8, 2015

I'm using the SQL Server Reporting Services to build a sales report. 

I'm having two different reports because I need to have a matrix table into one of them.

Is possible to Join two different reports (two different reports.dll) into one? Basically, can I, in the end, export two different reports in only one report?

View 2 Replies View Related

Reporting Services :: How To Use JQuery In SSRS Reports

Jan 1, 2015

I make SSRS Reports and I use SSRS RDL file to perform coding and all..

How can I use jQuery scripts in my Report Server Reports(SSRS) to make it more attractive and user friendly?

View 4 Replies View Related

Reporting Services :: Exporting SSRS Reports To PDF

Jun 2, 2015

I have generated an invoice report is SSRS. It works correctly via Report Builder and the viewer. However if I then export the report to PDF, it throws the formatting of the report off.

As I have mentioned, it is an invoice report. If I print 1 invoice, and export it, everything exports correctly and all formatting is retained. However if i print off and export multiple invoices (range of Invoice 1 to 4), the 1st invoice is exported correctly, but all subsequent ones are not. In so far that where 1 invoice should be printed on 2 pages of A4 paper, it is spread over 7 pages.

The header is one page, then 1 row is on the second page, then a blank page, then another set of data on another page etc. Is it a problem with the page/report sizing/margins?

View 8 Replies View Related

Reporting Services :: Details Of Reports Scheduled On SSRS

Jun 4, 2012

Is there a way to find all SSRS scheduled reports details such as (Report Name, schedule time, mail IDs configured, etc.)?

We have many SCCM reports on SRS, and manual work will take very long time..

View 14 Replies View Related

Reporting Services :: Expand / Collapse All Sub-reports In SSRS

Jul 9, 2015

In my report i have more than 10 sub reports each should be displayed when we click on some label but my requirement is to expand all the sub reports at a time or collapse the sub reports.URL.....problem here is it is a genius solution working beautifully in my local machine but in the client server if i click on the Expand/Collapse radio button it is asking for the parameters again.

View 9 Replies View Related

Reporting Services :: SSRS Reports - Unable To Open In PDF

May 15, 2015

I have deployed SSRS reports to the Report Server, but am not able to open them in PDF. 

View 3 Replies View Related

Reporting Services :: SSRS Reports Are Not Working In IE11

Sep 7, 2015

We had migrated the SSRS reports from 2008 R2 to SSRS 2012 SP2 version. We had a strange issues after migration.

The report which is having images is not working and it just hangs.

The reports which doesn't have any images are working fine.

On top of it some times we are getting the following error message.

Error message : The request failed with HTTP status 503: Server Error.

View 4 Replies View Related

Reporting Services :: SSRS Reports Not Running Through Sharepoint

Sep 29, 2015

We couldn't get the report through SSRS deployed URL.  We found dead locks in SQL DB end.how to proceed further issue resolution.

View 5 Replies View Related

Reporting Services :: Access SSRS Reports In Java

Nov 18, 2015

I have developed  SSRS reports and deployed to the SSRS Reporting server. Everything works fine. 

But How can i access these reports in Java application ?

View 3 Replies View Related

Reporting Services :: Migrating All Crystal Reports Over To SSRS

Oct 16, 2015

I am in the middle of migrating all Crystal Reports over to SSRS and am having some troubles converting formulas used in Crystal Reports to functional expressions in SSRS. For example: My formula for one of the crystal reports is the following. Very simple logic but how would I build it as an expression to work in my SSRS report?

IF {CUST_ORDER_LINE.ORDER_QTY}-{CUST_ORDER_LINE.TOTAL_SHIPPED_QTY} < 0 THEN 0 ELSE {CUST_ORDER_LINE.ORDER_QTY}-{CUST_ORDER_LINE.TOTAL_SHIPPED_QTY}

View 3 Replies View Related

Reporting Services :: SSRS Reports To Be Displayed In New UI Based Web Page

Aug 5, 2015

I have one requirement. We have one application in banking and they have developer that application using c# and .Net code so For Business Users--when they enter their details and when they want to check Reports--it should take to a another UI or web page where Users will see all the reports--- and clicking the report he/she should be get able to export it into different formats..

i know that we can give report manager URL--but due to various issues-- we have choosen to built a web[age where they can see the reports work-flow:

so--user opens bank site--enters his details-goes into reports--it should open new webpage or UI, he should see all reports--he should export these reports..

After that based upon security levels each user can see their individual reports.

View 2 Replies View Related

Reporting Services :: SSRS Subscriptions Resend Reports For Each Subscription?

Sep 1, 2015

I have a Daily Invoice Report that has subscriptions for all customers and is run every night.  The report has parameters of @date & @Customer.  We had issues with invoices not being sent due to the Owner on the reports was disabled in Active Directory.  We do not know how many reports did not get sent out so I am tasked with creating a script to rerun the reports for each day in August.  I have queried the subscriptions, but need to figure out how to rerun the reports using the existing parameters set in the subscription, increment the report parameter date, and execute the emailing of the report.

Here is my query that gives me all the subscription information, but how do I rerun the job for all subscriptions for each date in August?

SELECT USR.UserName AS SubscriptionOwner
      ,SUB.ModifiedDate
      ,SUB.[Description]
      ,SUB.EventType
      ,SUB.DeliveryExtension

[Code] ....

View 2 Replies View Related

Reporting Services :: SSRS 2014 Reports Don't Display Correctly In IE11

Jul 15, 2015

In SSRS 2014 std (on a win 2012 server) the report controls display incorrectly in IE11. The save and several other features display on multiple lines instead of one line unless you are in capability mode.Also works fine on SSRS 2014 entr  on win 2012 server.

View 7 Replies View Related

Reporting Services :: Window To Choose One Report From Bunch Of SSRS Reports

May 28, 2015

I have 6 SSRS reports for account receivable module. All of these 6 reports are for one specific business requirement. The difference between these reports are layout, number of columns and styles. I want user to choose one from these 6 reports based on their requirement.

When user clicks the menu in their application to initiate the report, Is there any way that the SSRS show list of these reports in a window so that user can choose one of them?

As I am working on a 3rd party ERP application, I cannot provide a form or window in that ERP to choose one report out of these 6 reports. I believe that there is a way to do this in Crystal report, but do not know how to do this in SSRS.

View 3 Replies View Related

Reporting Services :: SSRS 2008 R2 BIS Deploy Does Not Always Clear Cached Reports

Jul 19, 2011

Is there a known problem with BIS Deploy not clearing cache.  I repeatly (but not always) have an issue where I will do a BIS Deploy of an RDL but when I run it, the old report runs.  I can't clear this out until I explicitly log into the Report Manager and explicitly delete the RDL and re-deploy from the BIS.

Is there a workaround, fix, process change, configuration change I can do to keep this from happening?

View 7 Replies View Related

Reporting Services :: Page Break After Charts And Tables In SSRS Reports

Aug 2, 2015

In SSRS reports i have multiple charts and tables. per page i have to display one chart and one table. How to put page break after the chart and table. I have not used rectangle. I created all the charts and tables in the body area.

View 5 Replies View Related

Reporting Services :: SSRS - SharePoint Integrated Mode - Reports Are Not Functioning

Jul 8, 2015

We have a Report Server integrated with SharePoint. A month ago we deployed a report (rdl file) in SharePoint, but the person who deployed it was no longer connected with us. So we decided to deactivate it in our Active Directory. Yesterday, our users returned issues regarding they are unable to access their report. I believe the issue was "object reference not set to an instance of an object".

So I tried to download the rdl file and redeployed it but i am getting error upon deploying to SharePoint. My workaround is to delete the rdl file in SharePoint, redeploy the shared datasource and shared datasets and the rdl file. It went and was now able to run the report in SharePoint.

Is there something relation/happened when deactivating the account in AD that users unable to access the report in SharePoint?

View 2 Replies View Related

Reporting Services :: Sharepoint Dropping Link To Data Source For SSRS Reports

Oct 9, 2008

I have published SSRS reports to sharepoint and used the Reporting Services Report viewer to present the reports on a Page.  Everything works fine for the day, however in the morning, when I go to view the page, I get an error message 

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

View 9 Replies View Related

Reporting Services :: Could Not Load File Or Assembly Error On Adding Custom Libraries In SSRS Reports

Sep 21, 2015

I have created a custom library(CodeLibrary) which internally references the dlls Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client.

I added this custom Dll codelibrary.dll to my SSRS report. and the expression of one of the field as 

=codelibrary.codefunction.GetValue(1000)  
codefunction is the class and GetValue is the method.

When I preview the report, I get the error "Error while loading code module:

'CodeLibrary,Version=1.0.0.0,Culture=neutral,PublicKeyToken=null'. Could not load file or assembly 'CodeLibrary,Version1.0.0.0, Culture=neutral,PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."

I am using VS2013, I have placed the custom library DLL in the path

C:Program FilesMicrosoft Visual Studio 12.0Common7IDEPrivateAssemblies

I have tested the custom library with a WPF application and it works fine.

I am not able to figure out what is causing this error.

View 4 Replies View Related

Reporting Services :: Exporting SSRS Reports To PDF With Background Pattern - Pattern Not Visible?

May 8, 2015

I tried creating one simple bar chart report in SSRS, with background fill with pattern "UpwardDiagonal", the stripes on the column when viewed insider report viewer control is quite prominently visible, whereas when exporting the same report to PDF the lines are very thin and dense and hence makes it very difficult to differentiate between one column with pattern inside and one without. I have even tried various other pattern like "LightUpwardDiagonal" and "WideUpwardDiagonal" but all have same result when exported to PDF.why?

View 2 Replies View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options

Nov 5, 2007

Hello SQL Server Experts, Data Analysts, and Report Writers et al:

re: Reporting Options with SQL Server

I wanted to propose an offshoot to the pryor thread:

Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?

I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?

Thank you to all, and I hope this is a beneficial discussion to others.

Hal1490



Hal9000

View 4 Replies View Related

Reporting Services :: Interface Code Compatibility Between Custom Delivery Extension Of SSRS 2008R2 And SSRS 2012?

Sep 3, 2015

Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012

My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?

if not what code changes we should do?

View 3 Replies View Related

Reporting Services :: Error When View Reports Or Manually Processing TFS Data Warehouse And Analysis Services Cube

Apr 24, 2015

I am trying to configure the reporting for TFS using SQL Server. But I get following error when viewing any report:

So I try to manually process the cube to check if it works. I am following this article: [URL] ....

When I click on GetProcessingStatus and invoke it (with last field set as TRUE) I get following error:

How to resolve this issue and be able to see the reports.

View 5 Replies View Related

SQL Server 2008 :: Reporting Services Migration - Subscription Jobs Did Not Get Created

Apr 23, 2013

We are moving to a new data center. We have RS install on appweb server that points to different sql server for Reportserver and Reportservertempdb. So, We created a new virtual appweb server and new physical database sql server 2008 r2 at new DC. I did a fresh install of new reporting services 2008 r2 on appweb server. I backed up and restored Reportserver and reportservertempdb dbs from old 2005 sql server to new 2008 r2 database server.

During new RS configuration, I pointed databases to the new restored databases and restored encryption keys. When launched reporting services URL, it works fine.

I stopped and restarted reporting services after configuration.

However, I am not seeing any single job created on new database server. Old server had 20 jobs.

How do I get these subscriptions back to the new install? I thought this should be created with migration and I do not have to do anything.

One odd thing I had to do during config was that:

In scale-out deployment tab in RS configuration, it was showing both the new and old appweb server name as status joined. I was unable to remove the old server name by clicking 'remove server' there. So, I deleted old server name from keys table in Reportsserver as suggested by some forums to have a clean installation. Does it have anything to do with jobs not created?

What do I need to do now to get subscripts jobs created. Ther eare only 20 jobs here but another RS server has over 800 subscriptions that I can not mess up. So, need to find the issue and correct it before I can move on to the another RS instance.

View 3 Replies View Related

Reporting Services Migration - Create Grant Rights Script: Failed

Dec 14, 2007

Hi,

We moved a development reporting services database to a new server last night and followed the MS 'Moving a Report Server Database to another computer' directions. We used the Reporting Services Config tool to make the changes, remoted into the 2003 windows server - which is running sql Enterprise reporting and connecting to a 2005 Enterprise cluster.

We had two small problems - although everything seems to be working fine. The First try seemed to be unsuccessful because we did have the service started after applying the database connection changes. The directions don't mention starting the service before you hit apply. The second time we got an error that said "Create Grant Rights Script - The Task Failed". We entered a sql login that was a sysAdmin during the setup.

The exception details started off with:
System.UnauthorizedAccessException: Access is denied

If the rest of this error is needed I can type it out...I was sent a screen shot of it!
Thanks for any help - we are moving production soon and I'd like to understand what went wrong.
Thanks
Sam

View 3 Replies View Related

Reporting Services :: Get Report Toolbar Using SOAP API In SSRS Reporting?

Nov 3, 2015

Is there any way to get the report toolbar using SOAP Api  in SSRS reporting.

View 6 Replies View Related

Reporting Services :: Real Time Reporting In SSRS?

Jun 19, 2015

We've got a requirement to build the real time report. user can browse report at any point of time and need to see the latest data(stock market) in the report.

I've few options down...

1. Directly point to OLTP database as source and write stored procedure to show result set.

2. Replicate the database and write the SP's to reports. To avoid pointing directly to OLTP db.

3. To build the datawarehouse with dim & facts to show it in reports. I prefer this as a standard method, but this would have some latency depending on trasaction load which will differ from the requirement.

View 3 Replies View Related

Reporting Services :: SSRS 2008 R2 - HTTP Error 503 - The Services Is Unavailable

Jul 23, 2010

We built our prod server [vm] with SQL Server 2008 R2 on Server 2008 R2.  It works nicely.  Then we made a copy of the VM and renamed it (so our test environment would be IDENTICAL to production).  After that, SSRS was broken: I get "HTTP Error 503. The service is unavailable."  I can't connect via http, or SSMS.

We have tried:

* Running SSRS config tool (several times)

* Running with/without the IIS Server Role

* Dropping & recreating the SSRS keys

* Recreating the ReportServer database, etc

* Checking all of the accounts, permissions, etc

* Running SQL Repair

* Going through the registry to fix any references to the machine's old name

* Uninstalling, reinstalling SSRS

* Completely uninstalling ALL of the parts of SQL Server 2008 R2, deleting all directories, removing references to SQL Server from the registry, rebooting, reinstalling everything.

None of this has worked.  SSRS [R2] is still 503 on our test box.

the SSRS [NT] service seems to run, without error.  The Event Viewer doesn't seem to be recording any errors.  The SSRS logs say that the default URL is wrong, but we get the same error in Prod, and Prod works fine.  The other SQL Logs say something about not being able to contact the service.  However, as I said, the [NT] service seems to be working fine.

View 4 Replies View Related

Integration Services :: Send 4 SSRS Reports In Text Format To Ftp Server

Jul 11, 2015

 i have 4 SSRS reports. each report must be scheduled to run at different time and then send the send the reports in txt format (tab delimited) to a ftp server .I am new to SSIS and SSRS.

View 3 Replies View Related

SSRS Printing Gives Different Page Output In Visual Studio And Deployed Environments.

May 6, 2008



Hi,

I'm having a struggle with the printing of landscape reports in SSRS.

The reports appear fine when printed from the Visual Studio environment, but when I deploy to a web environment I get 1 or 2 blank pages before reporting continues (i'm using the SSRS printer icon, not the browser printer icon).

I've spent ages looking at margin and printer settings and can't find anything wrong - especially as it works under Visual Studio.

Has anyone experienced problems of this nature and how did you resolve them?

Cheers.
Elracorey

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved