Hello Everyone, Is there a wizard of Visual Studio add-in that I can use to convert MS Access Reports to SRS 2005? Regards, Pete Zerger, MCSE(Messaging) | MCTS(SQL 2005) | MVP - MOM Founder, SystemCenterForum.org URL:http://www.systemcenterforum.org BLOG: http://www.it-jedi.net/ m...more >>

I have 3 textboxes in report: 111111 222222 333333 If second textbox visibility hidden expression evaluates to true, ReportViewer shows third textbox immediately after first like 111111 333333 I need that empty space if preserved if textbox is hidden:: 111111 333333 How ...more >>

We are currently running SQL 2000 and I would like to start using reporting services. Is VS 2005 compatable with SQL 2000 reporting services? All references I see for 2000 reporting services refer to VS 2003.net...more >>

Hi, I am using sharepoint integrated reporting service environment and i have created a report in ASP.Net 2 by using report viewer and passing parameters from custom Form. My report displaying a column in which i have used "Jump to Report" that link with another report. when i clict to that ...more >>

After I've installed the sql server 2005 sp2, some reports have a strange behaviour. For example In some case the Inscope function in a matrix, in the subtotal column, returns different result (between sp1 and sp2) And if I calcuted sum(field!FieldName,"row_matrix") in the subtotal column ...more >>

We are working on a project that includes the development of business classes to contain all our data access routines. The goal is to be avoid writing numerous sql statements (some quite complex and some duplicative) in SQL Reporting Services, forms development etc.. We've tested this mod...more >>

Hi There, I loaded Sql Server and Reporting Services up in a Vista Business box. Sql Server works fine and has the two Report Databases (ReportServer, ReportServerTempDB) and Reporting Services starts up in SSMS. In SSMS I get the Home, Security and Shared Schedules folders. When I click...more >>

i looked at all ms chart samples. I was just curious whether they can be interactive where i can drag and change the parameter dynamically to see the results thx ...more >>

Every report I've done puts a blank page in between each report page. The page header is printed on all the blank pages. I haven't specified any page breaks anywhere. Is there a way to get rid of the blank pages?...more >>

Hi guys. I'm new to reporting services, and I put a simple bar chart in place just fine. Now one thing that I need to do is to format the graph in a way that only the x and y-axis lines are displayed. I don't have the need to display any other grid line. Its just the x and y. I can't find a...more >>

I'll try to best explain the issue I'm having and the setup I'm working with. ISSUE - I'm getting a 401 Unauthorized error when trying to view a report within a web page using the reportviewer control, even if I "Hardcode" the username, Password, and domain for the credentials. Setup - we ...more >>

Hi; does any one knows what's the problem here? declare @ANOACT CHAR(4); SET @ANOACT=RIGHT(@FECHA,4) exec('Select c.CTA,c.NOMBRECUENTA ,c.naturaleza,s.* from Grupovilla.dbo.CuentasContables c left outer join ' + @BASEDATOS + '.dbo.cnt_Saldos s on c.id_cuentascontables=s.id_cuentascon...more >>

I want to display the content stored in image column. Can anyone tell me how? The content is actually XML text, encoded and stored in a image type....more >>

I am new to reporting services. Maybe what I am trying to do is not possible. I would like to add a "Business Intelligence Project" to an existing solution so I have the convenience of the "Report Server Project Wizard" to build a report. My problem is that I can't figure out how to refer...more >>

I have a ReportViewer on a web page which is set up to allow export to PDF, Excel etc. I would like to be able to intercept the export event and if the output will be large then schedule the report for processing and delivery to the files system either at night or perhaps during the day via a ...more >>

I have a report that works. It has been added to a webform (dot net 2.0) that works. It has an image control in the upper left hand of the page header. I would like to be able to change that graphic depending on a sql table setting as the web form loads, Does anyone know of a good detail...more >>

Anyone else have this problem? I deployed a custom forms authentication library with a ASP.NET login page when I go to http://server/reports it just sits there for a minute with the progress icon spinning in IE then eventually I get a Threading timeout from Reporting services (in the attache...more >>

I got a error like below. Anyone has any idea? ================================== An unexpected error occurred in Report Processing. (rsInternalError) Get Online Help For more information about thi...more >>

Hi; im sure this is a prety dumb question... how can i use the value of a textbox (named "ENE") on another textbox's expression? TIA ...more >>

Hi All, I do have a question about the report viewer web part in SharePoint 2007 / SharePoint Services 3.0. We like to have a custom report parameter section, is it possible to modify or extend the SharePoint Report Viewer web part? Or do we have to create one ourselves. If so, have can we ...more >>

I have a picture which saved in the sharepoint piture library, I can see it via IE, the url is http://sharepoint/My20Pictures/01.jpg But when I add it as an external image, it does't show when I review the report. Please advise! Thanks a lot!...more >>

Is it possible to configure combo box with values depending on another combobox selection in Reporting Parameters e.g. Input1: a combobox with country Input2: should dynamically display states in the selected country, which user can select. appreciate any pointers . thx ...more >>

I have setup the printer delivery sample and tried several things. After a week of reading posts and trying different things I finally have gotten it to print to one network printer. Now the output is not formatted correctly. I cannot get the report to render as landscape and the font is too ...more >>

I have a report that I would like to allow the user to use the Ctrl key to select mutiple cost centers in a report parameter field. Does anyone know how this would be done? From http://www.developmentnow.com/g/115_2004_11_0_4_0/sql-server-reporting-services.htm Posted via DevelopmentNow.com Group...more >>

I'm getting a strange error when deploying a report: Server was unable to process request. --> Could not find file "C: \WINDOWS\TEMP\7qifavw2.dll". The strange part is that the dll file name changes each time i try to deploy. The deploy function was working when I left last night, and not ...more >>

I have a subreport within a report that contains a table. I am defaulting the number of rows to display in the table to 20. Is there any way to make the number of rows to display interactive and, perhaps, even a drop-down as part of the table header? I don't want the user to have to change ...more >>

We have several reports that are based on tables or matrices, but also include additional textboxes. Also, in order to get an alternating color for rows in the matrices, an extra grouping has been added to the matrix. The placement of the extra textboxes (and the extra grouping within the ...more >>

Does anyone have any examples of a c# program and that returns a record set from sql server that could be compiled and referenced as a data source in an RDL file? If so I would sure like an example of the C# and the RDL file that references it. Thanks....more >>

Hi , Is there any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel horizontally. I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped. ple...more >>

Hi I'm fairly new to Reporting Services. We have three or four parameters in our reports. The FirstDate and LastDate parameters (datetime) are disabled or locked until we fill in information in the other parameter fields. If the date parameters are first in the list, they are not disable...more >>

I have a Web application in Visual Studio 2005 using 2.0 framework with the latest service packs. I use the report viewer to get the reports into the reportviewer control. Every time I try to use the paging (clicking NExt on the report toolbar) so I can flip through the pages of the repo...more >>

SSRS 2005 When I want to preview a report in the print dialog box the explorer window stops respondingen. I've found some topics in this forum on "black" previews, but I simply get nothing: the print dialog box disapears and the explorer-report window stops responding. Thanks for any ...more >>

Hi: I'm creating a report that has a landscape layout, but when I print it from the reporting services report manager (web interface), the printer applet shows the printing configuration as "portrait" and the paper size as "letter rotated" and report prints wrong under these settings (out ...more >>

Same issue as reported in some other posts... Reporting Services section missing from MOSS 2007 Application Management page. Here's what I installed per the integration docs: Server 1: SQL Server 2005 / Reporting Services 2005 SQL Server SP2 WSS 3.0 Server 2: SharePoint 2007 (an exist...more >>

Hello, I have a multi-page report which needs to list the total for the page in the page footer, the total for all the previous pages, and the current overall total. For example: Page Total: 25 Total from previous pages: 40 Overall total: 65 I have the items and their prices listed in ...more >>

(sorry, previous posting went too fast - in the middle of editing) on sql05, from vStudio05, I created a report, it shows fine in preview. and was deployed successfully. on //localhost/Reports it is listed as New, and on //localhost/ReportServer a new <dir> is added to the list, and insid...more >>

Hi, on sql05, from vStudio05, I created a report, it shows fine in prevew. I deployed successfully. on //localhost/Reports it is listed as New, and //localhost/ReportServer a new <dir> is added to the list, and inside is the report. However, I cannot display the report from either page. th...more >>

Here's the situation... We have a report that has been deployed to production a few weeks ago. Since then the report has changed slightly; two parameters have changed--one parameter went from not being marked internal to being marked internal and the other parameter's default value changed (ju...more >>

Hey all, Is there a way to pass the value of a field in a sub report to a main report? I have a field that holds the sum(of values) computed in a subreport. I would like to use that value in an equation in the main report. In Crystal Reports, I would use a shared variable. Is there a way to d...more >>

Does anyone know of a time frame on when SQL 2005 Reporting Services will be able to handle the embedding of HTML into a report? I saw on an old post that it is was supposed to be released in a follow on SP. Does anyone have suggestions in displaying HTML into a field in a report beyond converti...more >>

I cannot figure out why I have a blank page in front of my report. I have hunted and hunted to see what I have set that would be causing this. The blank page is generated when I print to paper, Adobe or Excel but not in the preview. Any suggestions? Thanks! ...more >>

Hi, I recently made a matrix report and I have a small problem with it. I'm trying to add a row that contain the total of each column but I'm not sure how to do that. Do I need to do something at the query level or this can be done within the report designer? I'm using SQL 2005. T...more >>

I have reporting service installed, but I didn't install it. I cannot figure out where the reporting service database located. We have two SQL servers and the databases reside on BOTH servers. Also the resportserver.mdb and reportservertempdb.mdb files reside on both servers (obviously) an...more >>

I neet to attach ( embed ) some extra documents end of my quote form conditionaly by Quote Products please help :-)...more >>

Hi. I have a web application developed in VB.Net2003 with SQl Server 2005 as database engine. I develop some reports using the Reporting Services of Sql Server 2005. Now I wan't do show thus reports in my application. Can anyone explain me the best solution to do that? Best regards, Sérgio ...more >>

I want to create reports from a database that use binary(16) as data type for key fields. How can I pass this type as parameter from a query?...more >>

please let me know the steps to set =Int((RowNumber(Nothing)-1)/2) expression for pagebreak in rdl file....more >>

Hi all, using SQL 2000 SP4 I'm new to Report Services. Where it the rdl file stored when it is pushed to the server? thanks gv ...more >>

Has anyone been able to call an AS400 stored procedure from Reporting Services? ...more >>

Hi I installed the printer delivery sample.When i tried to set up the data driven subscription with delivery mode as printing to a specific printer.I am getting error. Done: 2 processed of 2 total; 2 errors. When i set it as an email.Its working.I am getting email.I could successfully...more >>

I am currently designing a series of reports (.rdl) for Microsoft Dynamics CRM 3.0 using Visual Studio 2003. I have added hyperlinks to the data so it drills down into the relevant forms for some of the data included into the reports, and I know I can also drill down into other reports in the s...more >>

I would like to write some reports that will query T-SQL for information, but I don't what anyone to be able to see the T-SQL code. So I can not store the T-SQLin the RDL file, or put it in a SP. Also can't even use and encrypted SP because someone would have to have the source code to creat...more >>

I bound a report parameter to a combobox. I tried to configure default parameter as null several ways in report parameters properties dialog but could not. How can i specify default value of null for a combobox parameter? thx ...more >>

I see that you can import Access reports into Reporting Services. Is that an add-in or something that will allow me to import Crystal Reports reports into Reporting Services? Any help is greatly appreciated. ...more >>

Hello all, Is there any way to return a multi-value parameter as a sum of the values instead of a comma seperated string? For example, I have a table where one of the values is a bitmasked number, representing a combination of 4 possible options. I have the Report Parameter setup with Non-que...more >>

Hi All If anyone have any idea - please post. I'd lost all my ideas in last few days :) System: SBS 2003 R2 Sql 2005 Workgroup Reporting service installed. On Configuration tool - all credentails on Network Service, on Web Service Identity error: Asp.Net Service account is empty Report...more >>

Hi all! I am running reports with RS 2000. All of htem are subscribed for e-mail delivery. For a large report I get the following error: “Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc6d. The server response was 552 message lin...more >>

Hi I have created a very simple report in SSRS, which counts the number of Supplier transactions. I have added a Multi-Value parameter with two values, (I or C) to filter either Invoices or Credits or both. If I query Invoice only, I get the correct result. If I query Credit only, I ge...more >>

As stated in: http://msdn2.microsoft.com/en-us/library/ms155816.aspx A multi-column layout applies to the entire report. It is not possible to specify a multi-column layout on the top half of the report, and a tabular layout on the bottom half of the report. However, that is EXACTLY what I ...more >>

Is there a way to ensure a matrix layout does not expand horizontally past a certain point (i.e. page)? There appears to be an option to try and fit the matrix on one page but that doesn't stop it going over multiple pages in the horizontal direction. Thanks ...more >>

I installed SQL 05 and all it's options including RS, however I don't see any programs to launch any RS programs other than the configurator. What am I missing here? Mike ...more >>

Hi; i want to add extra separation between lines when a field has certain value... right now, i tried bottom padding and Lineheight but none seems to work.... this is the expression i had on my table detail's line bottom pading : =iif(fields!UTIL.value="T",10,2) Any advice? ...more >>

I have multiple reports that require the same datasets can I share them or copy and paste them from one report to another? How? ...more >>

I have a report that displays the data in a dataset in 2 ways using 2 different tables. Currently, I have one dataset defined that is generic enough to be used for both tables. The grouping logic is defined within the tables. Is the call to the database being done once or twice? I'm wonder...more >>

Hi all Gurus In reports when I set the Multi Select option for parameters then size of parameter box does not increase according to Length of parameter string value. It remains fix at default values and I have to scroll horizontally to see full parameter string , this is very tuff because our...more >>

Hi Microsoft Sql server reproting services restarts the windows xp installed desktops when we try to print using the print oprion in the report. This is happening for lot of my clients. How to fix this. This is happening only after the latest update in March. My company has aroung 40,000 pe...more >>

Hi, I have been given the task of migrating our existing 2000 reports from our MSSQL 2000 database etc to MSSQL 2005 / Reporting services. Does anyone have any information (links, recommendations) about the best way to approach this migration and any caveats about doing such a migration? Th...more >>

To reproduce: 1. In C# create Code module : public class Util { public static bool Empty(int nValue) { return (nValue == 0); } } 2. In report hidden expression call use this function with integer field parameter like <Visibility> <Hidden>=Util.Empty(Fields!myintegerfield.Value...more >>

Is it possible to use Reporting Services to create a recursive hierarchy where the root node is created under higher level grouping? For example, suppose there is the typical employee table with the manager ID, which of course is the recursive table. If that table had a Department No field...more >>

I'm upgrading from SQL 2000 to SQL 05, cannot figure how to add/link reports in SQL 05 reporting services. The process in not the same as in SQL 2000. Mike...more >>