1. Scott
  2. Report Editor
  3. Tuesday, August 16 2016, 04:45 PM
  4.  Subscribe via email
Most of my experience with VReports comes from experimentation and/or rollover knowledge from Crystal Reports and I have designed some very extensive and complex financial reports for clients, but I think I am not being very efficient when it comes tabulating totals, end results, and percentages, etc...

I do this with a bunch of sub reports - but I am wondering if there is a better, more efficient method:

In my report I pull in all fields from VDB, and then just use the data as I need in the report. I have to use many sub reports to do different counts and sums on data based on different criteria.

Such as:

fldA is amount and fldB is a categoryType (like cost, cost basis, account fee, etc)

Right now I band out the report with these fields for all the records in the range of the query, such as 2015 or 2016...

I have to use sub reports to do counts of the different categories and sums of fldA per category. Which winds up being near 19 different subs in my report.

I know I can do a sum, count for the whole report in the group footer, but I can't break them out by category (or, put it this way - I have no idea how to do this by category if it is possible).

My question concerns expressions in a footer - can I use an expression in this manner:

Summary Field:

SUM ( fldA = 'Category') or COUNT ( year(fldA) = 2016)

or some other SQL expression like SUM(SELECT fldA FROM tblA WHERE category = 'Whatever')

How can I write expressions to do this? Is it possible?

Scott
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi Scott,

No, currently it is not supported.

I'm not sure, if it will make things simpler, but in this very example -
it should be possible to modify the source query, so it will contain fldA_CatA, fldA_CatB.
When fldB=CatA: fldA_CatA=fldA and fldA_CatB=0.

And then calculate SUM( fldA_CatA) and SUM( fldA_CatB).
It makes the source query complex, but the amount of additional queries from subreports decreases.

Maybe you know how it can be done in the Crystal Reports?
Some features that we can implement in the VReport engine?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Scott Accepted Answer
The data set for this one particular report I am referring to is huge.

I am going to try to modify the query using the Query Builder to bring in the sums and counts at the query level.

This is what I am doing now: My report is printed by category and summed/counted in the group by footer by every category.

And then at the end of the report in the report footer I am summing and counting on the whole report. I would prefer just to have a summary area in the report footer breaking all the data down as needed.

I am using a few subs now - It works but I am not sure it's the most effective method. What I tried (and worked also) was use table controls (with one header and one field) and have a query for every table that sums or counts the data as needed.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Scott Accepted Answer
The data set for this one particular report I am referring to is huge.

I am going to try to modify the query using the Query Builder to bring in the sums and counts at the query level.

This is what I am doing now: My report is printed by category and summed/counted in the group by footer by every category.

And then at the end of the report in the report footer I am summing and counting on the whole report. I would prefer just to have a summary area in the report footer breaking all the data down as needed.

I am using a few subs now - It works but I am not sure it's the most effective method. What I tried (and worked also) was use table controls (with one header and one field) and have a query for every table that sums or counts the data as needed.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Scott Accepted Answer
The data set for this one particular report I am referring to is huge.

I am going to try to modify the query using the Query Builder to bring in the sums and counts at the query level.

This is what I am doing now: My report is printed by category and summed/counted in the group by footer by every category.

And then at the end of the report in the report footer I am summing and counting on the whole report. I would prefer just to have a summary area in the report footer breaking all the data down as needed.

I am using a few subs now - It works but I am not sure it's the most effective method. What I tried (and worked also) was use table controls (with one header and one field) and have a query for every table that sums or counts the data as needed.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Sergey Pashkov Accepted Answer
Ok, but what about Crystal Reports.
Does it have some techniques that can be used in the same situation?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories