Click here to Skip to main content
15,867,954 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: What is the status of report generation these days? Pin
Hooga Booga7-Jan-21 5:04
Hooga Booga7-Jan-21 5:04 
GeneralRe: What is the status of report generation these days? Pin
Bruce Patin7-Jan-21 6:08
Bruce Patin7-Jan-21 6:08 
GeneralRe: What is the status of report generation these days? Pin
R.Fuller7-Jan-21 13:41
R.Fuller7-Jan-21 13:41 
GeneralRe: What is the status of report generation these days? Pin
charlieg8-Jan-21 5:56
charlieg8-Jan-21 5:56 
GeneralRe: What is the status of report generation these days? Pin
Member 139658668-Jan-21 0:17
Member 139658668-Jan-21 0:17 
GeneralRe: What is the status of report generation these days? Pin
charlieg8-Jan-21 5:21
charlieg8-Jan-21 5:21 
GeneralRe: What is the status of report generation these days? Pin
charlieg8-Jan-21 5:18
charlieg8-Jan-21 5:18 
GeneralRe: What is the status of report generation these days? Pin
Kirk 103898218-Jan-21 11:29
Kirk 103898218-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...

GeneralRe: What is the status of report generation these days? Pin
charlieg10-Jan-21 16:08
charlieg10-Jan-21 16:08 
AnswerRe: What is the status of report generation these days? Pin
bharathdjx089-Jan-21 0:57
bharathdjx089-Jan-21 0:57 
GeneralRe: What is the status of report generation these days? Pin
charlieg10-Jan-21 16:11
charlieg10-Jan-21 16:11 
GeneralCOVID: Real Articles Pin
W Balboos, GHB6-Jan-21 6:44
W Balboos, GHB6-Jan-21 6:44 
GeneralRe: COVID: Real Articles Pin
Slacker0076-Jan-21 7:27
professionalSlacker0076-Jan-21 7:27 
GeneralRe: COVID: Real Articles Pin
Nelek6-Jan-21 7:30
protectorNelek6-Jan-21 7:30 
GeneralDoesn't anyone _read_ anymore?! :mad: Pin
Daniel Pfeffer6-Jan-21 5:27
professionalDaniel Pfeffer6-Jan-21 5:27 
RantRe: Doesn't anyone _read_ anymore?! :mad: Pin
W Balboos, GHB6-Jan-21 5:38
W Balboos, GHB6-Jan-21 5:38 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
_WinBase_6-Jan-21 22:55
_WinBase_6-Jan-21 22:55 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
OriginalGriff6-Jan-21 5:39
mveOriginalGriff6-Jan-21 5:39 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
Mike Hankey6-Jan-21 6:36
mveMike Hankey6-Jan-21 6:36 
JokeRe: Doesn't anyone _read_ anymore?! :mad: Pin
Daniel Pfeffer6-Jan-21 7:33
professionalDaniel Pfeffer6-Jan-21 7:33 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
Mike Hankey6-Jan-21 7:36
mveMike Hankey6-Jan-21 7:36 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
Gary R. Wheeler6-Jan-21 15:24
Gary R. Wheeler6-Jan-21 15:24 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
Daniel Pfeffer6-Jan-21 7:27
professionalDaniel Pfeffer6-Jan-21 7:27 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
  Forogar  6-Jan-21 5:53
professional  Forogar  6-Jan-21 5:53 
GeneralRe: Doesn't anyone _read_ anymore?! :mad: Pin
OriginalGriff6-Jan-21 6:23
mveOriginalGriff6-Jan-21 6:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.