What is the best way to re-use reports on different tables / datasets? I have a number of reports built in BIRT, which get their data from a flat (un-normalized) MySQL table, the data which in turn has been imported from an excel sheet. In BIRT, I've constructed my query like this, such that I can change the field names and re-use the ...
Are there any other ReportViewer designer beside the Visual Studio (with GUI of course I know that any XML/TEXT editor can change definition of .rdlc file) ? One day when I finish my rich (fat) client application at all, Ill love to try embed in report designer, so end users can do cosmetics modification of theirs report files without ha...
I've been working with David Poll's CollectionPrinter Control and have successfully printed reports which use a DataGrid to display the collection. Without using grouping in the datagrid it paginates the document normally. However, as soon as I activate grouping following his instructions in one of the first comments from the link above,...
Suppose I have three tables: user, group and xref, a table that gives them many-to-many RI. I might want to see how groups each user belongs to: select user.user_id, user.user_name, count(*) as group_count from user inner join xref on user.user_id = xref.user_id inner join group on group.group_id = xref....
We're using a "1 audit table for each monitored Table"; However, in our case emp(PARENT) table has a child table emp_address which also needs to be monitored, so we have emp_audit and emp_address_audit tables. postgres audit SQL : how to join PARENT and CHILD tables for reporting purposes. /* Employee table */ create table emp ( ...
I am soliciting for suggestions on reporting solutions We develop a lot of in house projects(.net and sql server). For larger database we use business objects and build universes for reporting so that analysts or report writers can build reports and developers dont need to be involved. Many of our projects house important data, but ar...
Hi All, I am trying to print a report from Reporting Services, the approach I am taking is: Render the report to get the Byte[] Create a file in the client (Something.pdf) Load that file in Read Mode to a FileStream Then I try to make a call to the procedures described in http://support.microsoft.com/kb/322091/en-us If you in method S...
Any suggestions on books that might focus on developing SQL queries for reports? Just to clarify, I am not looking for books covering SQL Server Reporting Services, but rather books that might cover writing SQL queries to serve as the basis for reports. Thank you. EDIT I just want to further clarify I am quite familiar with SQL syntax. ...
I have a report that I would like to base on a single SQL statement. The problem is the data is based on several SQL statements. For example. SELECT COUNT(*) as 'Cases Opened' FROM tblCases WHERE DateAssigned BETWEEN @StartDate AND @EndDate SELECT COUNT(*) as 'Cases Closed' FROM tblCases WHERE ClosedDate BETWEEN @StartDate AND @End...
Right now i am using two rdlc file to achieve. except for the field gender and field age , rest are the same. these are the two queries i use. query 1 :select state,gender,count(*) from table query 2 :select state,age,count(*) from table how do i dynamically set the column frm the dataset to achieve in a single rdlc file. do i need ...
Please suggest me good and free reporting tools which works with CVS in Windows environment? The purpose of the reporting is to get the most detailed information from a CVS repository, including committing activity on a per user basis. ...
I'm trying to integrate LimeSurvey (a PHP web application to develop and collect responses to online surveys) with Pentaho (ETL, business intelligence, reporting, etc.), but I'm facing some serious problems. LimeSurvey automatically generates a new table for storing the answers of each survey created within my application, and I need to...
Hi, I'm using SSRS 2008, I'm building big reports and I use subreports, I need to give a formula by paramaters to a report. How can I do it ? I though about doing reflection on the parameters in order to use it like a formula. Do you have any ideas if it'll work ? Regards, ps : sorry for my bad english. ...
Hi All, We are currently having an OLTP sql server 2005 database for our project. We are planning to build a separate reporting database(de-normalized) so that we can take the load off from our OLTP DB. I'm not quite sure which is the best approach to sync these databases. We are not looking for a real-time system though. Is SSIS a good...
I have been reporting with jasperreports and JPA, all this reports are just "catalogs" in which the only information is an entity or some times an entity with it's related entities. Now i have to design reports with very complex information (grouping, summarization, fields not part of an entity and so on) which is not possible with my e...
I'm improving a software written in .net (3.5) and have decided to change its reports engine from crystal reports to something else. (not very user friendly and buggy IMO. also deep learning curve) The project is a winforms project. The most important thing that I want from the new engine: Support right to left layout. (when using mu...
I have a spreadsheet corresponding to entries of a user, their estimation, and the actual value (say, of hours for a particular project), which we can represent in CSV like: User,Estimate,Actual "User 1",5,5 "User 1",7,7 "User 2",3,3 "User 2",9,8 "User 3",6,7 "User 3",8,7 I'm trying to build a report on these users, to quickly see whi...
MySQL Workbench reports a value called "Key Efficiency" in association with server health. What does this mean and what are its implications? From MySQL.com, "Key Efficiency" is: ...an indication of the number of key_read_requests that resulted in actual key_reads. Ok, so what does that mean. What does it tell me about how I'm 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 an Access 2003 MDB where I would like to present a small form for the user to input two parameters "Start Date" and "End Date". Thanks to another Stack Overflow user ("Kevin Ross"), I learned how to embed the form control directly in the query that is used by the report I would like to display. SELECT q1.CasesAssigned, q2.Warning...