Prev: Need Help Using A Custom Session Manager
Next: Object reference not set for an instance of an object in a .ASCX f
From: JimLad on 1 Apr 2010 05:58 Hi, We have a requirement to allow users to design and run their own reports (for data they have access to). It is not clear whether we need to integrate this with our app or whether we can use a stand alone app. I'm imagining we would set up some denormalised views or something like that, but we also have a requirement for security on a client by client basis (each table contains data for multiple clients). I imagine they would build reports by combining one or more denormalised views and dragging and dropping column names and aggregates. My question is - can you do this sort of things using Crystal Reports for .NET and how complicated is it? Or can we use a separate reporting app? Do we need a full version of crystal reports or something else? Can anyone point me on the right road here? I would be very happy with an out of the box solution that just need a bit of config. Links to articles would be good too. Wish I hadn't turned down that Business Objects course 5 years ago! Cheers, James
From: Andy O'Neill on 1 Apr 2010 09:00 "JimLad" <jamesdbirch(a)yahoo.co.uk> wrote in message news:06745fb0-fb08-407e-a85c-c927d0ce6f73(a)h27g2000yqm.googlegroups.com... > Hi, > > We have a requirement to allow users to design and run their own > reports (for data they have access to). It is not clear whether we > need to integrate this with our app or whether we can use a stand > alone app. I'm imagining we would set up some denormalised views or > something like that, but we also have a requirement for security on a > client by client basis (each table contains data for multiple > clients). I imagine they would build reports by combining one or more > denormalised views and dragging and dropping column names and > aggregates. > > My question is - can you do this sort of things using Crystal Reports > for .NET and how complicated is it? Or can we use a separate reporting > app? Do we need a full version of crystal reports or something else? > Can anyone point me on the right road here? I would be very happy with > an out of the box solution that just need a bit of config. > > Links to articles would be good too. Wish I hadn't turned down that > Business Objects course 5 years ago! > > Cheers, > > James I've seen crystal reports rolled out to power users on several occasions. It never worked very well. Users just don't "get" reporting in that way. Business objects is rather more friendly but people still struggle. I've used Access with some power users. Connected to a sql server back end reporting database structured in a user friendly manner. Another option is excel output. You can give them a screen allows selecting columns or just spit the lot out via xslt. Most power users know excel and are inordinately keen on excel output.
From: JimLad on 1 Apr 2010 10:40 On 1 Apr, 14:00, "Andy O'Neill" <aon14nocannedm...(a)lycos.co.uk> wrote: > "JimLad" <jamesdbi...(a)yahoo.co.uk> wrote in message > > news:06745fb0-fb08-407e-a85c-c927d0ce6f73(a)h27g2000yqm.googlegroups.com... > > > > > > > Hi, > > > We have a requirement to allow users to design and run their own > > reports (for data they have access to). It is not clear whether we > > need to integrate this with our app or whether we can use a stand > > alone app. I'm imagining we would set up some denormalised views or > > something like that, but we also have a requirement for security on a > > client by client basis (each table contains data for multiple > > clients). I imagine they would build reports by combining one or more > > denormalised views and dragging and dropping column names and > > aggregates. > > > My question is - can you do this sort of things using Crystal Reports > > for .NET and how complicated is it? Or can we use a separate reporting > > app? Do we need a full version of crystal reports or something else? > > Can anyone point me on the right road here? I would be very happy with > > an out of the box solution that just need a bit of config. > > > Links to articles would be good too. Wish I hadn't turned down that > > Business Objects course 5 years ago! > > > Cheers, > > > James > > I've seen crystal reports rolled out to power users on several occasions. > It never worked very well. > Users just don't "get" reporting in that way. > > Business objects is rather more friendly but people still struggle. > > I've used Access with some power users. > Connected to a sql server back end reporting database structured in a user > friendly manner. > > Another option is excel output. > You can give them a screen allows selecting columns or just spit the lot out > via xslt. > Most power users know excel and are inordinately keen on excel output.- Hide quoted text - > > - Show quoted text - Hi Andy, Thanks for that. We have about 500 parameterised custom reports on the system already that cover most scenarios, and our current customers like them a lot. Where that isn't sufficient, we have a denormalised data export to Access. But it seems when we tender to clients, the managers want a more flexible reporting system. Crystal report was owned by business objects which has now been bought by SAP. Is Business Objects still a separate app to Crystal Reports? I remember way back in the mists of time there was a product that used Universes and users could build their own reports within those universes. Can't remember what it was though. James
From: Andy O'Neill on 1 Apr 2010 11:18 "JimLad" <jamesdbirch(a)yahoo.co.uk> wrote in message news:cff98bae-7b2d-46f3-ae80-74a3d516b258(a)z11g2000yqz.googlegroups.com... > On 1 Apr, 14:00, "Andy O'Neill" <aon14nocannedm...(a)lycos.co.uk> wrote: >> "JimLad" <jamesdbi...(a)yahoo.co.uk> wrote in message >> >> news:06745fb0-fb08-407e-a85c-c927d0ce6f73(a)h27g2000yqm.googlegroups.com... >> > We have a requirement to allow users to design and run their own >> > reports (for data they have access to). It is not clear whether we >> > need to integrate this with our app or whether we can use a stand >> > alone app. I'm imagining we would set up some denormalised views or <<>> > Hi Andy, > > Thanks for that. > > We have about 500 parameterised custom reports on the system already > that cover most scenarios, and our current customers like them a lot. > Where that isn't sufficient, we have a denormalised data export to > Access. But it seems when we tender to clients, the managers want a > more flexible reporting system. Crystal report was owned by business > objects which has now been bought by SAP. Is Business Objects still a > separate app to Crystal Reports? I remember way back in the mists of > time there was a product that used Universes and users could build > their own reports within those universes. Can't remember what it was > though. > > James > Business objects is a totally different product and I think still available as SAP Business Objects. Management always want more reports. Means they can put off decisions until they get them. I suppose your export to excel must be somewhat limited - because access reporting is very flexible and very good. Maybe the first thing to consider is exporting more data. Is your database sql server? Have you considered sql server reportbuilder?
From: JimLad on 1 Apr 2010 11:46
On 1 Apr, 16:18, "Andy O'Neill" <aon14nocannedm...(a)lycos.co.uk> wrote: > "JimLad" <jamesdbi...(a)yahoo.co.uk> wrote in message > > news:cff98bae-7b2d-46f3-ae80-74a3d516b258(a)z11g2000yqz.googlegroups.com... > > > > > On 1 Apr, 14:00, "Andy O'Neill" <aon14nocannedm...(a)lycos.co.uk> wrote: > >> "JimLad" <jamesdbi...(a)yahoo.co.uk> wrote in message > > >>news:06745fb0-fb08-407e-a85c-c927d0ce6f73(a)h27g2000yqm.googlegroups.com... > >> > We have a requirement to allow users to design and run their own > >> > reports (for data they have access to). It is not clear whether we > >> > need to integrate this with our app or whether we can use a stand > >> > alone app. I'm imagining we would set up some denormalised views or > <<>> > > Hi Andy, > > > Thanks for that. > > > We have about 500 parameterised custom reports on the system already > > that cover most scenarios, and our current customers like them a lot. > > Where that isn't sufficient, we have a denormalised data export to > > Access. But it seems when we tender to clients, the managers want a > > more flexible reporting system. Crystal report was owned by business > > objects which has now been bought by SAP. Is Business Objects still a > > separate app to Crystal Reports? I remember way back in the mists of > > time there was a product that used Universes and users could build > > their own reports within those universes. Can't remember what it was > > though. > > > James > > Business objects is a totally different product and I think still available > as SAP Business Objects. > > Management always want more reports. > Means they can put off decisions until they get them. > > I suppose your export to excel must be somewhat limited - because access > reporting is very flexible and very good. > Maybe the first thing to consider is exporting more data. > > Is your database sql server? > Have you considered sql server reportbuilder?- Hide quoted text - > > - Show quoted text - Yep, SQL Server based. 2000 at the mo, but 2005 by end of year (they told me this when I joined 5 years ago!). I was once a SQL expert... :- ( Reportbuilder sounds good. I will investigate. Once reports are built, can they be shared? Many thanks, James |