Report Datasource

Question

0.00/5 (No votes)

See more:

Hie!

I am using vb.net 2005 with ms access

when i am creating a report and creata a datasource.
after that when i drag filed from data source to report designer.. draged field will display sum of all values of that field. how? i dnt want a sum of field i want report for all field one by one .

please help me!

Posted 6-Jul-10 22:07pm

Npanchasara

Add a Solution

Comments

Christian Graus 7-Jul-10 4:08am

I can't make sense of what you're exactly doing, but then, I'm a programmer, I write code to achieve things like this, I don't ever drag and drop anything.

Npanchasara 7-Jul-10 4:15am

i know you are a programmer but if you cant understand mi question its okay.. but you not have a right to tell me anything like this..
i dnt want to drag and drop but when we create a reprt we have to do this to put our databse field on report designer okay.

R. Giskard Reventlov 7-Jul-10 4:34am

Are you dropping the field into the footer? I'm guessing it should go into the body of the report (fortunately have not had to use Access for many years).

Npanchasara 7-Jul-10 4:42am

No i am draging fields in body part only

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-07-06T23:05:00

Solution 1

Yes, it happens by default in SSRS. (though you have not mentioned, it's quite general in SSRS)

Not an issue. This is because at report level, a textbox is not binded to any dataset. If you drop a table and then a field into it, it would be fine as table has a defined dataset to it and thus all the controls inside it.

Generally if you don't want sum and the value is same in all the rows, then use First instead of sum and it would work fine.

Posted 6-Jul-10 23:05pm

Sandeep Mewara

Comments

Npanchasara 7-Jul-10 5:19am

Thank you... i already did this before your answer but then and then mi report ouput is blank.. i dnt know where is the mistake.. can you just give me steps for how to create a data source for report.? please

Sandeep Mewara 7-Jul-10 5:43am

It depends on lots of things. It would be hard to tell where are you doing a mistake! (sorry to say, but surely you are doing it somewhere if all is right and data should had been displayed)
1. Check you have data returned using Data tab
2. Append a string before the value using '&' such that you are sure you see the textbox while rendering. You can also use some backcolor.
If they dont help, post what is the textbox expression you are using. (with a little bit on what data you are getting)