reports

Access: How to pass parameters to report when WHERE clause is embedded in complex SQL

I know the question of how to pass parameters has been asked a while back with the this Previous Stack Overflow question However my situation involves SQL that is a bit more complex and cannot make use of the "where clause" filter available when opening a report. My SQL statement is an aggregate that produces a single row with one field...

SQL report with Matrix which grows horizontal, need to break to next line instaed of moving to the next page.

I have a Sqlreport (SSRS 2005) which is using a Matrix, to print pivot table format data. and prints horizontically.Thats fine but it does not break to the next line of the same page, instead move to the next page and grows horizonticaly on the next page. I dont want to go another page instaed need to go to the next line. Please help m...

RDLC vs Crystal Reports vs Anything Else Free: I'm running Informix and using C# 4.0

I'm not sure which is the way to go for choosing a report type with my current setup. In the past I was using MS Server 2008 R2, MS SQL Server, MS.NET C# 3.5. Now I'm using something similar except my Database is IBM Informix and I'm using MS.NET C# 4.0. I'd prefer to use RDLCs since I'm used to them, but I didn't wanna jump down that a...

How to display grid of data in crystal reports

I am having issues with Crystal Reports for Visual Studio 2008. I am tasked with creating a report that displays data in a grid, from testing scores.. I would like the data to be displayed like the following Results for Exam <Exam Title> <Question Name 1><Question Name 2><Question Name 3><...> <Candidate 1> <Score> ...

Automating Report Writing with Microsoft Office

I write compliance reports for work. I fill in a PDF form and click 'Yes' or 'No' to indicate whether the company is in compliance with a particular statute. I would like to have this form autopopulate my compliance report in Word with the company's name and the appropriate findings and corrective actions. Is this possible? If not, can...

Crystal Reports Question

//Using Small Business Code from PO Record in Subreport Accumulate Associated $ numbervar BC1; WhilePrintingRecords; shared stringvar BC; // added following 2 statements to prevent doubling value on last record 10/23/06 (WET) if shared stringvar BC = " BC1" and not onlastrecord then BC1 := BC1+{@PTEXT$}; if shared stringvar BC = " BC...

Crystal Reports Change database connection dynamically (c#) - Missing parameter values

Hi there! I will put the sofware used first, just in case it helps a bit: Microsoft Visual Studio 2005. ,Microsoft Crystal Reports(year 2005), Crystal reports view as pdf from an webapplication (c#). I have a crystal report document, created by the Crystal Reports IDE which has 2 parameters and setting them in preview mode work. I clo...

Error with generating JasperPrint in the client side

I am using JNLP which fetches my jar files to client. When I run the application, I am getting error with generating JasperPrint(NullPointerException). I can figure out the cause partially. It is because JasperPrint instance cannot be stored on client side due to access permission. Is there a way to generate JasperPrint on client side. ...

How do Microsoft reports (RDL) query the data?

I am not creating RDL from scratch so maybe this is a problem -- I work on already prepared files. MSDN states that CommandText in RDL file can contain T-SQL query. Ok, this I understand, but what else it can contains? I am asking because the phrasing clearly indicates you can put some other expression there So if I understand correct...

Report creating problem

Hi stackoverflow comunity. I'm using report builder 3.0 and i need to put two textboxes in the same line in table cell, but the problem is when there is too much text in textbox1 it grows in height, but i need i widht. You can say that i can use placeholder to do the trick, but I can't use placeholder to hold the text of textbox2 in firs...

winform report populate only textboxes

Hi Everyone- I am trying to recreate a current MS Access report in a new Winforms application. I am using the Microsoft Report functionality in Visual Studio. The report is really basic. It really is just a fax coversheet with data about one record in a table of data. So all I need to do it populate textboxes on the report with the...

averaging event values associated with date values by hour, day, etc..

I have a bunch of events with values (how many people went through a doorway). Each event is associated with a Date. There is no fixed period to the events .If no one comes through the door, no event is generated, but often multiple people can go through at once, so the value can be greater than one. Sometimes events are minutes apart f...

How To Generate a HTML Report From A String Of URLs

In my program I have a string which contains URLs separated by /n (One per line) Let's say the string is called "links". I want to take this string and generate a HTML file that will automatically open in my default browser which will make each URL a hyperlink (one per line). How would I make such a report not using any third party comp...