reporting

Regarding report Generation using Jasper Reports

Hi, I have a requirement of generating report depending on the query & its associated columns. I should write 2 queries & based on flag conditions particular query has to be executed to generate report with its column data to be displayed on report. All this should happen with a single jrxml file. Please help me on this also please req...

In SQL, how can I count the number of values in a column and then pivot it so the column becomes the row?

I have a survey database with one column for each question and one row for each person who responds. Each question is answered with a value from 1 to 3. Id Quality? Speed? -- ------- ----- 1 3 1 2 2 1 3 2 3 4 3 2 Now, I need to display the results as one row per question, with a...

Ecommerce Gems for ROR?

I'm working as a project manager on a site with an Etsy-like shopping cart setup (allowing users to sell their products and taking a small percentage of the sale). While I expect my developer to answer this question, I figure it can't hurt to ask if anyone recommends specific gems for such a shopping set-up in RoR or financial reporting....

Disable caching in System.Windows.Forms.WebBrowser

I am maintaining a .NET 2.0 application that uses a System.Windows.Forms.WebBrowser to display reports from Reporting Services 2005. Caching is disabled for all reports on the server, and this seems to work as expected. The problem is that the WebBrowser control insists on checking Temporary Internet Files for a cached copy of the repor...

SSRS Reports Add Reference

Hi, Can someone tell me whether this is possible. I have an existing SSRS project which contains a SSRS report (Call it report1). I have created another SSRS Project and in this i added the Report 1 SSRS report to it. The problem is that when i add the reference it is creating a copy of the SSRS report in the new projects folder. What i...

ASP.net Microsoft report viewer printing error

Hi All, I am using a Microsoft report viewer control to view a local RDLC report in an asp.net website. The report is correctly showing and looks good. But I am having one issue. On some computers, when the user clicks the print button, we see a message box that just says "An error occurred during this operation". None of my error lo...

Report Designer Select appropriate value

I am using Visual Studio to create a Report. I am having a problem getting the appropriate value into a text field. Bare with me, because I am new to using Report Designer. I have a DataSet with these values: InfoPathFormsWorkflow AvgProcessTime_Sum AvgProcessTime_Count This DataSet will only have 1 or 2 values in it. It is being popul...

[BIRT] how to force page breaks ?

Hello everyone, I have a table, grouped by an element, like this : [GroupingELT] Header1 | Header2 [ELT1] | [ELT2] And i'd like to have the [GroupingELT] alone in the center of a page, the table on the next page and so on. Could you help me with that ? I'm new to birt (started today :p) so don't hesitate to redirect me to...

Reporting Service in maintance mode

Hi, I'm trying to put RS in maintance mode. I've tried to put an app_offline.htm (usual for IIS maintenance mode), but get en RS error message instead of the message set into app_offline.htm. Any idea ? Regards. Stéphane ...

Problem with SQL Server Reporting Services

Hello. Friends I have a problem with SQL Server Reporting Services ..!!! I have some reports that show no data, the reports are on a separate server from the server that contains the database, the Data Sources of the reports is well configured. Stored procedures are executed while the server (display data) users have the necessary perm...

Restricting table row in SQL Reporting 2008

Hey Guys Need to restrict the number of rows in my tablix, and have the left overs go to another page and also be restricted to the same amount and so on.... So my sample dataset has 2 records, to test I added a Grouping Expression as described here http://msdn.microsoft.com/en-us/library/ms157328.aspx =int((RowNumber(Nothing)-1)/1) ...

Writing Legacy asp application in asp.net

I need help in choosing the right path while trying to rewrite a legacy application. Just a little bit of oversight, the current application is a web reporting tool in which the columns and the query text are read from database. Users will filter and hit on a button “Create”, then the report will be displayed on an html page. For perform...

Free reporting for WPF

Hi All Is there any free reporting tool for WPF, if not then for Windows Application will do. thanks ...

What is the easiest way to visualize transactional data utilizing using a data dump like MySQL, CSV etc etc

Essentially I want to be able to feed it data and see fancy charts and graphs displaying information out of the data based on x amount of transactions etc etc and/or SQL statements etc. It does not matter if it is client based or web based. Open source would be great but commercial is fine also. Thanks ...

How to create a Cross-Tab Report with Split Grand Total

Can We create such kind of reports using Crystal Reports XI Cross-Tab? Product Sales Comparison +---------------------------------------------------------------------------------+ | | Jan | Feb | Mar | April | May | TOTAL | | |---------------------------------------------------...

Reporting Services FileShare Delivery - Password must be encrypted

Hello, I am currently using the Reporting Services 2005 API to create and edit subscriptions. In order to create a FileShare subscription I have to submit a password in clear text. This is a major security risk. Is there a way to submit an encrypted password using the API? I don't want to require the user to have SSL. Thank you in ...

How to run a rdlc using coding.

I have created an rdlc where i have used dataset taken as a new item in solution explorer for designing my report. After binding my report from that datasource which is named as Dataset1. I have created its object and tried to fill this datasource using coding. Now when i runs the folowing code i am not getting any result. What can be ...

SSRS parameter - Upload text file?

HI, Can you upload a file as part of sql server reporting service 2008 parameter? I would like to be able to upload a text file list contract ids and produce a report based on those contracts. e.g for these 100 contracts what date were they entered into the system. I could have a parameter field which takes a list of comma separated ...

Error on iif for color expression

I have this statement =iif( ((Fields!lngCount2.Value-Fields!lngCount.Value)/Fields!lngCount.Value) > 0 and Fields!strSegmentName.Value ="Struggler" or Fields!strSegmentName = "Winback" or Fields!strSegmentName.Value = "Former", "Green" , iif( ((Field...

What report-writer does WebERP use?

WebERP is an open-source ERP tool. It has a cool custom report writer that allows you to generate reports by selecting fields from existing tables. Just wanted to know if anyone is aware of the component used there in.. And share their experience with it! Thanks & Regds, PG ...