How To Make All Reports On SSRS Location Specifically
Mar 6, 2014
I am trying to make all reports on SSRS location specific. e.g I only people who work in certain locations will be able to view certain parameters.
I figured that I can do this using User!User.ID and an access control list. I have tested this by manually creating a sample ACL but I want to be able to automatically populate the list with data from AD.
I can find lots of stuff online that allowed me to extract information from AD but I cannot see a way of creating a full list which includes memberships.
e.g:-
USERNAME MEMBER OF
User1 location1
User1 location2
User1 location3
User2 location1
User2 location4
I am able to get users by specifying a group and getting memberships by specifying a user but I am not able to get a full list.
I am using the "XML Source Adapter" in an SSIS package. I notice that although you can specify the XML filename as an expression, the XSD appears to have to be a fixed file path. This is a problem for me since the path for the XSD is different in my development than it will be in production (in production it's on drive E:, which I don't have).
I'd like to have the file location specified in the config file, but since I can't make it an expression how can I do that?
Also, since they don't have Connection Managers I can't switch DelayValidation on.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID. I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data: 1 - 50 60 - 80 150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?
If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?
I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.
The developer PC is Windows Vista Business.
Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?
Any ideas how to make reports faster when returning lots fo rows? I know you would need to work on your sql query etc.. Or maybe cache it. But i'm thinking of having a kind of middle tier thing that sits between your sql database and the reports itself. Any ideas would be appreciated
In short, we have started deploying Office 2007 to our users and Excel is currently the only client we use to interact with our AS2005 cubes.
A few users have reported issues (which I've verified), but the explanation in the KB article doesn't make any sense to me. These reports were originally developed in Excel 2003 and when opening them up in Excel 2007, we'll see a message saying that Excel found unreadable content in the .xls file and after clicking 'Yes' to recover contents of the workbook, we then receive a message that a PivotTable report was discarded due to integrity problems. If I opened up this report in Excel 2003, I don't receive these errors or messages.
Per the KB's explanation (http://support.microsoft.com/default.aspx/kb/929766):
This issue occurs if the following conditions are true: €¢The workbook contains a PivotTable that uses key performance indicators (KPIs).€¢The KPIs are created in the Analysis Services Business Intelligence Development Studio.€¢One or more of the KPIs have an expression in the Current Time Member property. Now, we are running 2005 Standard Edition with no SP, but will be deploying SP2 in a few days. Our cubes do not have any KPIs defined. Can I even define KPIs if we are only running Standard Edition?
Apress pro t-sql 2005. so far it seems pretty good in clearing up a lot of things Ive been doing but wasnt really sure I understood the same way I understand for example, C#. It was the little things about the language that Ive never been realy clear on such as basic control flow statements. Anyone else read this book yet ?
As the page only has 21cm and the report grows horizontally, I need to repeat the WHOLE report with all of its sections after every 4 customers. So if I have 5 customers, there would be three pages(let's say every subreport takes 1 page) for the first four customers, and then another three pages(with every section once again) just for one customer.
Is it possible? It doesn't seem somehing out of the ordinary, but I can't figure how to make it work. Everytime there is more than 4 customers, the report breaks its layout trying to accommodate the records in a new table below the tables of each subreport.
The expected result would be to bring all of exceeding data to new pages.
I want to know which would be the best for reporting in either of the above two. I am working on with SSRS but don't have any idea about crystal reports. So you all please suggest the best one would be for me espcially for web based reporting.
Hi Guys, I am creating SSRS report using Oracle DB. When i run this query in TOAD, it's giving output but when i run this in SSRS to create new dataset then it is giving me ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle).
This is the query iam running.
SELECT ts.transaction_status_desc, COUNT (ut.transaction_id) AS transcount FROM dsc_transaction_status_vl ts, dsc_user_transaction ut, billing_markets bm, retail_location rl, cash_register cr WHERE ts.transaction_status = ut.transaction_status AND ut.cr_number = cr.cr_number AND cr.rl_number = rl.rl_number AND ut.RL_NUMBER = rl.RL_NUMBER AND rl.bm_code = bm.bm_code AND (ut.creation_date BETWEEN tartDate AND :EndDate) AND bm.bm_name IN (CASE (:Market) WHEN 'OKC' THEN ('OKLAHOMA CITY' || 'TULSA') WHEN 'NFL' THEN ( 'DAYTONA'|| 'JACKSONVILL' || 'MELBOURNE'|| 'NORTH FLORIDA'|| 'ORLANDO' || 'WEST FLORIDA' ) WHEN 'LA' THEN ('PAC Los Angeles') WHEN 'CAR' THEN ('Carolinas') END )
I am passing 3 parameters: StartDate, EndDate and Market. we have 3 markets and each market includes some cities. Cities are in BM_NAME column. My Question is that 1) How to pass parameters for Oracle using SSRS 2) How to resolve this error: ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle) 3)How can i write Stored Procedure for this query & How to execute SP in SSRS.
Hi All, I have a project that is already in MS Access that has many reports and I must develop the same project in .NET with SSRS for the reports. By seeing the same scenario in these forums I imported by right clicking on the project name, all the reports from Access have been imported.. My question is, that will the imported reports from MS ACCESS will be the same as that of the reports we will generate in SSRS? and can I use them as final reports. And call these reports in my .Net code..Is there any article regarding this please provide so that I can read and learn how to use that.. And for each .rdl files the data set si coming as dataset1...can we change the dataset name?..Please repond..ASAP.
I have a linked server setup in dev environment which is pointing to ORACLE server of a third-party. I m on  sql server 2008 r2 and  using BIDS 2008 for building an SSIS package which would pull data from oracle and do a look up in SQL server table to get a final  extract. Now the query which pulls data from a single table from linked server is like the one below
select * from [oracle linked server ]..dbo.tablename a left join  mySQLSERVERtable b on a.id=b.idÂ
Note:I can execute this query on SSMS as  the linked server is setup -[oracle linked server ] and I have sql  oledb connection manager for dev environment already configured in my ssis package .
My questions are do I need to create a SSIS CONNECTION manager specifically for linked server in my ssis package ?
Are there any best practices which we follow when using linked servers in this context ? I am thinking will the join suffer performance issue and what kind of exceptions I need to write when the linked server connection is broken.
I am not able to access registery key in report when report is deployed on reporting server. But when that report (.rdl) is opened in a Business Intelligence project it is able to access registry key. So, my question is what need to be done to get value of registery key in reports deployed on reporting server.
I have SSRS and Asp.net2.0. i have been asked to create the dashboard reports for our organization. please give me some tips, how to develop the dashboard reports using this technology?
Is there anyother resources avilable to develop this dashboard reports? thanks in advance..
We have 7 SSRS reports subscription which execute every night at various time intervals.
Some times, due to database unavailability subscriptions can not access the source database, so these subscriptions continuously try to connect the database. (Even after setting connection time out.)
When the database is up again, all these subscriptions create bottleneck for the database and the whole system crashes.
So we want to stop subscriptions after some time interval (lets say 2 hours after it starts),
After that time interval what ever may be the status of the subscription (processing, done or fail) it should stop.
Please let me know the solution, Thanks in advance.
I have created some reports in BIDS and saved them to a folder in my m/c (without deploying them) . i want to deploy that to the report server through C# code.
i can deploy that onto any Report Server. For that I will have to change the datasource connection string.
Is there a way to achieve this. Please let me know if it is there.
I came across a website that claimed "There are approximately 116 functions in Crystal Reports that do not have a direct equivalent in VB.NET or Reporting Services (SSRS)." Does anyone know what these functions are?
I need to move few folders from our DEV SSRS 2005 environment to another server. Folders will be moved to new parent folders. Is there any tool that I can use fot this purpose? I used RSScripter from SQLdbatips.com. Although the tool works great but it can't script multiple folder reports. I have to script one by one and it is a big problem.
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?
In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report
i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.
i'm a new developer and working with ssrs , any one can provide me by the steps of Reports Deployment and ssrs installation . i'm using sql server 2005 with asp.net ,vb.net ....
In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to be directed to report B. Can you show me guidance on where to start please?
