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
Showing posts with label input. Show all posts
Showing posts with label input. Show all posts
Friday, March 9, 2012
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.
Subscribe to:
Posts (Atom)