[SQL] hi ........i have a query related to MS reporting services
HI to all of you. I am a new member of this group and this is my first mail in this group.I am working in MS Reporting services.And i am new in this job. I have a problem. There is a table which has many columns. and i have to give selection to client that he can select any top 10,25,500,1000, sales by departmentment there are more than 10 department and he want to see top ten seelings in each department. How i can do it. without using top 10 syntax iin query. i dont have to use top 10 sales from table syntax. so please help me. Regards Dinesh Tiwari Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
[SQL] Query regarding to MS reporting services (Grand total problem)
Hi, I have a problem reagarding Grand Total in the table footer. I am showing only top 10 seeling for each department in report but i want sum of whole table seelings in table footer. not only 10 sellings which are shown in report. I want the sum of all 40 thousand rows. How i can do it. If any one have idea about this please help me. Thanks in advance. Regards Dinesh Tiwari How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
[SQL] Query regarding Writing a report using the file sysstem data processing extensions
Hi Experts.I have some problem in SQL server reporting services 2000.I am doing with FILE SYSTEM DATA PROCESSING EXTENSIONS i have done all the things correctly.like copying the .dll file to 3 folders, writing some code in XML file which was given on net and on books.after that it is showing me the File Sysytem Information in combobox But when i am trying to select this Data typeNow problem occursBut some how i managed it...i have selected windows AuthenticationBut when i am writting in query designer \\MyServer\MySharethen it is giviing errorsome time it is saying that there is error near to \.and some time it is saying that connection can not be made please check the connection string. I am doing all this on my local system So if any body have any idea what to write in query designer and what these errors indicates please help me RegardsDinesh Tiwari Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
