We currently have two web servers (Windows Server 2008 Standard, IIS7) setup to host an ASP.Net website and are using the basic features of our hardware firewall to provide network load balancing (NLB) between the two servers. This means we have had to change the ASP.Net session state mode to SQL Server in order to make the data stored ...
Here is my problem. The bar chart report is showing data on x and y axis (y axis has 3 fields - min, max, avg values for time frame) and x axis has task type. For some reason, the chart only shows task types on the x-axis for some apparently interval, even though I have no interval set expressly. Any ideas? ...
Hello, As you may be aware there is a peculiar situation with the display of column headers in SSRS2008... i.e. you need to dig around a bit to get them to repeat on every page. http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx All of the examples I've seen rely on some kind of...
Hi, I have visual Studio 2008 and sql server 2008 and Integration Services installed too. I uninstalled the reporting Services. I don't have reporting services in my machine anymore. But still I can see the Report Server project in the Visual Studio. I can still design,build and preview the reports. I am wondering, how come I can create...
Problem: Printing from within BIDS 2008 R2 "Preview" tab hangs and must have the process ended in task manager. Facts I can set the report as StartItem under Debug Configuration Properties for the project and then run, producing the Preview window. And then successfully print. I can deploy the report to the Reporting Services server ...
Hi all, I am facing some problem with an RDL report. I have design 1 report, passed parameters also & bind with data source. After design when I click on preview button it runs in an infinite loop and does not show any output. If I run the same stored procedure in sql server with same parameters it gives me output in 1 sec. By same pro...
Is there any article or documentation describe converting Cognos model to Report Model for Microsoft reporting server? ...
what is the best Solution to change tablix layoutdirection at run time ? I want to Swap column order cuse iam using tow language in my report (Arabic , English ) , i want to sawap Tablix layout direction from LTR to RTL at Run time , cuse in this prop i can't write expression ...
I am building a report in Reporting Services 2005, where the data is retrieved from an Informix database. The connection to the database is declared via ODBC. Here is the simpler version of the query: select prodtype, familynum, family, sum(invested) invested, month(recevdate) month, year(recevdate) year, d...
Imagine you have 2 applications Application A and Application B. Basically I would like to insert records that exist in Application A into Application B. Sql Server Reporting Server is available on Application A And I was wondering if it is possible to build a report that gathers the record that I need and then publish it as a web serv...
I have a bit of reporting services know how but I'm looking to expand my knowledge. Does anyone have any recommendations on (free) online training materials for this (2005 unfortunatley) ...
I have a batch detail report in SSRS 2005, the left most column is an NTEXT SQL field. I need to show the field in the report either as: 1). A collapsible text box so users can view detail in the field by clicking the expansion control OR 2). As a tool tip, so when users hover over the column, they can view the full detail I can find co...
Hi, I've put together several reports which render exactly as I'd like them to in the preview in Visual Studio, but when I view them in a web browser, they render as required initially but are quickly squished into the left half of the browser window by the viewer. The zoom level is set to 100% - setting it to Page Width zooms the repor...
When I print from report manager in reporting services (2008) the quality of the output is terrible with fonts that look great on screen being very blurry and badly sized. Is there a known issue here? ...
this error happen when running report server rdl report that have rdce Extension dll file Implementing of ProcessReportDefinition working under vs 2010 and sql server R2 what is missing ? tank's ...
Hi there I have a table in my report, where I have columns of the datatype Time(7). Now I have problems formatting them correctly in Reporting Services 2008. If I set the format of the expression to HH:mm it does still display 11:12:000 ! I want to get only the hours and minutes! like 11:12 It looks like RS does not knot the format....
I have reporting services setup and can publish report to it by hitting deploy in Reports Solution. After publishing I can view them through the web server and they work as expected. However if the report contains any row group the deploy times out. The preview function will work correctly, but publishing times out regardless of timeo...
I have a table that has two columns, ID and Value. For this example lets say there are three rows: ID Value A 1 B 2 C 3 The number of rows will remain constant, so I can create a field for each item I want to display, e.g. ItemAID, ItemBID, ItemCID, ItemAValue, ItemBValue, ItemCValue, however I don't know if that would be the...
I've got a report requirement that is: Have 3 worksheets that is data pulled from a SQL database (easy.. done) Find an Excel document on the network, and copy all the worksheets into this report (??) I've been searching and the only thing I could find was to use EXCEL as a datasource.. where you would then select * from sheetname. T...
Good morning fellow stack overflow people, I have a question that sounds like the start of something from the daily wtf. The company that I work for is not so much sacred of new technology they just seem to let things slip, you know the type, “It worked 5/6+ years ago so I don’t see why we should change it” Despite this I have managed ...