How do I get number of visit in a month

[Ben]

Hi guys,
Anybody can help me to complete this task in Telerik Report. I have a table in sql database with three fields: Id, name, visit_date. A person may visit several times in month. I would like to get a report which is showing the person name and number of his visit in each month acccording to the selection of year as a parameter. 
I want to pass 'year' as a parameter which is selected by user.
Out put should be

Year
Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Jeff	1	0	0	3	0	0	0	0	0	0	0	0	4

Jeff visited 1 time in Jan, and 3 times in Apr in the selected year
Anybody can help me?
Thanks
Ben 

[Ben]

Hi Guys,
I created the same report with Crosstab, but I have a problem right now.
I created one crosstab, but it is repeating in the preview and report viewer. Getting 6 table with same data.
Anybody can help?
Thanks
Ben

[Steve]

Hi Ben,

This is most likely due to the fact you have bound both the Report itself and the CrossTab as well. They're both Data Items and can be bound to a separate data source. If you're only using the CrossTab to display your data, you can go ahead and reset the DataSource property of the Report.

Greetings,
Steve
the Telerik team

[Ben]

Hi Steve,
You are right. Thank you so much for your quick respose. Now its ok.
I have one more issue. Could you please reply. Right line of the crosstab table is missing in web browser. It will be shown in preview. But I run it in browser there is no right end line of the table. I tried several ways in page layout, but no hope so far. Attached is the screen shot of the table in browser.
Thanks
Ben

[Steve]

Hello Ben,

We're aware of this problem. The workaround that we can offer for the time being is to apply some padding e.g. 2mm to the problematic item i.e. right padding for the Table item.
We plan to improve the HTML rendering for subsequent version to avoid such problems.

Greetings,
Steve
the Telerik team

[Ben]

Hi Steve,
Thank you so much for your suggestion. I have some more probelms in telerik reports right now that is some of my report is not opening in firefox. There is no problem in internet explorer and other browsers.
How can I solve this issue? Do I need to make any changes to view in firefox.
I am using Avg() for a calculation. I am not getting the result with decimal part, it is  rounding up the decimal part.
For example, if the result of an average is 12.5, I get the result in report which is 12.00. What is wrong in use of Avg function in telerik report.
Please help me to solve these problems.
Thanks
Ben

[Ben]

Hi guys,
My firefox is 3.6 version. IF you get the version you can easily identify the problem that is why I submitting it again.
Some times the report can be viewed in firefox. But some time it doesnt open the same report, just showing up "Generating Report....." for a long time and no report.

Thanks
Ben

[Steve]

Hi Ben,

We have not been contacted with this inquiry so far and our local tests on our online demos with the latest Firefox version do not show any problems. Can you test with these demos and let us know of the outcome? If the problem persists on the demos, it is highly likely that either the Firefox installation is corrupted or you have some plug-in or extension that is causing the problem to occur. You can try them on a Vanilla Firefox install to make sure nothing interferes with it.
As for the problem with the Avg function, most likely the problem is coming from the data itself or formatting you have applied. I've tested this with a simple report using the AdventureWorks database (comes with the report installation) that is attached here as an example.

All the best,
Steve
the Telerik team

[Ben]

Hi Steve,
Thank you so much,
Now it is ok. Your sample report was also showing the same problem, but I update my firefox with 4.0 beta version, now all of the reports are working without any problem in 4.0.
Average problem is also solved- I converted the field to double with CDbl() function. So now I am getting the decimal part also.

Thanks again
Ben