Visual Studio Report

I am using Visual Studio 2013 Pro, and I am trying to create a report that uses a SQL View as the data set.
I am able to create a link to the data source, and i am able to create a link to the View as a data set.

but then the world seems to go crazy

I have two problems, which are probably linked.

1. The report is only 1 page, there are about 80 rows in my view; I want this report to create one page per row

2. When i add a field from my data set to my report, its add a function instead of the field, so when I drop the cost field, it adds an expression like '=Sum(Fields!COST.Value, "DataSet_Purcahse_Report")'

I am new to the report building in VS and this is the first report i have tried to build.

Please help,

Thanks,

Peter
LVL 1
pjg418Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike EghtebasDatabase and Application DeveloperCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pjg418Author Commented:
eghtebas,

I am working through this now, the book is a good start. Though I am feeling really disappointed by the report builder in VS 2013. Access Reporting seems to be about 3 decades ahead of report building in VS 2013, which is really disappointing.

The MSDN article is about using Matrix, lists and Table, which is ok but not exactly what i am looking for, and provides no support if you just want to have a report that does not use one of those items. (You data formatting options are significantly reduced when using one of the above listed objects)

I am hoping that working in this feature for a bit will help to get a better grip on this tool... I cannot believe i am wishing for something from Access...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.