August 26, 2003 at 2:10 am
Hi there
Does anybody has any experience using Lockwood SQL Web reports.Is it any good ? What skills do u need.
And I need to create lots of reporting in excel from sql data. Now I'm creating SQL views, connection through external data etc.
Is this the best way to do ? I would like to let users define some parameters.
What MS training is the best ?
thx
J
JV
JV
August 26, 2003 at 5:26 am
I keep meaning to try the product, keep getting sidetracked. Lockwood advertises with us, so all things being equal, give them bonus points for that!
Reporting is hard. You can use something like Lockwoods product, or Crystal Reports, build your own in asp/asp.net, or buy a higher end product - Business Objects, Cognos (we just bought this where I work), etc.
For training, if you buy a (higher priced) product, then you could look to the vendor for training. If you want to build your own, then you're really looking for more of a web/sql class.
Andy
August 27, 2003 at 2:10 am
Hello,
just for what it is worth: I have been developing a reporting component for our e-recruitment application lately ... It still is alpha code, but I got a reasonable proof of concept in about 5 days, including building all the queries ...
I have been using:
- sp's with generic parameters (like @actionkey, @actionvalue) to bundle similiar reports into one sp
- aspgrid on asp to display the resulting recordsets (sortable columns and paging and all), using an XML definition per report
- some spacy asp code to have the html-tables written to XLS with a filter in it, + users can also d/l the reports
Kind regards,
nofuss
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply