I hope someone can help me with this.
I am using sql server 2005 report services, report builder for ad-hoc reporting.
I only am able to use some views and i am not able to get to the fields, tables etc., just views.....At itself this might not be a problem.
When making a new field i have a couple of functions, but i need to make row numbers and with those rownumbers i need to compare two records with eachother.
In written sql i kind of know how to do it, but when i don't have this option, and just have the option to summerize some field i dont know how to.
Please advise?
Thanks in advance
I am using sql server 2005 report services, report builder for ad-hoc reporting.
I only am able to use some views and i am not able to get to the fields, tables etc., just views.....At itself this might not be a problem.
When making a new field i have a couple of functions, but i need to make row numbers and with those rownumbers i need to compare two records with eachother.
In written sql i kind of know how to do it, but when i don't have this option, and just have the option to summerize some field i dont know how to.
Please advise?
Thanks in advance
