Welcome to the Lounge

Re: What is the status of report generation these days?

8-Jan-21 5:56

No, but I will. This weekend's project.

Thanks

Charlie Gilley
<italic>Stuck in a dysfunctional matrix from which I must escape...

"Where liberty dwells, there is my country." B. Franklin, 1783
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759

Member 139658668-Jan-21 0:17

Member 13965866

8-Jan-21 0:17

hi, I highly recommend you have a look at List & Label from combit (German company). It is a commercial tool and suits you needs from easy to use based on simply hooking (almost any!!!) a datasource to it until high end drill down reports as seen by commercial BI tools.

Customization options for end users are second to none. I love the tool and hate the companies restrictions in controlling their licenses. Don't get me wrong - I support regular license fees! But the way they limit and control it is a little bit to much for my understanding.

However, I am using it for nearly 15 years in a large number of commercial products. And each year they come up with a new version with valuable features.

best regards

Michael Lutz
M. A. Health Management

www.BITsoftNet.de

Re: What is the status of report generation these days?

charlieg8-Jan-21 5:21

Re: What is the status of report generation these days?

8-Jan-21 5:21

"hate the companies restrictions in controlling their licenses"

I understand that. The customer I am supporting must use software from a European company. The other customer again uses s/w from a European customer. Both of the companies' licensing process are a real PITA. Had one customer have all their servers stolen with the license USB dongle still in it. Company had to buy another full license. Real hard asses.

charlieg8-Jan-21 5:18

Re: What is the status of report generation these days?

8-Jan-21 5:18

This is why I love CodeProject. So many ideas and people willing to share them. Professionals all.

My contract company is very selective in how it spends s/w $$. If a manager hears "free", they are all in. Corporate wise, they are gung-ho for using Microsoft out the wazoo. I won't mention the time I asked for a Linux VM. Heads exploded, others turned 360 degrees, and objects started moving on their own. lol.

For the ad-hoc query case, Excel will work for me. For the production system I need to develop, the others are possible solutions.

Thanks again

Kirk 103898218-Jan-21 11:29

Kirk 10389821

8-Jan-21 11:29

Let me ask, what do the users want? Are they looking for the data, specific page layout, etc?

I've started delivering 2 types of reports. Grid Reports (Simply a dynamic grid result of a query you can manipulate and save to Excel), AND real Reports created with a designer (FastReports).

It depends on what they need, and how they intend to use them. The grid tools I have will do subtotals, and allow the users to dynamically group things, and apply their own additional filters.

The core concept is: Query + Bind Variables [Filters, etc] -> Results.
I like the "default" the bind variables with appropriate values, and therefore use a UNION of select "VarName","VarVal" expressions (select 'Year' as VarName, Year(now()) as VarVal) and then display that in an editable vertical grid for the user...

Then apply them to the base query. It lets me put all the report queries/params in the database, and makes it easy to add without updating the program...

Re: What is the status of report generation these days?

charlieg10-Jan-21 16:08

Re: What is the status of report generation these days?

10-Jan-21 16:08

fair question Smile | :)

. user group 1 does not know, they want to be able to do ad-hoc reports to see what they can do.

group 2 is a production group, they are easy. I need to replicate the reports they have now, and then we will see. The reports they have now are driven by flat files and FORTRAN. I kid you not.

bharathdjx089-Jan-21 0:57

bharathdjx08

9-Jan-21 0:57

I've used Microsoft RDLC Reports for quite some time. It comes with visual studio by default and has tons of features. No external dependencies needed for development and in deployment machines. We can do grouping, sorting, charts and connect to different databases like Sql Server and Oracle. I moved from crystal reports to RDLC eventually.

Bharath

Re: What is the status of report generation these days?

charlieg10-Jan-21 16:11

Doesn't anyone _read_ anymore?! :mad:

10-Jan-21 16:11

will check it out. Thanks

COVID: Real Articles

W∴ Balboos, GHB6-Jan-21 6:44

W∴ Balboos, GHB

6-Jan-21 6:44

Chemical & Engineering News[^] has allowed free access to it's COVID articles. Everyone can learn something.

Ravings en masse^
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

Re: COVID: Real Articles

Slacker0076-Jan-21 7:27

Slacker007

6-Jan-21 7:27

No thanks. I am currently maxed out on COVID.

When they say I can get my vaccine, I will get that and move on with my life. I will leave the bloody science to the professionals to worry about.

Re: COVID: Real Articles

Nelek6-Jan-21 7:30

Nelek

6-Jan-21 7:30

W∴ Balboos, GHB wrote:
Everyone can learn something.

That would imply they actually want to...

BTW thanks for the link. I am one of those who will have a look.

M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

Daniel Pfeffer6-Jan-21 5:27

The UK's new HG Wells coin features numerous errors -- including a four-legged tripod

6-Jan-21 5:27

Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.

W∴ Balboos, GHB6-Jan-21 5:38

W∴ Balboos, GHB

6-Jan-21 5:38

I recommend you to the following excerpts from the text:

Quote:
The Royal Mint defended its design but did not specifically respond to the criticism, telling CNN: "The coin depicts the artist's interpretation of the various machines featured in War of the Worlds and the Invisible Man."

And Chris Costello, the coin's designer, insisted he was intentionally reinterpreting imagery from Wells' works for a modern audience.

In the former, it's the Royal Mint trying to cover it's Royal Ass by using the "artist's interpretation" as the catchall defense. It does help me better understand that "The Guardian" and 'BBC News" are, indeed, ingrained into the culture: if you don't like the facts, adjust them until you do.

As for the second paragraph in the quote - let's take the "artist's" point at face value: he knows the modern audience . . . pathetic and ignorant thralls to Google on their hand-held devices.

Ravings en masse^
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

_WinBase_6-Jan-21 22:55

_WinBase_

6-Jan-21 22:55

'artists interpretation' is just BS for 'no he didnt do his homework and we need a story to cover it up so we dont look like the idiots we obviously are'.

everytime i hear lies and BS from people or companies that try to pathetically convince you of something other than what you know is true, it just makes me even more cynical, and there's so much of it about !!

OriginalGriff6-Jan-21 5:39

OriginalGriff

6-Jan-21 5:39

It makes you wonder about accounting practices at the Royal Mint if that's how they count: "one, two, four, ... seven, ... π ..."

And the Invisible man - who was after all no gentleman - wore a "wide-brimmed hat" rather than a top hat.

Clearly, there are no gentlemen of quality at the mint these days ... Sigh | :sigh:

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Mike Hankey6-Jan-21 6:36

Mike Hankey

6-Jan-21 6:36

Governments are all the same: one for you, two for me.

I'm not sure how many cookies it makes to be happy, but so far it's not 27.

JaxCoder.com

Daniel Pfeffer6-Jan-21 7:33

6-Jan-21 7:33

The next stage is the invisible coin...

Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.

Mike Hankey6-Jan-21 7:36

Mike Hankey

6-Jan-21 7:36

They already have the virtual coin so just a matter of time.

I'm not sure how many cookies it makes to be happy, but so far it's not 27.

JaxCoder.com

Gary R. Wheeler6-Jan-21 15:24

Gary R. Wheeler

6-Jan-21 15:24

Mike Hankey wrote:
virtual coin

bitcoin?

Software Zen: delete this;

Daniel Pfeffer6-Jan-21 7:27

6-Jan-21 7:27

OriginalGriff wrote:
It makes you wonder about accounting practices at the Royal Mint if that's how they count

No, it doesn't. The shenanigans of State banks make the managements of private banks look like amateurs!

OriginalGriff wrote:
there are no ~~gentlemen of quality~~ literate people at the mint these days

FTFY

Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.

Forogar 6-Jan-21 5:53

Forogar

6-Jan-21 5:53

Clearly the artist is the same kind of Elephant | [mastadon]

that "re-interprets" classic things because they were too lazy to actually consult the source material.

Then someone at The Mint who doesn't really give a sh*t about literature just rubber-stamps it.

As Shakespeare said on his Twitter feed... "That's why we don't have nice things anymore!"

- I would love to change the world, but they won’t give me the source code.

OriginalGriff6-Jan-21 6:23

OriginalGriff

6-Jan-21 6:23

� Forogar � wrote:
As Shakespeare said on his Twitter feed... "That's why we ~~don't~~ can't have nice things anymore!"

FTFY!

Richard MacCutchan6-Jan-21 6:26

Richard MacCutchan

6-Jan-21 6:26

And the stupid thing is, that had any of the people involved taken a trip here to Woking, they could have seen one of the original models standing on the pavement. War of the Worlds was written while Wells was living here, and many of the locations are within walking distance of our house.

Daniel Pfeffer6-Jan-21 7:20