Cross Tab Chart Report

This public forum is for user-to-user discussions of ASP.NET Report Maker. Note that this is not support forum.

Cross Tab Chart Report

Postby RT » Fri Feb 05, 2010 10:57 pm

Can this been ploted by day of the week like you can do with the Months? Ex: Sun Mon Tue Wed . ...
RT
 

Re: Cross Tab Chart Report

Postby Webmaster » Sat Feb 06, 2010 11:02 am

No, this is not supported.
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm

Re: Cross Tab Chart Report

Postby eX » Tue Jul 19, 2011 7:42 pm

Hello,

I am using register version of asp .net report maker.
I created Crosstab report successfully, after that i wanted to create chart but i can't get diagram with values from report, i am getting message no data.
I followed steps from help guide with report maker.
Does anyone have similar problem ?

When i change summary value from sum to count i get my chart, why i can't use sum when colummn type is int?

Thank you
eX
 

Re: Cross Tab Chart Report

Postby Webmaster » Wed Jul 20, 2011 9:52 am

Show your database schema, report and chart settings.
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm

Re: Cross Tab Chart Report

Postby eX » Thu Jul 21, 2011 2:54 am

I got it my chart but now i want to have two statistic on one or two chart on one page.
I have four values:

date
site
reserved memory
used memory

I created and got reserved memory per page sorted by date. Now i want to put used memory on same chart if it possible with another color, or another chart next to the first one with same parameters:
reserved memory per page sorted by date.

when i create cross tab report i can chose only one value for painting on chart (third tab during the creating cross tab report) in this case that is reserved memory. If i create another one cross tab report with used memory i am not able to put second chart on same page :S.

thank you for your help
eX
 

Re: Cross Tab Chart Report

Postby Webmaster » Thu Jul 21, 2011 9:45 am

Use the chart tyep "Multi-Series Column 2D + Line Dual Y Chart" / "Multi-Series Column 3D + Line Dual Y Chart" and set "reserved memory" / "used memory" as series fields. Note that these chart types are for registered users only.
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm

Re: Cross Tab Chart Report

Postby eX » Fri Jul 22, 2011 4:17 pm

Thanks for this, yes i am registred user.

Can i load chart data from somewhere else except crosstab report?

I created my custom view "aaaaaaaaaaaaa" with prepared values which i need.
View contain four column:
-Page
-Date
-Avg (reserved memory) per month
-Avg (used memory) per month

Here is SQL comand for custom view:

select server, convert(date,(convert(varchar,YEAR(datum))+ '-' + convert(varchar,MONTH(datum))+'-'+ '01')) as 'Datum', avg (data/1024) as 'Iskoristeno',avg (reserverd/1024) as 'Rezervisano' from schema.TABEL group by server, YEAR(datum), MONTH(datum) order by server,YEAR(datum), MONTH(datum)

On custom view i set:
extended filter user_select on server column, for report field setings i put display as select one and put my default value
on reserver and used column for report field setings i checked sum as summary values.


After that i tried to create chart per your instruction
************************************************
"Multi-Series Column 2D + Line Dual Y Chart" /
> "Multi-Series Column 3D + Line Dual Y Chart" and set
> "reserved memory" / "used memory" as series fields.
************************************************

but when i load page i am getting the exception here is :
************************************************************************************************
Server Error in '/' Application.
--------------------------------------------------------------------------------

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1955: Non-invocable member 'ASP.aaaaaaaaaaaaarpt.craaaaaaaaaaaaa.SqlWhere' cannot be used like a method.

Source Error:

Line 2014:string SqlSelect = aaaaaaaaaaaaa.SqlSelect;
Line 2015:string SqlChartSelect = aaaaaaaaaaaaa.hmm.SqlSelect;

Line 2016:string SqlChartBase = "(" + ewrpt_BuildReportSql(SqlSelect, aaaaaaaaaaaaa.SqlWhere(), aaaaaaaaaaaaa.SqlGroupBy(), aaaaaaaaaaaaa.SqlHaving(), aaaaaaaaaaaaa.SqlOrderBy(), aaaaaaaaaaaaa_rpt.Filter, "") + ") EW_TMP_TABLE";

Line 2017:aaaaaaaaaaaaa.hmm.Series.Add(new string[] {aaaaaaaaaaaaa.Iskoristeno.FldCaption(), "P"});
Line 2018:aaaaaaaaaaaaa.hmm.Series.Add(new string[] {aaaaaaaaaaaaa.Rezervisano.FldCaption(), "S"});


************************************************************************************************

Is there any big guide line or book for this can you say to me so i don't need to ping you for my problems :)

Thank you for yout time and help :)
eX
 

Re: Cross Tab Chart Report

Postby Webmaster » Mon Jul 25, 2011 10:07 am

Please make sure that you are using the latest template from:
http://www.hkvstore.com/aspnetmaker/templatefile.asp
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (ASP.NET Report Maker)