I have a datagrid getting bound to a dataset, and I want to display the average result in the footer for a column populated with integers. The way I figure, there's 2 ways I can think of: 1."Use the Source, Luke" In the code where I'm calling DataGrid.DataBind(), use the DataTable.Compute() method (or in my case DataSet.DataTable(0).Co...
What are the best open source (open source and commercial) reporting tools for ASP.NET similar to Crystal Reports for ASP.NET? ...
I am about to migrate a bunch of seriously over-complex Reports (MS SQL report server over some horrible stored procedures) to something more BI based. I was wondering if anybody had any pointers, gotchas, or general advice on the best way to do this. Thanks. ...
I want to set all the fields and labels on a VFP7 report to "Float" and "Stretch with overflow". I tried USEing the .frx file and doing the following REPLACE but it didn't work. Is there some other field I need to change too? REPLACE float WITH .T. FOR objtype = 8 ...
I have a .NET web app that uses CR 2008 for reports. The server it's deployed on is saddled with McAfee, and we want to tell CR to use a temp directory other than the Windows temp dir. Google found me the following registry key: SOFTWARE\Business Objects\Suite 12.0\Report Application Server\InprocServer\TempDir. Adding this key does ...
Out of the box SSRS reports cannot have data exposed in the page header. Is there a way to get this data to show? ...
How do I use Perl to create graphs? I'm running scheduled job that creates text reports. I'd like to move this to the next step (for the management) and also create some graphs that go along with this. Is this possible / feasible? It'd be great if I could do this using Office some how. update: solutions i'm going to investigate in ...
Is it possible to hide or exclude certain data from a report if it's being rendered in a particular format (csv, xml, excel, pdf, html). The problem is that I want hyperlinks to other reports to not be rendered when the report is generated in Excel format - but they should be there when the report is rendered in HTML format. ...
Is there any designer for rdl files (visual studio .net reports) that can be used on a web browser? ...
Users of my web app need to edit and "save as" their reports and then execute and export them to PDF or Excel files. I need to know if there is a designer (web) for simple reports (open source would be better). Reports are not complex: just data fields, master-detail, labels, simple formulas, lines, static images... Is there any? (too m...
Whats the best way to bind variable column names to a report field in Access when using a crosstab query? ...
What is the best practice for naming UI controls (textboxes, drop-downs, etc.) on forms and reports for reference in the code-behind pages? I develop a lot of reports and forms in my office. I have several web applications providing about 80+ "live" reports being generated from various and multiple data sources (Access, SQL, Oracle). ...
This question was very helpful, however I have a list control in my report, and when the report grows over 1 page - data in the header only shows up on the last page of the report. Apparently, hidden textboxes have to be on every page of the report for header to function properly, how do i do that? The only control i have in the list is...
I want to specify a small row height in a Reporting Services report of about 3pt. However, while the report looks ok in the previewer, once deployed, the row height resets to the standard row height. I've tried adjusting the "CanGrow" and "CanShrink" settings as well as playing around with the padding, lineHeight, font size, etc... An...
I'm using the Crystal Reports included with VisualStudio 2005. I would like to change the image that is displayed on the report at runtime ideally by building a path to the image file and then have that image displayed on the report. Has anyone been able to accomplish this with this version of Crystal Reports? ...
How would you go about producing reports by user selected date ranges in a rails app? What are the best date range pickers? edit in response to patrick : I am looking for a bit of both widget and active record advice but what I am really curious about is how to restfully display a date ranged list based on user selected dates. ...
We have a Cash flow report which is basically in this structure: Date |Credit|Debit|balance| 09/29| 20 | 10 | 10 | 09/30| 0 | 10 | 0 | The main problem is the balance, and as we are using a DataSet for the Data, it's kinda hard to calculate the balance on the DataSet, because we always need the balance from the previous ...
I am attempting to save an rtf file using FileDialog and would like to filter using a where clause. This is what I have: Set dlgSave = FileDialog(msoFileDialogSaveAs) With dlgSave .Title = "Provide the place to save this file" .ButtonName = "Save As..." .InitialFileName = Me.cmbPickAReportToPrint.Value & "-" & Format(Date, "mmddyy...
I'm writing a Winforms application and I've been writing these awful HTML reports where I have templates set up and use String.Replace to get my variables into the templates, then output the results to a WebBrowser control. I really don't like this set up. I'd love to be able to use ASP.NET for my reports, but my clients don't want t...
I was wondering if it is possible to not attach Excel sheet if it is empty, and maybe write a different comment in the email if empty. When I go to report delivery options, there's no such configuration. Edit: I'm running SQL Server Reporting Services 2005. Some possible workarounds as mentioned below: MSDN: Reporting Services Extens...