reports

MS-Access reports shows design view upon execution

I have created a report in MS Access report and write some VBA code to retrive data and show the report in MS-Word format. But while generate the report on runtime, the report first show or flash the report design view for few seconds and the report will get generated. I would like to find a solution to avoid this flashing of design v...

How to automatically reload a report in MS Access?

I have a report in MS Access where the underlying data in the tables changes irregularly. I'd like the report to reflect these changes automatically, either by reloading the form say every 10 seconds or either the report gets a notification about the changes and shows the new data. Is this possible? ...

Moving ssrs ad hoc reports.

We have a reporting server which has a bunch of reports and some ad hoc user reports created by users using report builder. Now we need to move all these to a different server. The new server already has some reports in it. I need to move all the reports from the older server to a folder in the new server because of this moving the datab...

stop Ms Excel auto-formatting numeric strings as numbers

I am exporting a report from MS Access(2003) to Excel (97-2003) output. One of the columns has a character string that is numeric for some rows e.g. "05-0880". When I open the output file in MS Excel the corresponding cell is set to the number -372424. I assume this is caused by Excel being "clever" and deciding that "05-0808" repres...

Is there a "result server" that store performance test result, with good analysis tool?

I need a "result server" that can store my raw test data (server cpu, memory usage, etc), create report template (e.g. user number vs response time), generate live-reports base on templates, and perform complicated analysis (such as 70/80/90 percentile charts, data distribution comparison between test, etc.) ...

How to design good looking reports?

Hi, i'm currently doing some reports for SSRS, and i just confirm what i already knew, i suck at this thing of color matching and making things look pretty. Does anyone know a good site or something to help me figure out how a report should look. I need help! any website or recommendations would be highly appreciated. I tried trying to ...

SQL - Need to find duplicate records but EXCLUDE reversed transactions

I have a table of transactions which will occasionally have duplicate entries. If/When an admin finds these duplicate entries, they will reverse the transactions, therefore creating a negative value (but the original duplicate still remains due to regulatory requirements). I'd like to create a SQL query (and use Crystal Reports) to make...

Reporting Services Interactive Sort and Paging Problem With ReportViewer

I have been having a strange problem with interactive sorting and paging within a ReportViewer that I can't figure out. I am using a local report definition and a ReportViewer control within an aspx page. I have AsynchRendering set to true. Everything seems to work fine except for this problem. Here are the steps to reproduce the pro...

Radio buttons in SSRS Report

Hi, How do I add radio buttons as my parameter type in SSRS reports? Thanks in advance, Anna ...

How can I hide duplicate records (within a crystal report) which have already been reversed?

This question is a follow-up to a question I asked the other day ("Need to find duplicate records but exclude reversed transactions"). I have a Crystal Report which displays customers' fuel transactions. There are occasions when a duplicate transaction will be imported erroneously. If/when this error is discovered, the admin will reve...

Powerbuilder Date Math

How do I subtract 30 days from a date in PowerBuilder? I have the following code that returns today's date in a parameter, but I need today - 30 days: dw_1.setitem(1, "begin_datetime", datetime(today(), Now())) ...

Write stored procedures in Linq/Lambda (Unit-testable but performant stored procs). Possible???

I am creating a data source for reporting model (SQL Server Reporting Services). The reports requires a lot of joins and calculations (let's say, calculating financial parameters like money spent on this, that, amount A vs amount B)...all this involves subobjects. It makes a lot of sense to me to write unit tests for this code (i.e. wal...

PHP/MSSQL Report Writing

What is a good method of writing reports using PHP and MSSQL? Is there a third party vendor that supports MSSQL? ...

How can I suppress blank pages in SQL Reports?

I have a SQL Report that insists on printing an extra blank page at the end, even though all the report items should fit on one page. I tried shortening the elements on the page that is spilling over, but no matter how much I compress them, or how much blank space is left on the first page, SRS still thinks it needs to take up another p...

Upgrade to Birt 2.3.1 and log SEVERE: Not allowed choice any

After an upgrade to BIRT 2.3.1 have a tons of logs: org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml SEVERE: Not allowed choice any Any thoughts how to rid of them will be appreciated. ...

Access Report PageHeader not with GroupHeader

I'm stuck with the following: I have an Access2003 report "rptInvoices". Group levels are on CustomerID and PackingListID. What I like to achieve is that every 2nd (or 3rd etc.) page of an invoice starts with a blank section (of say 9cm) at the top of the page. For this I would use an empty PageHeader section. If the Report's property...

asp.net - Generate Powerpoint file on the fly

I have a client of my web based application who heavily uses the data from our system for powerpoint presentations. We currently allow data to export in more traditional file types...PDF, CSV, HTML, and a few others. Powerpoint doesn't seem to be really automated. Is there a way, on the ASP.NET server side, to automate the creation an...

Getting Hourly statistics using SQL

We have a table, name 'employeeReg' with fields employeeNo | employeeName | Registered_on Here *Registered_on* is a timestamp. We require an hourly pattern of registrations, over a period of days. eg. 01 Jan 08 : 12 - 01 PM : 1592 registrations 01 Jan 08 : 01 - 02 PM : 1020 registrations Can someone please suggest a query ...

How to set Line or Box in front of the image

I've insert image in crystal report by following step, In the Section Expert for the section containing the image, check Underlay Following Sections. but, when some line or box created, the image still in front of them. i can't set Line or Box in front of the image ...

How to get the DateTime difference in Crystal Report

Hi, How can I get the DateTime difference between 2 DateTime fields in Crystal Report? I tried using DateDiff with not much luck, Any help/hint will be appreciated. Thanks, ...