July 14, 2009 at 11:41 pm
Hi
I am new bie to mssql server 2000.I am developing a report project using pagination and in my database there are lot of date records i want to select first time current month records dates only and when user clicks next or previous button in pagination i want to select previous month or next month records dates only.I am sending query which i want to modify please help me to solve this problem.
"select COUNT(date),date,country from advertisementhits where transactionid='9P853908BJ2391528521"' GROUP BY date,country"
Thanks in advance.
July 15, 2009 at 12:54 am
You can achieve this by following these steps:
1 Insert a Table Group on Date Field.
2. Check the "Page Break at end" property for this Group.
July 15, 2009 at 1:01 am
Thanks Sharma for your reply can you explain with an example my query is like this can you explain by modifying the below query
"select COUNT(date),date,country from advertisementhits where transactionid='9P853908BJ2391528521"' GROUP BY date,country"
Thanks in advance.
July 15, 2009 at 3:21 am
I hope you had created a Data Source using this query.
Lets day data source is dsMain.
Now follow the below steps:
1. Pick a new table control
2. Drag and drop required fields from DataSet to table control (Detail Section).
3. Select the Table Details section --> Right click to Insert a Group. It will open "Grouping and Sorting Properties" window.
4. Select the required field (e.d. Date) in expression to Group on
5. check following check boxes:
a) include group footer
b) page break at end
6. Click OK and see the preview.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply