In MS Access exist "Display When Property" witch can for one objects on report define where it is going to be displayed (Print Only,Screen Only,Always). Is there analog function in SSRS2008. I usually use IIF() in visible properties for conditional showing or hiding data, But i do not know how I can something hide when it is going to pri...
What are my options to allow local reporting in my environment? I have an existing central reporting services already working that they access through the web. I now need to offer those same reports on there local machine. What are the local reporting options? Each local machine has SQL Express 2005 running on it. Would I have to ...
Hi there. I'm using visual studio 2008 with c#. i want to show that result of query on my column chart. My query is : select (select count(cinsiyeti) from Hastalar where cinsiyeti = 'E') AS ERKEK , (select count(cinsiyeti) from Hastalar where cinsiyeti = 'K') AS KADIN i m giving values and dataset name. values: =Fields!Erkek.Value and ...
I am spending too much time researching reporting tools. My setup is a (SugarCRM) MySQL database on a wamp server (or maybe it is lamp - I'm not sure yet), but likely to need other environments also. Clients are mostly WinXP, but could have a Mac or two. Would prefer a program like Crystal Reports, but free. Requirements are: easy...
Hi, Last night I installed sp3 and cu1 on a 64 bit SQL 2005 failover cluster. Everything went well. Reporting services is installed on the primary node. It now cannot connect to Oracle. The initial errors seemed to be related to this: http://support.microsoft.com/default.aspx?scid=KB;en-us;870668 I granted network service access, b...
This one's tough to explain, so I'll try to show what I'm after using examples. Please note that I'm not asking if it's possible to use multiple columns in a BREAK statement--I know that it is. Suppose I have a query like the following: SELECT invoice_no, invoice_date, vendor, account, amount FROM invoice ORDER BY vendor, invoice...
I created a report in reporting services 2005 with a report page size of 14in x 8.5in. The report looks fine in the reports manager and also in the report viewer. The issue is when I export the report to PDF, the page size in Adobe states 14 x 8.5 in but when you hit the print button, it selects Letter size (8.5 x 11) instead of choosing...
I'm a newcomer to using Microsoft Reporting (RDLC) and I'm trying to display a table with a checkbox inside of it. The data I have is stored in bit fashion: I want this data to display on the report like this: I can get the data to display in a normal table without issue, but when I do, the bit values are formatted as "true" or "f...
Hi there ! I'm working v.s 2008 with c#. I have a xsd file and i m writing a method in that DataSet's .cs file which is return a datatable. also i'm using a report wizard. And i want to my report using that methods. how can i give my method to my report as a reference? ...
What reporting asp.net library would you recommend if you would like to do the following: Generate reports Print reports ...
I have a Crystal XI Release 2 report that my client wants to see on two pages. He wants the report to print the demographic information such as (name, address, etc...) for a person on the first page and the totals for the person need to print on the second page. The first page will include as many rows as will fit and the second page wil...
We need to choose the reporting engine for our ASP.NET application. The main functional requirement is an ability for end users (not programmers, just normal users) to create custom reports. We will be using SQL Server as a database so I am aware of some options: SQL Server Reporting services, Crystal Reports, Active Reports, even Windwa...
I have an application that sends a report path and parameter collection to a Microsoft Reporting Services server. One of these reports is very long running and when users try to generate reports within a few seconds of one another, one will receive a duplicate of the report requested by the second user. This doesn't happen as a glitch,...
I'd like to order a set of webpages showing inside a content query webpart by 'most viewed' I know sharepoint keeps track of such things but I don't know how to expose this list to the content query web part - can anyone point me in the right direction? Thanks in advance ...
I have a very specific problem with a Gridview I am displaying. Believe it or not my customers need to see roughly 30 columns for a particular report. Obviously displaying these legibly is impossible and I am looking for suggestions on how to achieve this neatly? I was thinking Ajax tabs groups columns together naturally on differing ...
I'll preface by saying that these reports are generated through a C# application; I have customers who send me a template (Word-document) for a letter or report which they wish to populate with data (text, images, etc) from their database (which is used by their CRM system). Usually I will have to re-design these in Crystal Reports and ...
I have a report example two fields [Name1], [Name2] what is the expression for conditional formatting on name1 to highlight when not = to name2? Is it: <>[Name2] it is not working :( ...
I'd like to integrate some high-level reports into my WPF application. Essentially, the user will enter some parameters, press a "Go" button, and will be presented with their report. A report will consist of some text, some tables and some charts. What technologies, tools and libraries are available to my WPF application? ...
I've got a jasper report to do, with data like this: Item | Quantity | Color ------+-----------+-------- A001 | 1 | Red A001 | 1 | Green B002 | 3 | Red B002 | 3 | Purple The report is grouped by Item/Quantity, e.g. Item: A001, Qty: 1, Colors: Red,Green Item: B002, Qty: 3, Colors: Red,Purple ...
I wish to use possibilities of Matrix component for creation of dynamic columns. But thus I need to insert and static columns (for example, date of operation and a name of the person). How I can realise it? ...