reports

Crystal Reports DateTime.MinValue

Hello, I want to know the minimum value of the Crystal Reports datetime datatype. I know .NET's, I know SQLServer's, but I cannot find anywhere on the internet Crystal reports. Thanks, ...

open source alternative to create reports in classic asp?

I'm looking for some open source alternative to create reports from classic asp they don't have to be something awfully elaborated, we rather find some simple product that allows us to generate pdf files from a data set. we were thinking about developing some kind of service that took an xml as input and returned a pdf, probably with j...

VS2008 and asp.net Microsoft Reports paging

Is it possible to make Microsoft Reports component use server side paging when displaying data. I had problems in the past with getting all the data from the database and then having client side paging implemented. large amounts of data were triggering out of memory exceptions on the server. So basically what I want is to use Microsof...

Is there a way to display balloon tooltips in crystal reports or SSRS

Hi, I have a report to build that has many different fields showing various results. As these numbers are not intuitive, I need some sort of mechanism to display a balloon tooltip when the user hovers over or clicks on a number. I am open to either Crystal reports or SSRS. I will just be limited to the free editions that come with visua...

Support Crystal report for hosting server.

Hello, I am running shared hosting server for asp.net application. I want to support for crystal report on my server. So that users web application use crystal report. Can any one know what is the procedure to support crystal report on the server. Thanks ...

How to supress empty subreports in SSRS 2008

Hey all! I'm creating a 'master' report in SSRS 2008 that collaborates other reports about a person. Sometimes not all of the other reports are relevant and as such return nothing. I'd like to be able to exclude this from the master report so it does not leave a blank page. I'm aware of the 'no-rows-message' feature, but a whole page ...

Crystal Reports Framework Download

Can anyone tell me how to download the Framework for Crystal Reports so that it will run on my development server? I have it running locally but when I depoly it, I get the error saying that the framework is not installed. I tried copying the dll's locally to the bin folder but that did not work. Everytime I access the SAP site, it asks ...

MS Access SQL Duplicate Rows?

Query: SELECT DISTINCT ([Equipment List].ID) AS Expr1, [Job Assignments].Job FROM [Equipment List] LEFT JOIN [Job Assignments] ON [Equipment List].ID = [Job Assignments].EquipmentID; In this query, the equipment ID is distinct if and only if I do not add the [Job Assignments].Job in the select statement. As soon as I do, I get ma...

Whether probably to add a static column in Matrix component (Reportviewer .NET)?

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? ...

What is the most efficient way to create an order count summary by hour, day, month in SQL Server 2005?

Given a table: create table #orders ( orderid int, orderdatetime datetime ) What is the best way to write sql to output a report containing the count of orders from the current and previous 24 hours, total orders for the current day and previous 7 days, total orders for the current week and previous 4 weeks, and total orders f...

Crystal Reports Dashboard

I am trying to create a Crystal Report 2008 file that displays different key data on one page. Does anyone know of an easy way to accomplish this or a link on how to do this? Thank you. ...

How to merge Cognos Reports

We currently have a manual process when we update reports on live.. from our test environment.... to manually merge changes into our new development environment. This is tedious. Is there a way to automatically merge two version of the same report so both changes take? Is it possible to merge the xml report specs of the two? without ...

Multilingual Reports...

Is there any reporting tool which offers multilingual support (namely English en-US and Arabic ar-KW) and support for Web report viewing in IE6 and above. I don't want to end up making different reports for each added language. Development platform for this is ASP.NET 3.5, Crystal Reports or any compatible reporting tool, SQL Server 2000...

How to see the actual query executed by an Oracle report containing an error

Like most Oracle Reports in O*Financials, the query is made up of dynamic parts depending on the parameters entered. When I run the concurrent request the log file contains an obscure error: ORA-00933: SQL command not properly ended d.acctd_amount_dr, d.amount_dr) ) C_AMOUNT , trx . trx_number C_TRX_NUMBER FRO...

Right reporting solution in a .Net environment

I have a reporting requirement in my web application for which I am looking for off the shelf solution. I don't have any experience of reporting softwares so thought of checking with SO community if anyone have any idea of reporting solution which fits my requirements. The application will be developed in .Net and apart from other funct...

C# Client side subreport get render on second page

I have a subreport and header on C# client side report when data is fitting on one page subreport start on 2nd page but if data is coming across two pages then it start from one page , can you please let me know what is problem I read that it is microsoft issue , do they have any soln to this.??? or any workaround I need to Use subreport...

Crystal Reports XI and MySQL Stored Procedure with Parameters

I am having a problem with a Crystal Report that displays data from a MySQL table. I am currently gathering the data directly from the table, however when the users try to input parameters, problems arise such as: null values for parameters returning errors parameters not working as specified I then created a stored procedure to re...

How do you add textboxes to Oracle APEX reports?

I'm generating a matrix report in Oracle APEX. I've got the values displaying properly, but when I click the "Edit button", I want all the cells to turn into textboxes. I know that you can do this by changing some settings in the Report Attributes, but the problem is my matrix report is dynamic, which means that I do not know in advance...

Can't create new project in Team Foundation Server

We're switching over to Team Foundation for our version control, and I have to learn it and set it up. Our IT guy did the installation of the both the data tier and the app tier, and he is of course convinced that it's right. However when i log in as tfssetup and try to create a new project, i get the error: Error Insufficient permis...

Birt Web Viewer

I recently installed the BIRT all in one developer program and started fooling around with some reports. Now I want to share my reports with fellow workers - What is the best way to set up a BIRT report portal? (I Ran the Birt-viewer-demo that is on the eclipse site, but it lacks an options to view all available reports and manage them...