VB .Net & Excel Reporting -
I have created some Excel templates and an EXE that opens them, get data from a DB, writes it and saves it. It works great on my machine because Excel is installed on it.
I need to move the code to a production server where excel is not running, what are my options? I am making use of the Excel Object Library currently but that can change if need be. I cannot install excel on the server and it would be ideal for no need to install anything on the server.
If anyone has any ideas, please let me know.
Regards,
Michael Wheeler
VB Reporting - Which is best -
Hey everybody,
I'm using VB for a new project i'm doing and want to know from other peoples experience which reporting tool is best.
I have used Excel as a reporting tool before and liked it because it gave me full control ovr what information was being displayed in the report at
RESOLVED: Turn of Excel Error Reporting -
Hey,
Basically all i'm doing is automating Excel to open a Lotus 1-2-3 file and then manipulating it.....
I have no problems with the manipulation of the file.
However when i open the lotus 1-2-3 file ONE cell cannot be READ and hence an error message pops up informing the use
Reporting for company -
What products does your company use for intranet reporting and development.
Currently we are reporting off our mainframe system into Access and out to Excel.
We want to make all of your reports more dynamic through the use of an intranet site.
I'm looking at DreamWeaver 4
reporting in excel -
well, my last post/question fizzled out miserably. so now i am focusing on useing excel as the reporting tool. i have a couple of questions(again).
first one, how do i change the print layout to landscape?
second one, the more important and complicated one....
file->page setu
Issue with VB6 app that late-binds to Excel running on Vista 64-bit -
Hello,
I've got an app that was developed in VB6 and late-binds to Excel. This app, developed last year, was tested on both XP and Vista, and with Excel XP(2002), 2003, and 2007. Although my preference is XP Pro for the OS and Excel 2003, I did test the app on machine running Vista
Need Help Working with Microsoft Excel 2000 in ASP.NEt -
I am designing a reporting web site using ASP.NET and need to be able to pass the data from an SQL Query to Microsoft Excel. I don't want Excel to look as if it is a seperate application, but to use it within the page and talk to it using ASP.NET.
I am pretty sure I have seen web s
VB .Net & Excel Reporting -
I have created some Excel templates and an EXE that opens them, get data from a DB, writes it and saves it. It works great on my machine because Excel is installed on it.
I need to move the code to a production server where excel is not running, what are my options? I am making us
Different Versions of Excel -
A few years ago, I came up with an ingenious solution to the problem of cross-tabulated reporting within Microsoft Access 97. As most of you will be aware, the cross-tab reporting function in Access 97 is fine, but if the number of columns increases by itself, you're left with unforma
Ad-Hoc Reporting -
Everyone :
For the project I'm working on the client wants to add ad-hoc reporting for users. It needs a web (.ASP/.html) front-end using SQL Server 2000 for the back-end.
Does anyone have any good suggestions for ad0hoc reporting tools?
Thanks,
Dale Williams
[2003]Best ways with reporting -
Now I'm going to start reporting on my application. But I don't know how to proceed. Can anybody tell me,
1)what are the steps, which I should follow?
2)What are the references, components which I should make before start reporting.
3.)How could I edit the report?
need sugestion please -
Dear Friend,
i need to use reporting. but i dont want to use crystal reporsts.so is there any reporting other than crystal reports in vb.net .if means please help to use the reporting.
ASP TO EXCEL + Worksheets! -
Hi,
I know this topic has been beat to death
I want to take my existing reporting (asp to excel) and start adding multiple worksheets to it.
What I need to do is to run multiple querys and display each on their own worksheet and then summarize everything on its one page, and I w
SQL Reporting Services VS Crystal Reports 11 -
Hello,
I am about to start a new project with lots of reporting that will be needed. The frontend of the project is in VB 6.0 and the backend is MS SQL Server 2000. I am new to both reporting programs and am wondering what would be the best to get use to as far as designing and deploy
Design VB.NET -
I am curious what kind of different approach I'm going to use to program my database applications with VB.NET 2005. I'm new to .NET but pretty familiar with VB6.
Are their any good articles about designing database applications in VB.NET?
I'm not familiar with reporting in Cryst
Reporting from a SQL Dbase, concept help. -
Hi,
I have developed a small app that saves info into a SQL database. Its actually a questionnaire type application where designated team leaders can create questionnaire records and assign participants, then the participants can drop onto the page and complete the questions, the ap
Form to SQL reporting services..how -
Hello,
I want to have a button on my form that will open my sql reporting service report. I have found a lot about using sql reporting services...but thats about it. Can someone explain how this is done or recommend a good site that has this info. I am programming in vb .net 2005
adding reporting services -
Can we add
Microsoft SQL Server reporting services to the list of reporting tools in the forums?
Many .net developers are turning to MS's solution rather than Crystal reports (yuck I hated crystal).
Jon
[2005] Reporting Control -
I was wondering if it would be worth while to have a reporting control that could contain several reports. Something like a mdi app (Word for ex.) hosting several reports (documents). Usually reporting apps or controls are single report based (when displaying) but to have a reporting c
SQL Server Reporting Services display problem -
A little experimenting with SQL Server and Reporting Services gave me the following observation:
If SQL Server and SQL Server Reporting services are on the same machine, where SQL Server SP4 and SQL Server Reporting Services SP1 have been installed, then CSS files are bunk. Nothing
Reporting Software Advice -
I was just wondering what type of reporting options there are for VB6. I'm currently using the downloadable Crystal Reports Designer Component (crap) and I'm looking to purchase a Reporting software package. Probably a full version of Crystal Reports.
Thanks,
Another link that won't work... -
I'm trying to get information on licensing for MS SQL Server Reporting services, but this page just won't open.
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
Anyone try it?
Data Exchange between Applications -
Hi,
I wrote a VBA marco for Outlook. The goal was to export my calendar items into an Excel Spreadsheet for weekly reporting. Everything went fine but I have one open issue. I used the CreateObject to open an Excel Application and used the function GetOpenFilename to browse for my
Include external code in Excel Macro script -
Hi,
I have made a large Macro for Excel for some reporting application.
I am loking for an Include statement to include an external *.bas file in the code.
The reason I want to do this is so the code in the excel file can include the remote file. Then when I need to update the sou
Avoiding Shared Instances of Excel -
I currently maintain a database front end in VB6 that utilizes Excel as a means of reporting. I send a SQL Server dataset to an Excel spreadsheet and call the MainMacro function of the workbook from the VB app to format the report. All of this works fine. However, once my macro starts
[02/03] ASP.NET Reporting Options... -
Hello All,
I have a question about reporting. I have a simple database application that needs to produce two reports. I have never used Crystal Reports before and would love an example, but am having a hard time finding a simple one. Are there any other options for reporting like
excel version -
ok my project is ready for deployment but there is a problem that i can already forsee.
i have a reporting tool that generates its reports in excel. but the computers that i have to deploy this app to has ranges of excels from 2000 to xp-2003.
will there be a problem, if any, whe
Reporting Services in SQL Server 2005 -
I have as specific format in XLS. Now, I want to build a report in same format using Reporting Services project. The format of the report is netiher tabular nor matrix. Its scattered across the sheet. Now when the user views the report in browser and saves it as an excel file, the file
best reporting method -
Hi,
I program in VB6 and have SQLServer. What is the best way for reporting? I have tried Crystal 8 but I hate it. Is there anything else available? something more user friendly?
Regards
Luis
Reporting in VB.Net -
Hi;
I use VB.Net express edition. I want to make reports. Do you know a freeware reporting tool or component?
I need it URGENT
Thanks for your help...
reporting controls -
Does anyone know of a free reporting control for vb?
Reporting services installation problems -
Reporting services installation problems
Hi guys,
Im trying to install SQL 2000 reporting services and im getting the message "Failure compiling WMI registration file"
How i can solve this problem?
Any ideas?
sqlserver/vb.net/reporting services - south wales area -
Hello,
Anyone want to earn some pocket money. Need to get up to speedin the
following areas:
VB NET
SQL Server 2000 + 2005 + reporting services
VBA Access Databases
XML
Need expereinced develeoper to provide one on tuition to enavbble me to be skilled enough to create data
ASP.NET sites with SQL Reporting Services Integration -
Hello, everyone,
I'm looking to integrate SQL Server 2005 Reporting Services reports into my ASP.NET 2.0 website. I've worked with both ASP.NET 2.0 and SQL Server 2005 Reporting Services both individually, but never integrated them together. Would someone be able to point me to so
use VB to show data from excel -
Hi all experts, I recently doing some excel reporting, wonder if i can import all the data using VB and shows some report using the VB as well,
I briefly created a interface,
i also tried the way that you all taught me by applying the data into my VB program.
my question is, ho
Reporting Tools Advice -
Can anyone suggest a good reporting tool? I don't require anything very fancy. I already know about SeaGate Crystal Reports, so information regarding any other products would be appreciated.
ta.
lenin.
Help with Error Reporting -
I am using Visual Basic .NET 2003 and have been working on my current project for a while. Lately I have run into a problem where instead of reporting errors Visual Basic will close the program and not give me any message of the error. This makes it very difficult to debug my program
Converting an app from Excel97 VBA to VB5/6 -
I've written a reporting package in VBA for Excel 97, and my boss is now getting on my case to get it converted to full VB (5 or 6 I should think). I think most of the conversion should be dead easy, but the reports concern me. Currently, I use blank single sheet Excel workbooks for ea
SQL Server 2005 Reporting Services -
Hey guys, I was wondering if anyone knew of any changes that will be made in the Yukon release of the SQL Server Reporting Services from the SQL Server 2000 Reporting Services.
I understand that it was developed for Yukon, but released for 2000 because of the delayed development of
Can pass values as parameters except for a string value Why Not -
Hi,
I am having difficulty trying to pass a string variable parameter to the reportviewer. See code below.... I can pass variables p and q just fine, but s gives me the error "Value of type 'Microsoft.Reporting.WinForms.ReportParameter' cannot be converted to type String&qu
dts on SQL Server 2000 -
Hello,
I have created a DTS Package on SQL 2000 that basically takes all of our reporting tables that I have created and places each one into a pre formatted excel template and just replaces the data each time it runs.
In the excel template I have pre formatted the columns to the