Report Job Duplication
HI
I have created a job to run a reporting services job which then named it in the job scheduler 354EEF12-404F-46BD-B54F-708B5027837F. I then renamed the job to Rpt ETL log.
However it I was surpised to see two emails come with reference to this report. It seems to have created another one with the long job names.
Is there any way to stop this as I would really like to name to schduled rpt jobs without it duplicating.
Many Thanks
Robert
View Complete Forum Thread with Replies
Related Forum Messages:
Duplication
How can I achieve the following... I have a Membership No. field which comes from a bookings table, so multiple membership no. do exist. What I want to achieve is a list of membership No.s with no duplication. Sorry to be so dumb, but we all have to start somewhere.
View Replies !
Duplication Error
i have taple translatio witch have theses coloumn ID,TypeID,Status,ComID,RecordID,Translator in this table we assign a certain company with a certain typeID to a certain translator . so next time when the translator log he goes to the company that he assigned to it when he log to the company page, there is another company page n arabic that is transalted by the translators , in the arabic page there is a button when you can send this company to transaltion. but a duplicate have been happen made because user send the same documnet to the translation table so many time so translator transalte the same company profile more than one time witch is not good. we handle the duplicate of the send to translation button put still there is duplicate record in the database witch is more taht 3000 record how ican to remove thsi record from the DB without make ant other erroe
View Replies !
Prevent Duplication On UPDATE
Hello I noticed a spelling mistake in the data in a column of several tables, I used the following syntax to alter the spelling: UPDATE [dbo].[Prod_Cat] SET [ProdName]=N'merseyside' WHERE ProdName = 'mmserseyside' The above code correctly updated the spelling error, but it also inserted a new row with the corrected data. So I found myself with two Identical rows containing the corrected information. I had to manually delete the extra row. Because if I had put in a DELETE statement, I would have then lost both rows. What do I need to do to prevent this happening next time. As I find that I need to update the names of some products, but I don't want to duplicate them. Thanks Lynn
View Replies !
Track Duplication Of Records
Hello, I have a table which consists of 27,000 of records. Among these records, there is one record which is a duplication of another record. Is there any way to track this record from the same table by the SQL statement ? I have been advised to use the following statement but it does not help: Select count(*) As Duplicate, columnname from tablename group by columnname Scrolling 27,000 lines of records with bare eyes is very painful. Any help is appreciated. Cheers
View Replies !
Duplication In The Primary Key Column
Hi I have a set of excel files that i need to export to sql2005 using ssis. Now the issue is that i have no idea about he data ie it may have duplication in the primary key column. If i export it as it is to sql server, it will cause me problems. Is there any way i can filter out the rows which have duplication in the primary key column? Umer
View Replies !
De-Duplication Performance Issue
Hi All, Scenario: De-duplication logic should pick one record from source and check with all the destination records and insert if not duplicate. Else raise error. There are average 8 to 10 lookup check for each logic path. Key fields used for de-duplication check are FirstName, LastName, DOB, Gender, SSN. Issues: · Since picking row by row and processing the performance is constrained. · Since 8-10 comparison is done using lookup performance downstream. (Lookup is used without caching, if cashing is used the package is failing after sometimes as if memory is failing. Can we handle this memory problem?) Please give some suggestion to improve the performance. Current performance is around 2500 records per hour, but there are 8 lac records in total to process. I am looking for guidance on this issue. If someone can guide me on how to do it better it would help me a lot. Thanks, S Suresh
View Replies !
How To Avoid PrimaryKey Duplication?
Hi, I having a problem with my query... I want to copy data from 4 different database to 1 database... but if the destination database have already the same Primary Key the copying stops/terminated and not copying others that is not yet in the destination... I don't have knowledge in T-SQL like IF...ELSE my database is SQL Server 2000 but i'm using SQL 2005 Express Management for the query... What i'm doing is like this: Use osa (Destination Database) Go DELETE FROM tblFaculty (*I'll delete first the datas to avoid duplication) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM cislucena.dbo.tMasFaculty) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM amapn.dbo.tMasFaculty) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM abe.dbo.tMasFaculty) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM aclc.dbo.tMasFaculty) My problem is if the facultyID (PrimaryKey) which i'm copying is already on the destination which is osa, the copying stops/terminated regardless whether there is more to copy. On the 4 source database, there might data that other database also has. That's why the copying is terminated. All i want to do is to check first each FacultyID if it is already on the destination before copying it to avoid error or duplication of Primary Key so it won't terminate the copying. How is this possible sir? Anyone care to help? Thanks in advance! More Power! Best Regards
View Replies !
Single Field Duplication Problem
I have a table with many fields but there is a single field that I do not want duplicates. If I index this specific field preventing duplicates, the entire record does not append. (The field in question is not keyed). Thanks Bill Howard
View Replies !
Error Catching On Data Duplication In A Sql2005 Db
Hello, everyone. I am having problems catching a data duplication issue. I hope I can get an answer in this forum. If not, I would appreciate it if someone can direct me to the right forum. I am working on a vs2005 app which is connected to a sql2005 db. Precisely, I am working on a registration form. Users go to the registration page, enter the data, ie. name, address, email, etc. and submit to register to the site. The INSERT query works like a charm. The only problem is that I am trying to reject registrations for which an email address was used. I put a constraint on the email field in the table and now if I try to register using an e-mail address that already exists in the database I get a violation error (only visible on the local machine) on the sql's email field, which is expected. How can I catch that there is already an email address in the database and stop the execution of the code and possibly show a message to the user to use a different address? Thank you for all your help. Antonio
View Replies !
Insert Statement Results In Data Duplication Using MDAC 2.8
I am using Remote Data service to Query an Sql Server Database using MDAC. The Os in which server is loaded in Window 2003 and the MDAC 2.8 version is installed. Now I create a table X with identity column. Then when I try to insert records in that table using Insert into X select * from Y statement. The statement gets executed by when i check the X table I find that the duplicate records are present with different identity no's. Even when i truncate and retry the same thing occurs. What could be the reason for the same?? Regards Pranali.cons
View Replies !
Fix Legacy Data - Missing Primary Key + Duplication Record + Large Table
We have a large table which is very old and not much ppl take care about, recently there is a performance problem from the report need to query to this table. Eventally we find that this table have primary key missing and there is duplicate data which make "alter table add primary key" don't work Besides the data size of this table require unacceptable time to execute something like "insert into new_table_with_pk from select distinct * from old table" Do you have any recommendation of fixing this? As the application run on oracle , sybase and sql server, is that cross database approace will work?
View Replies !
The Definition Of The Report 'Main Report' Is Invalid. The Table 'table1' Is In The Report Body But The Report Has No Data Set.
keep getting error :- a.. An error occurred during local report processing. a.. The definition of the report 'Main Report' is invalid. a.. The table 'table1' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets. I can't get my ReportViewer to see my DataSet. Is it possible without having an xsd file??? aspx page below: <div> <aspropDownList ID="DropDownList1" runat="server" AutoPostBack="true" DataSourceID="SqlDataSource1" DataTextField="Name" DataValueField="ProductCategoryID" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"> </aspropDownList> </div> <div> <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="400px" Width="400px"> <LocalReport ReportPath="c:inetpubwwwrootSubReportsDemoMainReport.rdl"> </LocalReport> </rsweb:ReportViewer> </div> Codebehind -------------------- protected void Page_Load(object sender, EventArgs e) { //if (!IsPostBack) //{ //DropDownList1.Items.Add(new ListItem("<Choose City>", "")); //int catid = Convert.ToInt32(DropDownList1.SelectedValue); DataSet dataSet = new DataSet(); getProductSubCat prodSubCat = new getProductSubCat(); //added the catid to 1 for testing dataSet = prodSubCat.getProductSubCatByCatid(1); //ReportViewer1.LocalReport.ReportEmbeddedResource = "reportViewer.MainReport.rdl"; ReportDataSource dataSource = new ReportDataSource("dsProdSubCat", dataSet.Tables); ReportViewer1.LocalReport.DataSources.Add(dataSource); this.ReportViewer1.ShowReportBody = false; //foreach (DataTable table in dataSet.Tables) //{ // foreach (DataRow row in table.Rows) // { // foreach (DataColumn col in table.Columns) // { // Response.Write(row[col].ToString()); // } // } //} } private void SetReportParameters() { ReportParameter catidParameter = new ReportParameter("catid", DropDownList1.SelectedValue); this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { catidParameter }); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedValue == "") { // User didn't select a valid parameter value. this.ReportViewer1.ShowReportBody = false; } else { this.ReportViewer1.ShowReportBody = true; SetReportParameters(); } }
View Replies !
Hi Im Finding Paging From One Report To Other Report(drillthrough Report)..plz.. Reply
Hi i am using whatever they explained in this websites http://www.codeproject.com/KB/aspnet/DrillThroughReport.aspx http://geekswithblogs.net/robz/archive/2007/11/21/Reporting-Services-2005-BUG-Report-Linking-and-Paging---ASP.NET.aspx but i am getting these errors Error 1 The type or namespace name 'ApplicationBlocks' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) C:InetpubwwwrootWebSite4Default.aspx.cs 12 17 C:...WebSite4 Error 1 The name 'SqlHelper' does not exist in the current context C:InetpubwwwrootWebSite4Default.aspx.cs 55 23 C:...WebSite4 plz...explain it properly. Thanks, suma,
View Replies !
Modifying A Report Created In Report Builder In The Report Designer.
After I use the report builder to create a generic report, how do I actually get that report into the report designer so that I can modify it more effectivly? The issue that I have now is that the file on the report server is not a .rdl file and if I simply save it as one and then bring it into VS to modify it the code file is a html structure rater than a XML file type. Any suggestions would be appreciated. Thanks
View Replies !
Report Builder: How To Provide Parameter In The Report Generated Report Builder
Hi All, I have used Report Builder in one of the project for client. Is it possible to provide parameter in the report that is generated by Report Builder? It's quite the same with the parameter in usual Report/RDL (by Visual Studio). And is it possible to pass the UserID that is running the report to the Data Source View or directly to the query? Currently, I need to get the UserID of the user that runs the report to do some filtering of the data (in SQL Query). I can do this easily in the RDL file developed by Visual Studio, which I can use global parameter User!UserID and pass to query. I find difficulty to use SQL Execution Context (select USER_NAME(),SUSER_NAME()), because report needs to be run as certain account, so that the report can be subscribed by user (e.g. email subscription). How to pass this UserID to the query/data without end-user intervention in Report Builder? Thanks.
View Replies !
Report Builder: How Can I Append Two Table Fields To Report In Report Builder
Hi, When i select datasource in Report Builder, i am able to see all the available DataSources. Eg: I have selected one datasource from the list and which has 3 tables(table1, table2, table3) associated to that datasource. when i drag and drop table1 fields to report, i am not able to see the other 2 tables(table2 & table3) Is there any property or relationship do i need to maintain? Thanks, SR.
View Replies !
Software / Other Requirements For Executing Report Manager And Report Builder On A Client Machine
Hi, I created an adhoc model using MSSQL Server 2005 and also created a report (based on that model using the Report Builder application on my machine which has both, VS 2005 (along with .Net Framework 2.0) as well as MSSQL 2005 Reporting Services installed. However, when I try to access my localhost from somebody else's machine, I am not able to do so. The machine from where I am carrying out this activity has the following credentials: The user is not an admin user No .Net Framework installed. (Hence when I click on Report Builder it asks me to install .Net F/w 2.0) No VS2005 installed No MSSQL 2005 Reporting Services installed. So can anybody please help me with the solution for the following queries?? Do I need to log in as the admin user, if I wish to view Reports from the Report Server? Is .Net F/w required on the client machine?? Please help Thanking you in advance Kind Regards Pratik
View Replies !
How To Pass Parameters In Url For A Report Published In Reportserver (report Built On Stocked Procedure) ?
Hi, I have created a report with the report server project template. the report is created from stoked procedure having defaut input parameters. With visual studio, i publish my report on reportserver. whenever i access to my report on this url : http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project4%2fReport4&rs:Command=Render. the created report is with the default parameters. I would like to know if i can transmet parameters for the stocked procedure to build the report with the request i want. I tried to put parameter directly in the url in this way http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project4%2fReport4&rs:Command=Render&@region='toto' but without success. my error message is that one An attempt was made to set a report parameter '@region' that is not defined in this report. (rsUnknownReportParameter) My stocked procedure is : set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER procedure [dbo].[akli] @region varchar ='m' as select * from dbo.Report2 where region=@region The request used to buid the report ? DECLARE @region varchar EXECUTE dbo.akli @region What is wrong in that ? Thanks for your help. Arioule
View Replies !
Possiblity / Instructions On How To Install Report Builder Locally Without Hitting Report Server
We have a remote business client who has a proxy server setup and this translates into receiving a 407 proxy authentication blocking error when attempting to download the report builder application for deployment off the report server which is housed locally with us. The proxy server does not allow them to download application type files off another site. At the moment, they would not like to disable the proxy for these users to allow them to deploy the application on their client or add the report server as a trusted site. Is there a method by which Report Builder can be locally installed on the client pc instead of online only with it knowing the correct report server to access and then still launch correctly when the report builder button is pressed through report manager? I am not a web application guru by any means and we have tried to replicate the oneclick deployment and what occurs in the local settings/apps/2.0 subdirectories, but the application still attempts to download/install again. If we attempt to just launch the local executable on the client, report builder assumes the client pc (localhost) is the report server to access. Is there a method which will succeed?
View Replies !
SoapException While Rendering Report Through WebService - Error During Processing Of ‘ReportParameterTime’ Report Parameter
I am extracting RS reports through a WebService: report = execService.Render("EXCEL", null, out extension, out mimeType, out encoding, out warnings, out streamIds); Some works fine but some are generating the following SoapException: Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter. I set required parameters to their default values. In this specific report I have two required parameters: 1: ReportParameterTime, String 2: ReportParameter1, String I set them to their default values (ReportParameterTime to "[Czas].[Kalendarzowy].[Rok].&[2007]" - means Time Calendar Year 2007) but I am getting the exception above. I set parameters using this code: execService.SetExecutionParameters(parameterValues.ToArray(), CultureInfo.CurrentCulture.Name); Where parameterValues is a List<ReportExecution2005.ParameterValue>. When I am using Microsoft.Reporting.WinForms.ReportViewer the report is generated without any problems. I can see one parameter to choose: "Kalendarzowy" (means adj. Calendar) and can select years, the default value is "2007". What am I doing wrong and how can I fix this error ? Does anybody know ? Regards, Daniel
View Replies !
Report Builder Using Report Model Based On Linked Server (Excel) - Primary Key?
I've created a linked server with a pretty basic Excel spreadsheet, and used this command to create a linked server to it: sp_addlinkedserver ''XL_SPS_1', 'Excel', 'Microsoft.Jet.OLEDB.4.0', 'c:MyExcel.xls', null, 'Excel 8.0' I want to use this as the data from which to build a report model. As linked servers don't show up in the Data Source View wizard, I created a view in SQL Server: create view MyExcel as select * from XL_SPS_1...Sheet1$ Okay, great, now the view shows up in the DSV wizard and I can create the data source view. However, when I create a new report model based on this data source view, the Report Model Wizard tells me at "Create entities for all tables" that I've got an error when it processes dbo_MyExcel that "Table does not have a primary key." I assume this is where the identifying attributes for the entities in the report model are taken from, so I really can't go further. Does anyone have an idea as to how to add a primary key to a linked server (Excel) in SQL 2005? Can this be done? Other than importing spreadsheet data to a SQL table, how can I get around this? Thanks, --Stan
View Replies !
Help With Auto Printing A Report From A Web Application - SSRS Report Manager Print Control
Hi all, I was looking at a previous post in this forum - Help with auto printing report... I did find the code that it points to - Help with auto printing report... I did find the code that it points to - http://www.csharphelp.com/archives3/archive545.html I can get this to work fine as a console application and a Windows Service but not from a Web Application. It dies when I get to the point of actually printing it. I am thinking that this has something to do with the fact that Web applications have limited permissions. However you can print from the Reporting Services report manager page just by pressing the print button and it is a web application. I also know that it uses a print control, AKA plug-in. Do I need to write my own print control to get this to work with my web application or can I just re-use the one that is already being used by SQL Server Reporting Services Report Manger? If I was to write my own print control how would I go about it? Thanks, John
View Replies !
Passing Report Parameters To An SSRS 2005 Report Hosted In Sharepoint 2007
Here is a situation in my company: We have an Office SharePoint 2007 site, we developed a couple of web parts and added them to our site. We used SQL Server Reporting services 2005 as our reporting solution. The reports are hosted on the report center and when we need a report, we open it by sending a URL requesting the report, passing the report parameters in the URL query string. So the report is filtered based on the parameters passed from the web parts. But since best practices say that you should host reports directly under SharePoint, by configuring the reporting services to run in the SharePoint integrated mode. We followed the steps and installed SharePointRS and we finally succeeded to publish the reports to a SharePoint folder, but we had a limitation: we are unable to pass the report parameters internally to the report hosted in SharePoint. If we passed them in the query string as the report center case, SharePoint neglects them totally. So the question is: how can I pass parameters internally between a SharePoint web part and a SQL server 2005 reporting services report hosted in SharePoint?
View Replies !
Multi-value Parameter In Master Report Passing To Single Param Sub-report In A List.
Here's tricky one. I have a fairly complex report that was given to me that was hard coded for single parameters. There is a dropdown for each market (created from a query in SSRS). The users have to run for each market each week. Is there a way to use this report as a Sub-report inside a list of a master report and then use a mult-value parameter? I want this multi-value parameter to build the values for the list and then run the "sub-report" for each value. Essentially, I want to create a for each loop. Any ideas?
View Replies !
Reporting Services Report Viewer Versus Report Server Problem
Hi I have several reports that I have imported from Access into SQLReporting Services 2005. They are multi-level grouping reports and SQLServer Reporting Services generates rectangles and lists within lists tomake them work. I then go in and set the visibility conditionally on thevarious rectangles to hide them where there is no data in a group.The problem is that the reports work fine when they are on a report serverin particular all the white space for hidden rectangles etc. shrinks up andleaves no gaps.However when I import them into my Visual Studio 2005 project and changetheir extension to rdlc to make them work with the Report Viewer the whitespace for hidden controls does not shrink up and leaves up to 3cm verticalgaps between rows so the reports are unusable.The internal controls in the rectangles are quire close together and is thisanything to do with controls that overlap in the Report Viewer but not onthe Report Server?Oh Gurus, are the engines the same or does it have anything to do with theInteractive setting for example?Any help would be most gratefully appreciated !(You can always tell the pioneers because they are the ones that ride offinto the sunset with the arrows in their backs)
View Replies !
Custom Security Extension - Report Manager And Report Server On Different Machines
Hi, I'm trying to deploy Reporting Services on an Internet-facing web server using a custom security extension (forms authentication). We will be putting Report Manager on the Web Server outside of the firewall, and Report Server on another machine inside the firewall. When testing the solution in a development environment with Report Manager and Report Server on the same box, the solution works fine. When testing it using the Internet-facing environment described above, it almost works but there seems to be an issue with the authentication cookie that is generated. Here's what happens: 1. User enters credentials on UILogon.aspx and submits form. 2. In the code-behind, LogonUser() is called through a web service proxy and the authentication cookie is returned successfully. The code used here to set the cookie is the same code used in the Forms Authentication sample that ships with RS2005. 3. The user is redirected to Folder.aspx, and the request hangs for a while, and eventually kicks you back out to UILogon.aspx, as if it lost the authentication cookie. When doing a trace on the HTTP header, the cookie is still there. Is there anything special I need to do to make the Report Server "see" the cookie when I have Report Manager and Report Server on different machines? Any help would be much appreciated! Mike
View Replies !
Failing To Deploy Report With Report Manager Wizard In Visual Studio BI !
I am getting the following error when I attempt to deploy my test report. "Failed to Deploy Report, The user 'XXX/IUSR_XXX' has insufficient rights to perform this action." Has anyone gotten this error before, I have tried every permission option I could with the IUSR account by adding it to each folder etc ...and still get no resolve. Anyone have a fix for this bug ? Responses are much appreciated!!
View Replies !
Problem When Starting Report Builder With Report Path Launch Parameter
Hi, I'm having a problem with the Report Builder application; when I open Report Builder without parameters the application is working fine - I can create reports and save them in a folder I have access to on the Report Server. However, if I open Report Builder with the report path as a launch parameter to edit an existing report I run into some problems. I can still change and execute the report and save it (if I have publish-permissions to the folder/report), but if I try to use Save As to save the report somewhere else it does not work. The Save As dialog appears, but the "Look in" dropdownlist is empty, and the box below says "Loading...". If I try to press the "Folder up" button next to the dropdownlist an exception is thrown. It seems the Report Builder suddenly does not know which Report Server it is connected to.. I use e.g. https://<servername>/reportserver/reportbuilder/ReportBuilder.application?/BUs/Standard/testke as url to open Report Builder. BUs/Standard/testke is the report's path. Am I doing something wrong here? Thanks, - Kjetil
View Replies !
Accessing A Simple XML File Uploaded On Report Manager For Report Comments
Hi, I am using SQL Server Reporting Services 2005. I am trying to access a simple XML file from within my reports. The XML file will store general comments and it was uploaded to the report server via report manager. I created a XML Data Source in my report with a connection string that points directly to the XML file. Below is an example of the XML file: <Notes> <Note Type="Date Range Footer" Text="Message1" > </Note> <Note Type="Standard Footer" Text="Message2"> </Note> </Notes> Here is my XML Query: <Query> <ElementPath>Notes/Note</ElementPath> </Query> Here is my connection string: http://localhost/reportserver/Testing/Comment.xml What am I doing wrong here. I have tried several approaches. Thanks,
View Replies !
Viewing Ssrs Reports In Report Viewer Web Part(report Manager Url?)
i m using SQL Server 2005 Reporting services, sharepoint 2007, SQL Server SP2 and Sharepoint technologies ADD-IN tool. i hav configured the reporting services to sharepoint integration mode. Also i hav deployed my SSRS reports to sharepoint report library. now i want to show these reports in the report viewer and report explorer web parts. These web parts are successfully deployed. Can someone tell me what should be the report manager url and start path in the properties of these web parts?
View Replies !
Report Builder Icon Is Not Showing Up On The Report Manager Home Page
HI, there, I added a new windows user "ReportUser" which is a local user (not in administrator group). When I connect to the report manage's web page, I use reportuser to log in (when the anonymous access is disabled it will ask a log in). Report builder icon is not showing up on the report manager home page. If I log in as a user in administrator group, the reportr builder icon shows up so I can download it and build report. I have assigned reportuser "Content manager" and "repoter builder" access to the home folder. Is there anything else I have to do to make the report build icon show up on the home page? Thanks Jack
View Replies !
Installing Report Service In Window XP - Report Builder And Other Option Are Not Displaying
hi I have installed SQL Server Reporting Service on window xp. everything working fine except one thing. I have installed sql server with my a/c. my a/c have admin rights. when i giving http://dineshpatel/reports it is displaying page but Report Builder and other option are not displaying. I hope i don't have admin rights. I have checked with local administrator login also but same problem. what additional setting are require for admin rights? Dinesh Patel
View Replies !
Adding DataSet As DataSource To Report Published On Report Server From ClientSide
Hi I am Creating Click Once Windows Application with Reporting Services 2005.I have created Report and Published on Report Server.In my windows application I am successfully able to view my published report through report viewer control. Now in my application I am getting a dataset from my custom webservice. I want this dataset data to be added to my report as datasource at runtime on Client Side ,as my report is on Report Server. waiting for help!! Thanks in Advance Pankaj
View Replies !
SSRS Report Generator Hangs On Execution In BIDS And Report Manager
Hi, I'm encounter lately some weird behaviour of SSRS in BIDS as well as after deploying on Reporting Server. I'm running basic classical SQL SSRS Reports with Oracle DB connection. My reports have header and footer pagination and well defined report layer configuration. All the reports are simple based on one table and some basic parameters passed to query. In query builder from BIDS from data tab, the query is running fine without any other execution delays. Also the query is runnign fine in PL/Dev environment. When I switch in "Preview" mode the report hangs in execution and just showing "Report is being generated" without any resuts. After a while is generating an execution error (after 20 min). The behaviour is the same after deployment on Report Server . I now...here it comes...the problem is intermitent...some times the report is working...but most of the times it hangs on execution. I checked the report from top to bottom and nothing's wrong from design perspective. On other reports I don't have this problem and I don't understand where to start to investigate. Any suggestions...I'm stuck here. Thanks
View Replies !
Custom Assembly Behaves Differently In The Report Designer And Report Manager
Hello everyone, I created a custom assembly using C# to transform some binary data into text, and in this assembly I used one win32 dll developed by our customer to help me to do the tranformation. The code I used to call the win32 dll is like below: [DllImport("tdasuie.dll", EntryPoint = "AlrtLogConditionToText", ExactSpelling = false, CharSet = CharSet.Auto, SetLastError = true)] private static extern UInt32 AlrtLogConditionToText(Byte[] pbCondition, StringBuilder pszText, UInt32 dwSize); I defined a C# method to call the above win32 method and return a string. Then in the report, I called this C# method to get the correct string. In the report designer, the C# method in the custom assembly can return the correct string in the preview window. But after I deployed the report into the report server, the textbox will only display "#error" in the report manager web page. Can anybody help me on it? Thanks a lot. Danny
View Replies !
Setting The Report Dataset Parameter In Report Viewer VS2008/SSRS
1- I have a dataset with a SQL query statement that has a single parameter. 2- The dataset (and associated table adapter) are used in a local SQL Server report 3- The report is published using a web form and a Microsoft Report Viewer control 2- Somewhere in the VB code of the Report Viewer I want to set the value of the parameter based on program logic. It appears that the data set (and associated components, i.e. tableadapter) are not visible in the Report Viewer code> How does everyone set the parameters in the Where clause of their query at run time? i.e.: Me._EmployeeTableAdapter.GetData(parm_a) where parm_a is a vlaue generated inside the VB code. Except I can't make this work!
View Replies !
Table Columns Expand Horizontally When Viewing Report Through Report Server
I have an interesting problem to report that I'm hoping someone will be able to assist in solving. I have a report that contains a table inside of a list. When I view this report on my local machine via Visual Studio, everything appears normal, the columns are all the correct size. However, as soon as I publish this report to the report server and attempt to view it via Report Manager, one of the columns expands horizontally! From all of the documentation I have read, I understand that Reporting Services does not provide the ability for columns to expand horizontally, only vertically. Can anyone help explain why this is happening or a possible solution to turn this automatic expanding off? Many thanks, canuck81
View Replies !
Report Viewer Jump To Issues With Relative Intra-report URLs
Hello, Very strange phenomenon with the "Jump to report:" Hyerlink Actions when I deployed my reports to the production servers: The Actions no longer funcioned properly when attempting to go to one report to another. Sometimes, the same report would come up and sometimes a different report. It appeared that whatever mechanism Report Server uses to construct the proper URL when using "Jump to report:" is unreliable(or the URL is not being honored by the web-server). All this is happening under the Report Viewer control. I have had to do a painful fix of manually constructing the entire absolute URL and including the reportviewer control in the url. Any way to get back relative Jump to report: URL's? Thanks JS
View Replies !
Deny Builtin/administrators Full Access To Report Services Report Manager 2005
I need to prevent domain and local administrators from having full control over our report manager. (I want them to be assigned permissions just like everyone else, some reports they can see other reports they can not.) How can I accomplish this? I tried going into Report Manager -> Site Settings -> Configure Site Wide Security and re-assigning BUILTINAdministrators to the System User role instead of the System Administrator role. (A different set of report manager admins was given the system administrator role). However, it appears that members of the BUILTINAdministrators group still have full control in Report Manager. Do I also have to remove their permissions from the SQL Server? I was thinking Report Manager was basically seperate from that?
View Replies !
Administrative Rights For Local Machine To Deploy Dynamically Created Report From Web App To Report Server
The current way I have my asp.net 2.0 web app running reports is, based on an interface the user selects the criteria for a report. The .RDL file is created dynamically based on the user's selections. I then need to SOAP the dynamically created report to the report server and then the report runs fine. BUT it requires Adminstrative rights to do this. Can this be accomplished without giving the local machine admin rights. I am sorry if this question has been answered before but i have not been up here in a while.
View Replies !
'Dynamic Time(year,month,date)' Report Template (rdl) Using Report Designer VS2005
I have three types of specific reports that i have to create with the input parameters (range) either 1: By date (rdl 1) 2.By Month (rdl 2) 3.By Year (rdl 3) Is it possible ( or how do I ) to create just one report template ( one rdl) with the three sets of parameters ( hiding/invisible which ever two sets base on user selection) and the output of the report will display the desired type( either by year, month or date). I ask this because its possible to create a drill down report from year down to date etc in report designer (vs 2005). Not sure if I can create one instead of three rdls and with the 'logic' built within that template. Thanks Regards Alu
View Replies !
Deny Builtin/administrators Full Access To Report Services Report Manager 2005
I need to prevent domain and local administrators from having full control over our report manager. (I want them to be assigned permissions just like everyone else, some reports they can see other reports they can not.) How can I accomplish this? I tried going into Report Manager -> Site Settings -> Configure Site Wide Security and re-assigning BUILTINAdministrators to the System User role instead of the System Administrator role. (A different set of report manager admins was given the system administrator role). However, it appears that members of the BUILTINAdministrators group still have full control in Report Manager.
View Replies !
.net Security Assembly Returns Results Of An MDX Query To A Report Viewed In Report Manager - EnvironmentPermissions Error
Hi, I've got a Security assembly implemented in .net 2.0, which returns the results of an MDX query to a report viewed in Report Manager. This is the error: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed If I cut out the code that asserts the need for unlimited FileIOPermissions, then the error changes to: Unable to retrieve security descriptor for this frame So I can't get away with just asserting less permissions. I assume that this is something to do with using MDX in this way. Clearly the permissions on the assembly are inadequate, so I tried updating the rssrvpolicy.config file: <configuration> <mscorlib> <security> <policy> <PolicyLevel version="1"> <SecurityClasses> <SecurityClass Name="AllMembershipCondition" Description="System.Security.Policy.AllMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="AspNetHostingPermission" Description="System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="DnsPermission" Description="System.Net.DnsPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="EnvironmentPermission" Description="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="FileIOPermission" Description="System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="FirstMatchCodeGroup" Description="System.Security.Policy.FirstMatchCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="IsolatedStorageFilePermission" Description="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="NamedPermissionSet" Description="System.Security.NamedPermissionSet"/> <SecurityClass Name="PrintingPermission" Description="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> <SecurityClass Name="ReflectionPermission" Description="System.Security.Permissions.ReflectionPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="RegistryPermission" Description="System.Security.Permissions.RegistryPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="SecurityPermission" Description="System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="SocketPermission" Description="System.Net.SocketPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="StrongNameMembershipCondition" Description="System.Security.Policy.StrongNameMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="UnionCodeGroup" Description="System.Security.Policy.UnionCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="UrlMembershipCondition" Description="System.Security.Policy.UrlMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="WebPermission" Description="System.Net.WebPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <SecurityClass Name="ZoneMembershipCondition" Description="System.Security.Policy.ZoneMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> </SecurityClasses> <NamedPermissionSets> <PermissionSet class="NamedPermissionSet" version="1" Unrestricted="true" Name="FullTrust" Description="Allows full access to all resources" /> <PermissionSet class="NamedPermissionSet" version="1" Name="Nothing" Description="Denies all resources, including the right to execute" /> <PermissionSet class="NamedPermissionSet" version="1" Name="Execution"> <IPermission class="SecurityPermission" version="1" Flags="Execution" /> </PermissionSet> <PermissionSet class="DirectoryServicesPermissionSet" version="1" Name="DSPermissionSet" Description="A special permission set that grants browse access to DirectoryServices"> <IPermission class="DirectoryServicesPermission" version="1" Browse=""/> <IPermission class="SecurityPermission" version="1" Flags="Assertion, Execution"/> </PermissionSet> </NamedPermissionSets> <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Nothing"> <IMembershipCondition class="AllMembershipCondition" version="1" /> <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution" Name="Report_Expressions_Default_Permissions" Description="This code group grants default permissions for code in report expressions and Code element. "> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2" /> </CodeGroup> <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Execution" Description="This code group grants MyComputer code Execution permission. "> <IMembershipCondition class="ZoneMembershipCondition" version="1" Zone="MyComputer" /> <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Microsoft_Strong_Name" Description="This code group grants code signed with the Microsoft strong name full trust. "> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007D1FA57C4AED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE79AD9D5DCC1DD9AD236132102900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E821C0A5EFE8F1645C4C0C93C1AB99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8A12436518206DC093344D5AD293" /> </CodeGroup> <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Ecma_Strong_Name" Description="This code group grants code signed with the ECMA strong name full trust. "> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="00000000000000000400000000000000" /> </CodeGroup> <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Report_Server_Strong_Name" Description="This code group grants Report Server code full trust. "> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100272736AD6E5F9586BAC2D531EABC3ACC666C2F8EC879FA94F8F7B0327D2FF2ED523448F83C3D5C5DD2DFC7BC99C5286B2C125117BF5CBE242B9D41750732B2BDFFE649C6EFB8E5526D526FDD130095ECDB7BF210809C6CDAD8824FAA9AC0310AC3CBA2AA0523567B2DFA7FE250B30FACBD62D4EC99B94AC47C7D3B28F1F6E4C8" /> </CodeGroup> <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="$CodeGen$/*" /> </CodeGroup> <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="SharePoint_Server_Strong_Name" Description="This code group grants SharePoint Server code full trust. "> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF763763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C2401302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A0DBC596A6B2CFA1E509BE5FBD09FACF" /> </CodeGroup> <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="MyCompany.MIS.Security" Description="A special code group for my custom assembly."> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001003F099786BD0BDCD36FF941A6EC9E6612103F15D0D34DF124FF4792C237EF88E88C23C3BAD09A57FAD1C3364003C4C27E7EFA206520286982563134566247AFCFFFDCA1B91B9AA0EBAEA81F20A3BB6769037D882DFB38F9D7FFE2F19B8975C18CED382BC2BB911C7D4B8484B39EE3AC651530A1DDD21DCE50A24EEED613CF8DBA" Name="MyCompany.MIS.Security" AssemblyVersion="3.0.0.4"/> </CodeGroup> </CodeGroup> </PolicyLevel> </policy> </security> </mscorlib> </configuration> I've added 'Full Trust' to my specific assembly. The new clause there was generated using caspol.exe so I think it should be correct. However, this made no difference at all to the error! However, if I upgrade Report_Expressions_Default_Permissions (see above) to Full Trust, the problem is 'solved'. Unfortunately giving Full Trust to any and all Report Expressions is not an option. Can anyone help? Dr. Bunsen
View Replies !
|
TRACKER
