• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.

Excel Add-in or Excel Reporting Engine?

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    #11
    Dim, that's the sensible approach.

    What is required here is a "Component Source" approach i.e. a long search into some obscure .net component that almosts does what you want but if you knew what you were doing in the first place you could actually write a component that could do exactly what you want to do in the first place in half the time.

    However, you must apply the contractor/hourly invoice rule here for full effect.

    Comment


      #12
      Re: SKA

      Dim. Spot on.

      Problem is, you are talking about using DTS. Users have no idea of this concept. I need a product that provides to be the benefits of using Crystal Reports, in Excel, with a Scheduler which does event handling and parameters.

      Try finding a "Good" scheduler for Crystal which does all this and you're talking oodles of cash.

      And the problem is, every client hates the way Crystal Schedulers send one report after another unless you build way complex sub reports.

      I wrote one recently which had the functionality for crystal but it has licensing issues.

      Comment


        #13
        Re: SKA

        Oh! and I dont want ridiculous overheads like .NET.

        Plus, I want it easy and quick to use.

        Plus, cheap.

        and I dont want to have to write it from scratch.

        8o

        Comment


          #14
          desires

          Would you also like it to polish your boots and start up your car on cold mornings as well? :rolleyes

          C'mon people, where is your famed CUK solidarity -- lets all bash MF >:

          Comment


            #15
            Re: SKA

            Problem is, you are talking about using DTS. Users have no idea of this concept.
            Users don't need to know. They just see raw tabulated data in base sheets and have no idea how it magically keeps fresh.

            A decent contractor can write all the SQL and DTS jobs in such a way as to produce 100's of different raw data sheets. Products by month, Sales by region etc etc and end users create their reports without ever knowing anything about DTS.

            The data sheets are denormalised extracts for the database data for reporting.

            If you want to go down some heath robinson nightmare with custom schedulars and a bit of script and some dot net a few com components and blah....you're more than welcome...

            Comment


              #16
              Re: desires

              I hadnt really noticed before ATW, the similarity between you and that Craig bloke in Big Brother.

              He's forever bitching at the people he shares the house with but then is always seen stroking their feet or hair or massaging them.

              Just noticed a little similarity thats all.

              Comment


                #17
                Re: SKA

                Plus, I want it easy and quick to use.

                Plus, cheap.

                and I dont want to have to write it from scratch.<!--EZCODE QUOTE START--><blockquote><strong><em>Quote:</em></strong><hr>

                The get some poor @#%$ Indian bloke to write it for you!

                FFS, there's no all singing all dancing reporting solution that numpty's can use that cost
                <hr></blockquote><!--EZCODE QUOTE END-->

                Comment


                  #18
                  Re: desires

                  Dim. Like a DBA friend of mine you are missing the point.

                  What happens if

                  a) You do not have SQL Server and hence DTS
                  b) You do not have direct access to the Server(Ie ODBC connections)
                  c) You know piss all about SQL or you are the user
                  d) You cannot even license any software.

                  I have had to provide my own copies of software. I need to hand something over to people who basically have less of a clue than Tony Blair. They make Milan look like a genius and ATW a god.

                  Dont think techie, think management.

                  Comment


                    #19
                    Re: desires

                    "The get some poor @#%$ Indian bloke to write it for you!"

                    :rollin

                    Nice

                    It's Logica.

                    :rollin

                    Comment


                      #20
                      Re: desires

                      C'mon Monkey Trading, InfoScheduler, you know it makes sense.

                      BTW, there is a new marketed whisky called Monkey Shoulder that is supposed to be a bit pissy but aimed at limp wristed 20 somethings - perhaps that's a new avenue to explore MF?

                      Also, do you still have your store at Bracknell - that's really close to one of my clients... is it near J&J offices?

                      Comment

                      Working...
                      X