Showing posts with label input. Show all posts
Showing posts with label input. Show all posts

Friday, March 9, 2012

how to get report by Month

hi.
i used vb 2005 and CR 11
now .i want to display Report By Month ( from input textbox )
how can i ?What do you mean by report by month?

Do you want to display report in the format Jan, Feb, March ... or you want display data for particular month?|||u can provide parameters field as date time

suppose u define startdate and enddate

and then

report menu select edit selection formula give the range of that field as

currentdate <= startdate and currentdate >= enddate

so wenevr u execute the report it will ask for the range and u can select

Hope this is beneficial for u

With Best Regards
Ruby

Wednesday, March 7, 2012

How to get months and year

Hi All,

I provided the client with the dropdownlist which lists all the months (january - december). This input will be used to filter in the invoiceDT.

How can I write the query where clause to compare the invoiceDT (mm/dd/yyyy) into this input which is only number 1 through 12?

TIA

hi,

you can use following

" select * from table where ( datepart(mm,invoicedt) = "+ddlmonthfrom.SelectedIndex // i assume you've 1 additional item in dropdown.

the problem with this query is say you've 2 years data & you select say may, it will list data for may month of both years.

hope it helps,

regards,

satish.