How to create a report with two data sources and join the data between them

Hi All, I want to define a report with two data sources one is a Hyperion OLAP source and the other is a SQL Server database. I want the data from the Hyperion source to pull the corresponding detailed data from the SQL Server database. Is this possible I can link two data sources and define one report with data from Hyperion and SQL Server in one report. Thanks Karen

Hyperlink to child report is LOCALHOST when exported to Excel

We have a report that has a link to a child report for each row. We used the "Go to report" for the field's Action. Everything works fine through the browser. However, when we export this to Excel, the links turn into http://localhost.. which does not work for the user. How can we fix this? Thanks, Bernado

SSRS function to return number and not sign

Is there a function in SSRS 2008 that will return just the number part (including decimal values) of a data item and not the negative sign but still work when the input value is a positive value?

SharePoint Reports Not Viewable

Hello: At a client of ours that uses SQL 2005, we created reports and placed these reports into their SharePoint site. So, when they click on the tab labeled "Reports", they see our reports. Yesterday, their SSL certificate expired. Now, when they click on any of the reports in the tab, they get a screen with an error message displayed that says "An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode." If our IT department installs a new SSL certificate and if we afterw

access to reporting services

Hi, Please can someone advise how i can give a normal domain user access to reporting services (sql 2005), he needs to be able to have full access to view, test and change report settings, he is not a domain admin or anything. He needs to access via sql management tools. Have tried various things but cant figure it out. Thanks

SSRS not Initialized and not sure why

we have been rebuilding a server and having problems; says it's running but not initialized and I do not see a db version with 'C 5.0.8' or whatever. Any ideas or how to's would be appreciated. -- Regards, Pat

Remove/hide Navigation-Search menu

Is there any way to remove or hide the links (Home/My Subscriptions/Help/Search) in the upper left corner of all pages? Pete

SSRS 2005 SP3 and Windows Server 2008 R2

Hi, is there anything I should be aware of to install Reporting Service 2005 on Windows Server 2008 R2? Thanks in advance for any feedback Adrian -- Adrian Miller

Unauthorized (401) response when using ReportServer web Service

I'm attempting to programatically Add Roles Assignments for Reporting Services 2008 instances on a Windows Server 2008 machine but constantly get 'HTTP status 401: Unauthorized'. The identical code works on Server 2003 or Windows XP with Reporting Services 2008. This only happens with the initial process, no many how many times its run, the same exception. Closing down the application then rerunning all is fine. Versions I'm using: Windows Server 2008 32 bit, SP2 , Build 6002. SQL Server 2008 w Reporting Services, ver 2007.0100.1600.022 Here is the Reporting Services log afte

Incomplete RecordSet rendered in report

When I use the query builder to view a select query I get the expected number of rows returned. When I view this in report mode only records with the first instance of a certain field are rendered. ie: select * from foo order by Field2 Returns all records in the Query Builder Returns only the first instance of each field2 in the report I added the sort so I could compare the results. Original query has no sort. Shouldn't the query results and the report results be identical? Using Report Builder 2 against ODBC database. (also get the same behavior in VS2005 BI) I hope thi

Analysis services connection using Excel

Server- remote win2k3 server running sql2k8 in workgroup setup - no AD. Client - Xp prof connect to server via vpn and rdp I am trying to connect to sql database from Excel , data , from other sources, from analysis services using windows authentication and I am getting an error " Errors in OLD DB provider. Could not connect to the redirector. Ensure that the SQL browser services is running on the 'dbservername' server. Can you pls update on what needs to be corrected to remotely connect to analysis services via vpn from client and also make a odbc connection remotely usin

Displaying text into Sql reports

I would like to know what I can use in sql server report 2008 to display several sentences or paragraphs prior to where I have a table generated. Each table in each report will display the data. To display the paragraph(s) and/or sentence(s) before the table containing data what toolbox item would I use? Should I use a matrix, rectangle, textbox, and or another table?

BIDS not saving credentials

I have a shared data source for my solution. I enter the credentials and select "save password" and all is well while I'm working on a report. But as soon as I reboot my PC, the next time I come into BIDS and try to work on my report it fails because the credentials are not saved. I enter them and all is well, and we start the viscous circle all over again. The error I receive prior to entering my credentials is this: An error occurred during local report processing. An error has occurred during report processing. Cannot create a connection to data source 'MyDataSource'. Yo

Graph Series Tooltip Does Not Show when Zoom Engaged in IE 8

I have the tooltip property of a graph series set to display some text. Everything looks great until I zoom to greater than 100%; at that point, no tooltip. I have a similar tooltip on a textbox that works fine when I zoom. Also, when in Visual Studio 2008, the tooltip works fine with the zoom engaged. Any ideas? Thanks, Bink'

SS2000 Report too slowly

Hi all, where can I investigate for a performance problem in one report in SQL Server 2000 got by an asp.net application? Luigi

SSRS 2008 report parameter issue

We upgraded from 2005 to 2008 version and all existing reports were migrated with no issues. Most of these reports had date parameters and they all seem to be working fine. Then we developed a new report, with two date parameter, and deployed it on the server. This new report doesn't render the date parameter on the screen. As a matter of fact, we changed the parameter type to text and still user can't see the parameter on UI. We also removed the data source entirely, and just had the parameter on the report, to see if the parameter will show up on the UI, and that yielded the sa

Force Integers on Scale Labels in the Radial Gauge

How can I force the scale labels to display as "1" ratehr than as "1.0000002" ? I wanted to try to use the Radial Gauge in 2008 Reporting Services to display elapsed time in seconds. I set the Scale Properties for the gauge to have a "Maximum" value of 300 (representing 5 minutes) and leave the "Minimum" at zero. under the "Multiply Scale Labels By" field I entered "=1/60" because I want the tick labels to appear as minutes. Problem is the labels appear carrying the decimal values. This is a fun looking gauge and I would love to learn more about how to use it, and I have h

Passing date parameters to .mdb datasource

I am trying to use SQL 2005 Business Intellegence Studio to create a report against a .mdb file using an ODBC connection. What is the syntax to pass @startdate and @enddate parameters to Access? Pete

SSRS 2005 Security Export

I have inherited a SSRS 2005 installation that has access akin to spaghetti. I would like to export the current security setup, folders, users, roles so that we can start to clean it up. Is there a built in way to do this, or has someone already created a script to do this? It would be much appreciated.

Cascading Parameters

I'm trying to set up a cascading parameter and can't seem to get it working. It's basically a State --> Cities types of relationship (in this case, it's actually "regions" or "districts" within a state, and the "counties" within that district, but same difference). I'm pulling the data from ref tables in an Oracle DB (10g) Basically, I want to choose the District with the 1st param, then have the 2nd param build its list of available values on what was chosen. I pull Districts just with a straight query on the database table - works fine. For the County parameter, I ha

How to show traffic light or status signs

Hi All I want to display traffic light kind of display for a bunch of metrics in a SSRS report. If the metric is above a certain value I want to show a green traffic light next to it, if it is close to certain value show a yellow traffic light and if it is below a certain value show a red traffic light against the metrics. Can you please kind advice how I can do it I am also checking if it is possible to show a Down arrow if the value is below a certain threshold and greater than arrow if it is above a certain value. Please kindly share ideas how I can do this in SSRS 2008 repor

how to stop subreports shifting horizontally if no data?

I'm a complete newbie here. Hope I can explain the problem clearly enough and sorry if I get some of the terminology wrong. I'm using Report Designer in SSRS 2005. I have two subreports side by side in a list area on my main report, one on the left and one on the right. If there are data in both subreports, they render exactly as I want them to. But, if the first one (on the left) has no data to display, the second one, which should appear to the right, is rendered shifted over to the left where the first one would have been if there were any data. I would prefer that a blank are

Matrix Columns

I have a report where the customer is the rows and each column is a month o total sales. it works, but I am show ALL the dates when I want to limit it to the last 12 months as of today. I am not sure how to do this. Any help is appreciated.

format in text boxes

In a sql server report service 2005 report, I need to format a few paragraphs before I displayed a chart. Thus, can you tell me is there a way to format messages in paragraphs foramt like you can in word? If this is not an option, do I need to use special carriage control and paragraph indicator characters like '\C'> Thanks!

Report Site SSL links broken

I am successfully running a reporting services site under SSL but... The links in the upper left corner of all pages (Home/My Subscriptions/Help/Search) are all still pointing to http:// not https:// Where do I fix this or even better can I remove/hide these links for the "browse" group? Pete Hay

Chart Question #2

SSRS 2008. Column Chart One bar has a value of 50. The series is grouped by activity. Budget = 25 (green part of bar) Forecast = 15 (Gold part of bar) Actual = 10 (Orange part of bar) The label puts values in the appropriate section of the bar but does not show a total for the bar. How can I show the total? Thanks in advance

Chart Question

I am doing a column chart in SSRS 2008. Is there a function or a way to mouse over the bar and see the data value of the column. I see there is a way to show the value in the bar but I want to be able to mouse over it (value appears then disappears) like in excel. Is this possible? Thanks in advance

Error during exporting a report in PDF format (SSRS 2008)

When running an SSRS report, and exporting to PDF, you receive the error: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. When checking the error log you will find: library!ReportServer_0-5!1e34!02/19/2010-14:41:21:: e ERROR: Throwi

Obtaining information of user in AD

Hi, Is it possible to extract AD information of the user running the SSRS report? Currently only UserID is available. For example, I would like to extract the user's primary e-mail address in AD and use it to lookup other details from our HR directory (exposed as web service). What are the areas that I need to look into in order to achieve the above results? Thanks. -- Best regards, Jude

Parameter Refreshing Problem

p1 = State (1-Georgia, 2-Florida) p2 - City(A-Atlanta, B-Decatur, C-Miami, D-Daytona) scenario1. Report1 opens(@p1 in(1), @p2 in(A,B)...works fine scenario2. Report1 opens(@p1 in(1,2,), @p2 in(A,B,C,D) works fine Issue: When in scenario1, the report is generated with one p1 value. When the user goes back and adds another value to P1, the P2 parameter is not being refreshed. But if you select all values on both, generate the report then go back and just select one value for p1 the p2 value refreshes. Help!

CRM Report Issue

I designed a custom report to run pending activities & assigned activities of current loggin user. This report is running in report server and showing current user's assigned activities. i am passing current user name in parameters as @User Name from sql query. After deploying this report into crm. its throwing an error message like this. "An error has occurred during report processing. The Value expression for the query parameter =91@UserName=92 contains an error: Index was outside the bounds of the array" The current user name passing from crm report as "NT AUTHORITY\NETWORK

marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 02197

Contato: marvendas@gmail.com marvendas @ gmail.com marvendas no gmail.com Kit completo de solenoides para Volkswagem e Audi. O kit contem: 5 solenoides 2 Epc ( solenoides de pressao ) 1 Chicote Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M Pre�o: R$ 1900.00 Temos outras tipos de solenoides e artigos importados, nao deixe de fazer uma consulta antes de comprar! Audi a3 automatico Audi a3 1.8 t automatico Audi a3 1.8 turbo automatico VW Golf gti automatico VW Golf 2.0 automatico VW Golf 1.8 turbo auto

datasources

I was wondering if it is possible to join 2 different datasources in Reporting Services.

Report Server Security Settings Problem

I am unable to deploy a report to my local report server. On my Window 7 Professional machine the reporting service is running, I am in the local administrators group on my machine, and I have administrator rights on my SQL Server 2008 Standard installation (a full installation). When I attempt to deploy a report from Visual Studio 2008 it says I don't have sufficient permissions. Also, when I browse http://localhost/reports the page displays but I don't have the "Site Settings" link. When I browse http://localhost/Reportserver I get "The permissions granted to user '***' are insuffi

A report embedded in an iframe when exported to a web archived format opens in the same IE window

Hi I am using SSRS2005 to produce reports which fetch data from MS SQL Server 2005 database. These reports are then embedded in an .net application in an iframe. Now when I try to export the report into a web archived format then the report opens in the same window in IE8.Due to this I have to click on the Back button on the browser window to view the remaining reports. Hence I want to open this exported report in a new window in IE8.But,I am unable to do so. Could anyone please help me to find out as to how can I open the reports in a new window in IE8.Are there any kind of IE settings whi

DESCARGAS - ANTIVIRUS GRATIS 7646

Muchos problemas de rendimiento y seguridad de tu computador son causados por virus maliciosos, la mejor forma de combatir esto es tener instalado un Antivirus reconocido y actualizado en tu computador Descarga gratis Antivirus en: http://antivirus-gratis-descarga.blogspot.com/ Links de contenido del sitio web: http://antivirus-gratis-descarga.blogspot.com/ http://antivirus-gratis-descarga.blogspot.com/2009/08/que-es-un-antivirus.html http://antivirus-gratis-descarga.blogspot.com/2009/08/descarga-gratuita-de-antivirus.html http://antivirus-gratis-descarga.blogspot.com/2009/0

Using a DLL

Hi All I am assessing whether we should move to reporting services to make available various company reports via the web. While most reports have a stored procedure origin for their data, there are a few of our reports that require some programatic massaging. These reports typically involve some specialised data pivoting and/or formatting. My question is, can reporting services utilise a custom dll as the source of data for a report? As an example, reporting services can generate a report from a stored procedure via a select statement. Can reporting services build a report fr

Form letter?

Hi, We send out a satisfaction survey each week and I thought I could save my administrative assistant some time by eliminating the mail merge step and just create the form letter out of SSRS. Right from the get-go I'm struggling. What is the best way to add the boiler plate text to the report? Do I simply add a bunch of text boxes? Since this is a survey there are check boxes and numbers to circle and so forth so formatting looks to be complicated. What is the best way to handle that? Is it possible to simply import a Word document? And finally, if these other questi

Protocol violation w/custm scurity on XP w/ a 2nd instance of SSRS

I am having an issue developing against a secondary instance of SSRS on XP. I install the secondary instance and everything is fine. I can browse to both instances, the secondary using the URL 'localhosts/reportdev'. I then implement a known custom security extension by deploying DLL's and making various changes to config files. The custom security enables the use of LDAP instead of Active Directory for item role assignment authentication. This bit is fairly complicated, but is known to work. When I then browse to the secondary instance of SSRS I receive the following error:

Displaying Parameters in the Report Title

I would like to have a dynamic Report Title that includes the Start_Date and End_Date parameters I have for a report. I have had no luck finding this information elsewhere on the internet. So, the report title would be "Number of Letters between @Start_Date and @End_Date" Thanks.

Pagebreak between group footers

I have a report that is grouped by Salesperson, then by customer. The footer for the customer group totals some fields for that specific customer then the footer for the Salesperson group totals some fields for all the customers that fall under that salesperson. The problem is, I need that salesperson total footer to show on a new page. I put "New Page After" the customer group but the problem is, it only works when exporting the report to a PDF or printed. When the report is exported or printed the Salesperson footer shows on its own page. But if you just run the report, the

turning off case sensitivity

Is there a configuration option to turn off case sensitivity in the BID/visual Studio reporting IDE/etc.? Our db collation sequence is case-insensitive so I know the problem is with reporting services. My problems begins when i modify some SQL - changing the case of a column accidently...BID then reports a 'missing column' error and i'm spending time dealing with it. Even when i correct the SQL - changing the case back to the original ASCII...BID still thinks its in the changed state...regenerating the dataset does not fix the problem....so here i am going through every control t

End of Support Date for Report Builder 1.0

We are looking to configure an environment that uses SQL Server 2008 Report Services and a majority of the team would like to use Report Builder 2.0. Howerver, some members have would like to use only Report Builder 1.0. Is there a defined end of support date for Report Builder 1.0? Is there any known issues with using Report Builder 1.0 in an enviroment where the models are built using BIDS 2008 and most reports will be written using Report Builder 2.0.

converting Crystal Reports to RS

SQL 2005 I'm brand new to Reporting Services, but have been a SQL developer for years. Up to this point all my reporting has been done using Crystal Reports. I'm trying to convert some existing reports from Crystal Reports to Reporting Services. So far I'd have to say I'm not impressed with RS as far as it's compared to Crystal. I know some of that is familiarity so I thought I'd ask a couple of basic questions here so I can be clear of my understanding of RS. Thanks in advance for any help/tips you can offer. My Questions: .. I'm using SQL Server Business Intelligence

Confused by Role Assignment for individual reports

I just built a couple reports and setup the Report Server on a 3rd party host The application that collects the data is public but the reports are for a single internal user only. I have added the report to the RS and I can execute it (I'm admin) without a problem. I'm trying to setup a specific login to the machine/RS so this one user can run the reports I've created a new user on the 3rd party Windows 2003 Server Then went into the Report Manager, clicked Edit for the 1st report, then Security, then New Role Assignment I typed in the user name (I tried it with and w

how to generate programmaticaly rdlc files at runtime using c#.net

Hello, I"m working with some application development(crm solution) with require to generate programmaticaly rdlc file at runtime, but i don't know how to do. msdn online help only provides tutorial on how to generate rdl file but not rdlc files. Any Help will be welcome. thank in advance. Stephane

Data Source Issues After Moving ReportServer DB to new server

Our report developers had created RDLs and posted to Report Manager. Then in Report Manager, reports data source is changed to point to a single new datasource set up in Report Manager. Now we have migrated Report Server database to new server using backup\restore (not RSScripter) but reports now generate error An error has occurred during report processing. Cannot create a connection to data source 'XXX'. The XXX data source is seen in the .rdl file. It seems that reports revert back to data source that was set up when developers designed reports in BIDS. Is there a

Email Subscription Column Width Issues

I have an email subscription and it always seems to condense the columns into very strange widths. The first column simply has a one word "event" and it always seems to have the last one or two letters pushed into two lines. It seems as if the emailed subscription totally ignores any column width formatting I may have done in the published report. I did find a posted solution about editing the ReportingServices.css file and adding a minimum width, but this did not work for me. Here's the link for that: http://stackoverflow.com/questions/1178838/setting-the-minimum-column-wid

Sort parameter list from Report Model

I am desperately searching for a way to sort a parameter list that is generated from a Report Model data source. We are using Report Builder 2.0. If this feature is not supported then I believe that this is a huge oversight on Microsoft's behalf. Users only want to pick from a sorted list!

Reporting Services deployment question

Hi, We have two buisness units in our company and we setup two separate SQL 2005 Servers, one for each business unit. We are just about to go live on the second unit and I have been creating some reports for them and was about to deploy when I realized I never installed IIS on this SQL server. So now I'm wondering what is the best course of action. Should I simply run all the reports off the first SQL server with the existing Reporting Services? Or, should I install IIS and configure Reporting Services on the second SQL server for reports relating to it. Not sure how to c