My report doesn't show data!

Question

Post reply

My report doesn't show data!

artan_p

Valued Member

Points: 62
More actions
December 1, 2010 at 1:57 pm

#147879

Hi there,
Right now I'm in big trouble, I have create a simple application that use Report (rdlc). It works in my computer good but it doesn't work at the client(s) computer properly.
At the clients it doesn't show the data from SQL SERVER DATABASE!
download(Visual Studio project):

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

mtillman-921105 SSCertifiable Points: 7156 More actions · Answer 1

So there is no error, just a blank page? Are there any parameters for the query?

The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

artan_p Valued Member Points: 62 More actions · Answer 2

I have not used Report Parameters, but I have create Query with Parameter, then in Microsoft ReportViewer I have fill in this way:

.:Code:.

this.DataTable1TableAdapter.Fill(this.POSDataSet.DataTable1,0);

the second parameter is up to me ( I change that with my code)

this is not problem

My problem is at the client computer, there it doesn't show data from SQL SERVER 2005. In my computer it works good.

What should I install to my client?

I have install these:

SQL SERVER 2005 Standard

Microsoft Report Viewer

.Net Framework

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

Couple of 'Is it plugged in' questions here.

1) Client is onsite, not at a different location, correct? (Wrong server, or bad params for data)

2) You both look at the exact same network/serverbank for servernames/databases ... etc. (see above)

3) You're logging in as the same user on both systems (security data visibility and default schemas) from the report side of things?

4) You have access on the target system and can login, from the client's system, to the SSMS and see the data, under whatever login HE uses to run this report? Preferably, you want to take the query he builds on his system and run it to see the results.

You can use profiler to help trap the call to the database, make sure the query going to the db is what you're expecting. Any number of defaults can go sideways.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

artan_p Valued Member Points: 62 More actions · Answer 4

Hi!

I have attached the db file and I reconfigure the application to connect to new server, It says login OK but it does not fill with DATA the Report.

I'm not sure what should I do!?

Did you run my application? (if yes, does it fill the report with data)?

What should I install to the computer to work the report?

I have installed these:

.NET Framework

Microsoft Report Viewer 2008

SQL Server 2005 Standard

pls...

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 5

artan_p (12/1/2010)
I have attached the db file and I reconfigure the application to connect to new server, It says login OK but it does not fill with DATA the Report.
...
Did you run my application? (if yes, does it fill the report with data)?

I'm sorry, but this is the internet. It's nothing personal, but you do understand we're mostly SQL experts, not a VB coders, and most of us really don't have the time to debug a VB app to make sure there's no hidden 'fun' hiding within it?

Run your application? I'm not even downloading it to my computer.

I can offer advice, assistance, even review some code that you might post for specific issues. Install and run unreviewed VB code/app? No, sorry.

If you require that level of help, hopefully someone around here has a disconnected sandbox they can transfer it into and some time to do that. Sorry I wasn't able to help.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Craig Farrell (12/1/2010)
artan_p (12/1/2010)
I have attached the db file and I reconfigure the application to connect to new server, It says login OK but it does not fill with DATA the Report.
...
Did you run my application? (if yes, does it fill the report with data)?
I'm sorry, but this is the internet. It's nothing personal, but you do understand we're mostly SQL experts, not a VB coders, and most of us really don't have the time to debug a VB app to make sure there's no hidden 'fun' hiding within it?
Run your application? I'm not even downloading it to my computer.
I can offer advice, assistance, even review some code that you might post for specific issues. Install and run unreviewed VB code/app? No, sorry.
If you require that level of help, hopefully someone around here has a disconnected sandbox they can transfer it into and some time to do that. Sorry I wasn't able to help.

You won't find many people here willing to download code such as that to their computer to run - too much risk.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 7

It sounds like either a network issue or a permissions issue. If you're not willing to look at Craig's questions and test them out for yourself to verify none of what he asked is applicable, then we can't help you.

At this point, your only other option is to hire a consultant to come on site and help you.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

artan_p Valued Member Points: 62 More actions · Answer 8

Hi!

In my project I have used Qureis, maybe I must use procedures

Could it be my problem!?

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 9

artan_p (12/2/2010)
Hi!
In my project I have used Qureis, maybe I must use procedures
Could it be my problem!?

We're not going to even try to answer that question until you tell us if you went through Craig's checklist and verified none of that is the problem.

My question is, are you seeking a solution or an excuse?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Brandie Tarvin (12/2/2010)
artan_p (12/2/2010)
Hi!
In my project I have used Qureis, maybe I must use procedures
Could it be my problem!?
We're not going to even try to answer that question until you tell us if you went through Craig's checklist and verified none of that is the problem.

Please start by answering Craig's list of questions.

I will answer your question as it appears now. It depends and it is a possibility. But it is not always the case. Start with Craig's list of questions and provide the answers.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events