I'm trying to use Reporting Services Developer edition with SQL Server 2000
and Visual Studio 2003. Net to create a report that already existed in
Crystal Reports 8.5 so that the report can be distributed via email and other
things that Report Services allows.
The Crystal Report uses something called a 'Running Total' field that
summarizes a field and evaluates a value for each chance of the field and
resets the value on the change of a group.
Who would you go about solving this problem in Report Services?
Thanks,
JimCheck out the RunningValue value function in BOL...
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> I'm trying to use Reporting Services Developer edition with SQL Server
> 2000
> and Visual Studio 2003. Net to create a report that already existed in
> Crystal Reports 8.5 so that the report can be distributed via email and
> other
> things that Report Services allows.
> The Crystal Report uses something called a 'Running Total' field that
> summarizes a field and evaluates a value for each chance of the field and
> resets the value on the change of a group.
> Who would you go about solving this problem in Report Services?
> Thanks,
> Jim|||What is BOL and how do you get access to it?
"Jim" wrote:
> Check out the RunningValue value function in BOL...
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> > I'm trying to use Reporting Services Developer edition with SQL Server
> > 2000
> > and Visual Studio 2003. Net to create a report that already existed in
> > Crystal Reports 8.5 so that the report can be distributed via email and
> > other
> > things that Report Services allows.
> >
> > The Crystal Report uses something called a 'Running Total' field that
> > summarizes a field and evaluates a value for each chance of the field and
> > resets the value on the change of a group.
> >
> > Who would you go about solving this problem in Report Services?
> >
> > Thanks,
> > Jim
>
>|||BOL is Reporting Services Books On Line.
You can also find them on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_1l6b.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:74ABD5D6-72D0-43E5-97C7-BD433A7F6876@.microsoft.com...
> What is BOL and how do you get access to it?
> "Jim" wrote:
> > Check out the RunningValue value function in BOL...
> >
> > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> > > I'm trying to use Reporting Services Developer edition with SQL Server
> > > 2000
> > > and Visual Studio 2003. Net to create a report that already existed in
> > > Crystal Reports 8.5 so that the report can be distributed via email
and
> > > other
> > > things that Report Services allows.
> > >
> > > The Crystal Report uses something called a 'Running Total' field that
> > > summarizes a field and evaluates a value for each chance of the field
and
> > > resets the value on the change of a group.
> > >
> > > Who would you go about solving this problem in Report Services?
> > >
> > > Thanks,
> > > Jim
> >
> >
> >
Showing posts with label total. Show all posts
Showing posts with label total. Show all posts
Sunday, March 25, 2012
Crystal Reports: Displaying percentages of total qty?
I'm creating a .NET crystal report sales report that lists the total # of each item sold and the percentage of total sales that the item contributed towards however, before I can calculate the percentage for each row, I need to know the total qty of the report, which I don't know how to retrieve.
So a sample report of 500 items sold may look like this:
------------------
Category | Qty Sold | Percentage
------------------
Electronics | 200 | 40%
Books | 100 | 20%
Movies | 150 | 30%
Games | 50 | 10%
------------------
Total | 500 | 100%
------------------
How can I calculate a percentage for something like this?
Thanks.
-Goalie35http://forums.belution.com/en/crystal/000/061/54.shtml
So a sample report of 500 items sold may look like this:
------------------
Category | Qty Sold | Percentage
------------------
Electronics | 200 | 40%
Books | 100 | 20%
Movies | 150 | 30%
Games | 50 | 10%
------------------
Total | 500 | 100%
------------------
How can I calculate a percentage for something like this?
Thanks.
-Goalie35http://forums.belution.com/en/crystal/000/061/54.shtml
Monday, March 19, 2012
crystal report -sorting issue
I am new to crystal reporting
Ii have an existing report with Job Numbers, Job Description and Total fields, The report works fine with the right sorting and groping in the Crystal report viewer.
But once loaded in the ASP page it stops sorting and grouping in the asp page - companys brower page.
Any suggestions on what must have gone wrong.
Thanks in advance
SandyTry checking in the
Menu File / Options / Database tab / Perrform Grouping On Server|||Hi Sandy, saw a very similar post somewhere else, this sounds odd, if it sorts correctly in CR, it should sort in ASP the same, you may want to have a web person check to make sure something is not sorting your report once it gets to the page. Sorry I am not much help...|||Try checking in the
Menu File / Options / Database tab / Perrform Grouping On Server
hi
done the changes-- but how would it reflect in my asp page
thanks
sandy|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.
what amount sub reports there're in your main report?
what amount records show your report?|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.
what amount sub reports there're in your main report?
what amount records show your report?
NO there is no subreports in my report - its a simple report - with fields like job, description and amount. - with a total and a grand total in the end. the report is coming to from the viewer though an asp page. Its sorted in the
report but when it has sort in the asp page ... it refuses to do the same. but when i click on the job field it sorts by descending and with one more click to goes to ascending. Now i want a default ascending as in the report.
I am a newbie in asp..
If you can please help
sandy
Ii have an existing report with Job Numbers, Job Description and Total fields, The report works fine with the right sorting and groping in the Crystal report viewer.
But once loaded in the ASP page it stops sorting and grouping in the asp page - companys brower page.
Any suggestions on what must have gone wrong.
Thanks in advance
SandyTry checking in the
Menu File / Options / Database tab / Perrform Grouping On Server|||Hi Sandy, saw a very similar post somewhere else, this sounds odd, if it sorts correctly in CR, it should sort in ASP the same, you may want to have a web person check to make sure something is not sorting your report once it gets to the page. Sorry I am not much help...|||Try checking in the
Menu File / Options / Database tab / Perrform Grouping On Server
hi
done the changes-- but how would it reflect in my asp page
thanks
sandy|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.
what amount sub reports there're in your main report?
what amount records show your report?|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.
what amount sub reports there're in your main report?
what amount records show your report?
NO there is no subreports in my report - its a simple report - with fields like job, description and amount. - with a total and a grand total in the end. the report is coming to from the viewer though an asp page. Its sorted in the
report but when it has sort in the asp page ... it refuses to do the same. but when i click on the job field it sorts by descending and with one more click to goes to ascending. Now i want a default ascending as in the report.
I am a newbie in asp..
If you can please help
sandy
Crystal Report Report Footer help
Hello,
I just joined this site and new to the crystal report. I build the attached report with 2 group footer and want to add Grand Total in report footer but its not working. My group footer is calculated field, and when i try to sum it the calculated field doesn't show under the report fields,any help please?You cannot use summary functions on already summarized fields..|||What other way I can get the grand total?|||Repeat in report footer section the same calculations you do at group footer section but with grand total data
I just joined this site and new to the crystal report. I build the attached report with 2 group footer and want to add Grand Total in report footer but its not working. My group footer is calculated field, and when i try to sum it the calculated field doesn't show under the report fields,any help please?You cannot use summary functions on already summarized fields..|||What other way I can get the grand total?|||Repeat in report footer section the same calculations you do at group footer section but with grand total data
Sunday, March 11, 2012
Crystal Report Page Skip Problem
Hello All,
I hav designed a report. It contacins more than 10 records in the details section. Mostly by 10 records the total page will be covered with some headers, so i need to skip the same headers to the next page for other records.
How can i skip to the next page if the Record count is > 10.
bye...
Tks & Rgds,
Poorni.To get at most 10 records per page, put a conditional new page after on the detail section with the formula
recordcound mod 10 = 0
This should be fine if you can be sure that 10 records won't take up more than 1 page.
I hav designed a report. It contacins more than 10 records in the details section. Mostly by 10 records the total page will be covered with some headers, so i need to skip the same headers to the next page for other records.
How can i skip to the next page if the Record count is > 10.
bye...
Tks & Rgds,
Poorni.To get at most 10 records per page, put a conditional new page after on the detail section with the formula
recordcound mod 10 = 0
This should be fine if you can be sure that 10 records won't take up more than 1 page.
Thursday, March 8, 2012
Crystal report - using sub report
i am using a sub report in my main report. I am able to count/ total a field using the Running total within that subreport which match the criteria of selection. i am passing a parameter from my main report say Issue number to subreport.
For each issue no passed i am totalling and writing in the report - one row per issue no ( with different columns like January, Feb, March,...)
Problem: At the end of the report i want the Verticle total of each coulmn say total in January, Feb, March,...I am not able to do this.
Is there a way to do this?
In the sub report i use Formula field in running total as i need to pick up only those records in the database which match the selection criteria provided. I tried other options like Sum of a field,..but no success.
let me know if any one of you have answer. THANKSdo you use grouping in the report(Jan, Feb, Mar...)?|||NO.
I have formula fields to calculate the First and the last day of each of the months using the current date. Using these i check the date in the record to count that record whether that should fall in Jan or Feb or march in the sub report.
Data comes from 2 seperate db tables. Issueno table(main report) and Tickets table (sub report)
Only Selected Issue no is passed as parameter to the sub report to do the above calculation (count no of tickets with date in Jan or Feb or Mar..).
Sub Report footer has these running total fields with the formula to count the tickets.
Report looks like this:
Issue# Rec in Jan Recs..Feb RecMarch Recs..April Total
5 0 1 2 0 3
12 2 0 7 2 11
14 0 2 0 4 6
17 11 4 0 0 15
24 0 7 1 0 8
======================================
GTotal ?? ?? ?? ?? ??
========================================
Or is there a way to count the figures in each column at the end of the Report?
(Data: First Row:- Issue no=5, Jan=0, Feb=1, March=2, Apr=0, Total=3)|||Your bottom line is to count the tickets on january, february..., i im right?
If that is you case, try this... add running total field(january) and the type of summary is count. Then in "evaluate", click the formula option and type this
month({ticket.date})=1
This means fo the month of january...
Add the another running total field for the month of february and so for...
Sorry, im slow in english so i cant understand yor question clearly.|||Your English: Not a problem at all. Thanks for the Feedback.
My problem in Short:
I am trying to Grand Total a DERIVED Field/Column like Jan, Feb, Mar...SO there is no Month field as such to Grand Total. All this calculation is done ina Sub report using the Formula field to determine in which coulmn (jan/feb/..) the record falls and accordingly counted in that month. For every issue no passed from main report as a parameter to subreport all the attached tickets to that Issue no are validated and if the selection criteria matched then counted.
Only vertical total of a devived field like Jan/feb/.. is a problem
For each issue no passed i am totalling and writing in the report - one row per issue no ( with different columns like January, Feb, March,...)
Problem: At the end of the report i want the Verticle total of each coulmn say total in January, Feb, March,...I am not able to do this.
Is there a way to do this?
In the sub report i use Formula field in running total as i need to pick up only those records in the database which match the selection criteria provided. I tried other options like Sum of a field,..but no success.
let me know if any one of you have answer. THANKSdo you use grouping in the report(Jan, Feb, Mar...)?|||NO.
I have formula fields to calculate the First and the last day of each of the months using the current date. Using these i check the date in the record to count that record whether that should fall in Jan or Feb or march in the sub report.
Data comes from 2 seperate db tables. Issueno table(main report) and Tickets table (sub report)
Only Selected Issue no is passed as parameter to the sub report to do the above calculation (count no of tickets with date in Jan or Feb or Mar..).
Sub Report footer has these running total fields with the formula to count the tickets.
Report looks like this:
Issue# Rec in Jan Recs..Feb RecMarch Recs..April Total
5 0 1 2 0 3
12 2 0 7 2 11
14 0 2 0 4 6
17 11 4 0 0 15
24 0 7 1 0 8
======================================
GTotal ?? ?? ?? ?? ??
========================================
Or is there a way to count the figures in each column at the end of the Report?
(Data: First Row:- Issue no=5, Jan=0, Feb=1, March=2, Apr=0, Total=3)|||Your bottom line is to count the tickets on january, february..., i im right?
If that is you case, try this... add running total field(january) and the type of summary is count. Then in "evaluate", click the formula option and type this
month({ticket.date})=1
This means fo the month of january...
Add the another running total field for the month of february and so for...
Sorry, im slow in english so i cant understand yor question clearly.|||Your English: Not a problem at all. Thanks for the Feedback.
My problem in Short:
I am trying to Grand Total a DERIVED Field/Column like Jan, Feb, Mar...SO there is no Month field as such to Grand Total. All this calculation is done ina Sub report using the Formula field to determine in which coulmn (jan/feb/..) the record falls and accordingly counted in that month. For every issue no passed from main report as a parameter to subreport all the attached tickets to that Issue no are validated and if the selection criteria matched then counted.
Only vertical total of a devived field like Jan/feb/.. is a problem
Friday, February 24, 2012
Crosstab Report
I am creating report with total costs by job, it repeats "column totals"
two times, and at the end column "grand total". "grand total" column is okay.
Is there any way I can drop/disable repeating "column totals". See example below, help me to drop repeating column.
Thanks
Job 1 Job 2 GrandTotal
Total Total
Cost 1 177,855 177,855 162,755 162,755 340,610
Cost 2 169,847 169,847 161,063 161,063 330,910
Cost 3 37,404 37,404 102,416 102,416 139,820In CR,right click on the cross tabl. Choose format Cross tabl. U ve a tab like "Customize Style". Choose each and every row in Rows List and below that u ve Grouping Option. Suppres that grouping option. I think this may be a soln. Try it out.
two times, and at the end column "grand total". "grand total" column is okay.
Is there any way I can drop/disable repeating "column totals". See example below, help me to drop repeating column.
Thanks
Job 1 Job 2 GrandTotal
Total Total
Cost 1 177,855 177,855 162,755 162,755 340,610
Cost 2 169,847 169,847 161,063 161,063 330,910
Cost 3 37,404 37,404 102,416 102,416 139,820In CR,right click on the cross tabl. Choose format Cross tabl. U ve a tab like "Customize Style". Choose each and every row in Rows List and below that u ve Grouping Option. Suppres that grouping option. I think this may be a soln. Try it out.
Subscribe to:
Posts (Atom)