Our centralized IT department has suggested two primary ad hoc query tools for our general user base of approximately 200 staff members: Microsoft SQL Server Management Studio 2008 (SSMS) Microsoft Access 2003 Environment The backend database is a read-only Microsoft SQL Server 2005 database. The schema is 400+ tables; allowing a...
I created a podcast, and set it up in itunes. I am able to track the number of downloads for the media files, and I would like to know how many different users are downloading the files. I tried using cookies / sessions, but that doesn't seem to work. Itunes ignores cookies, and thus a new session id is created every download. Is t...
User table contains the following attributes (dateOfBirth, race, gender, ...). We would like to generate a report in the following format. Year Race All Male Female 2000 Asian 2000 1000 1000 2000 Hispanic 1000 500 500 2001 Asian 1500 700 800 2001 Hispanic 1300 400 900 ... Total 5800 2600 3200 Ideally I would like to...
Hello, we are wanting for users to be able to write their own reports in our application. It is a web application. We don't care if they must download an application in order to create reports, but we need for them to be able to print off reports from the web in PDF format or similar. The report writer is to be used by non-programmers,...
We wish to expose some of the application data (in MSSQL Server) to external users so that they can consume it in their OWN reporting environment. Which would be the better options in terms of usability, ease of report creation, security or performance if the external users wish to do reporting in SSRS or Crystal reports: Exposing da...
I’ve been asked to list all the names and version numbers of all the services, executables and dlls that make up my project. We need to keep a record of this for each release. Is there a tool in Visual Studio that will generate a report or log automatically ? If not, does anyone have a possible solution ? ...
My client has an Access (2000) application that we didn't write and we don't have access to the MDB (it's an MDE). One of the functions is to create a packing slip report. There's no option to preview, only print or save to file. There's a field that represents a weight; it's a Double field. On a standalone machine, it prints correctly...
For everyone playing with SQL Azure, what are you using for reporting? Do the Visual Studio reports connect seamlessly? What about reporting services? ...
How do you minimize the pain in your development process when it comes to reporting? For web frameworks, there is a pretty straightforward way to both produce content as well as graphically design it; content is represented semantically through HTML, and the design is separately specified through CSS. And browsers are fairly consistent...
I'm looking for some cost-effective solutions and/or open source options for generating reports in Excel and PDF format. I realize some of the open source options may have less in terms of functionality and flexibility than the COTS versions with all the bells and whistles, but are there any options out there that fall somewhere in betw...
How can you programmatically set the parameters for a subreport? ...
I was wondering if someone had a suggestion on how to best do composite reporting. I have tried to accomplish this with Crystal Reports [CR] (The one that comes with VS2k8) but for a codemonkey like me, it's hard to grasp the design part... I have found that CR works nicely for reporting on tabular and repeatable data, but I can't grasp...
Dear all, I have to make a SSRS rdlc report which displays a list of data in a free form. I'm using the list control for reporting services to achieve that. Tha final puspose of this report is to be exported to PDF. My list items have a variable height, based on the content. The problem is that when I export to PDF, the renderer tries...
I'm using VS 2008 to generate a Reporting Services report definition. The problem is that whenever I try to load a report definition from a stream I get an error. I have the following code: var loaded = XDocument.Load(filePath); LocalReport ret = new LocalReport(); using (var stream = new MemoryStream()) { var writer = new StreamWr...
I have a question for those of you doing web work with python. Is anyone familiar with a python based reporting tool? I am about to start on a pretty big web app and will need the ability to do some end user reporting (invoices, revenue reports, etc). It can be an existing django app or anything python based so I can hook into it. Thank...
I have a pie chart in BIRT and about 80 data points. I'm looking to group them in three catagories <17 17-20 and >20. To be more specific I'm trying to make a red yellow green chart. How can I do this. I tried the grouping function, but it only allows even intervals that I can find. Thanks, Buzkie ...
I have no background in reporting tools. I'd like to generate some statistical tables and plots. Is VSTO(Visual Studio Tools for Office) good enough for this task? What's the main difference VSTO tool chains and other reporting tools, like crystal-reporting. ...
So I've recently had to create a report that emulates a Canadian customs form. The problem is that the report is printed on 11" x 14" paper, but uses a metric layout. As my FoxPro installation is on a machine with US-English units-of-measure, FoxPro tries to oblige by using an English ruler, and doing snap-to-grid on inch-based measure...
Hi All, My Client has requested that i email him reports daily and that they are password protected. Before I write a service to do this, I was wondering if there is not a better alternative. The data is stored in an SQL 2005 database with DB mail setup and running. We are also using reporting services. The option he has given me ar...