Report empty?

I have created a basic report that just shows some columns from a query, I'm using a dataadapter and the reportviewer component.

If I execute the query it calles it returns some rows, but the report is empty.

What's wrong with the reportviewer and the report objects?

I'm thinking about just using gridviews because the reports don't work, altough I'd like to use the reportviewer because it can export to excel/pdf.

Thanks.

HI,onishirox:

I can not debug it without any codes from your scenario, but you can have a check with this following walkround to make your codes work:

Binding Data to the ReportViewer Control Dynamically in ASP.NET 2.0 -

http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/1/

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be

of assistance

|||

HI,onishirox:
We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

|||

Thanks. I think the problem was that I was using sqlserver2000, seems to work ok now with sql2005.

Report designer not working

Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
and Reporting Services. I downloaded and installed sample project, but no
matter what I do I can not see reports in designer. They openning as xml
files only. Any idea?
Thank you, YuriSorry, please disregard my message. I forgot to install Microsoft SQL Server
2005 Express Edition Toolkit
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||Sorry, toolkit is installed, but problem is still there. Any idea? Thank you
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||Which kind of project you created? Can you see the Business Intelligence
Projects under the project types list in the Visaul Stadio?
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||No, I see the all the usual templates and Reports For Windows Sample
Application.
This template was added after I run sample application from Microsoft
download.
"Patrick" <feng_online@.hotmail.com> wrote in message
news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
> Which kind of project you created? Can you see the Business Intelligence
> Projects under the project types list in the Visaul Stadio?
> "Yuri" <ykasan@.fojp.com> wrote in message
> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
>> and Reporting Services. I downloaded and installed sample project, but no
>> matter what I do I can not see reports in designer. They openning as xml
>> files only. Any idea?
>> Thank you, Yuri
>|||Thank you for fast response, Patrick.
Should I have a Business Int. template in my project templates?
I did install SQL 2005 toolkit for my Visual Basic Express.
"Patrick" <feng_online@.hotmail.com> wrote in message
news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
> Which kind of project you created? Can you see the Business Intelligence
> Projects under the project types list in the Visaul Stadio?
> "Yuri" <ykasan@.fojp.com> wrote in message
> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
>> and Reporting Services. I downloaded and installed sample project, but no
>> matter what I do I can not see reports in designer. They openning as xml
>> files only. Any idea?
>> Thank you, Yuri
>|||I am sorry. I never used this way. Both I installed in my machine are VS.net
and SQL Server 2005
"Yuriy" <ykasan@.fojp.com> wrote in message
news:OI6pZwjtGHA.2448@.TK2MSFTNGP06.phx.gbl...
> Thank you for fast response, Patrick.
> Should I have a Business Int. template in my project templates?
> I did install SQL 2005 toolkit for my Visual Basic Express.
> "Patrick" <feng_online@.hotmail.com> wrote in message
> news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
>> Which kind of project you created? Can you see the Business Intelligence
>> Projects under the project types list in the Visaul Stadio?
>> "Yuri" <ykasan@.fojp.com> wrote in message
>> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express
>> Edition and Reporting Services. I downloaded and installed sample
>> project, but no matter what I do I can not see reports in designer. They
>> openning as xml files only. Any idea?
>> Thank you, Yuri
>>
>sql

Report Desginer Requirements?

Good da
Does anyone know if Report Designer for Reporting Services requires the full Visual Studio .NET 2003 suite, or will it run under Visual Basic .NET soo3
Thank
MattWhen you run the setup for Reporting Services, there should be a check which
requires VS.NET 2003 (any edition) to use the Report Designer. VB.NET, by
itself is not enough.
--
- Anith
( Please reply to newsgroups only )|||"Anith Sen" wrote:
> When you run the setup for Reporting Services, there should be a check
which
> requires VS.NET 2003 (any edition) to use the Report Designer. VB.NET, by
> itself is not enough.
I guess the SBS (and like) crowd must love this:~).
Happy Holidays,
www.rac4sql.net|||Right, any .NET thingy ought to be enough, remember, there are always
incentives for complexity :-)
--
- Anith
( Please reply to newsgroups only )|||"Anith Sen" wrote:
> ...there are always incentives for complexity :-)
Hmm...I remember recently reading just that phrase :~)sql

Report ciew correct but print no

Hi,
first
Program language visual basic 6 +SP5
Crystal Report 8.5
SQL Server2000

Day2(Namr of report)

the problem
i use these code so when any one click print in report view he can select the printer

UseDefault = False
Day2.PrinterSetup Me.hwnd
Day2.PrintOut True

first time view report its print ok but if i open report again with differnet parameters its showing correct data in report view but after i click print and choose printer it still print the first report

why these happen?I've seen this problem before, a few years ago.
I don't work at the same place now, so I can't go back into SourceSafe and check the code, but I seem to recall we had this problem due to originally not properly disposing of the report object.
If you have a report object open (instantiated) and you then reset some parameters, it may not function properly unless you dispose of the object when you next start a "view" process.
So, when you click on a button to regenerate your view of the report, make sure you do something like this;

set objReport = Nothing
set objParams = Nothing

and then provide code to recreate the objects, which should flush the report object and all objects is has created, and then create a clean new object so you can set parameters.

Davesql