SQLServerCentral / Discuss Content Posted by Asif Sayed / Article Discussions / Article Discussions by Author / Reporting Services 2005 101 with a Smart Client / Latest Posts

RE: Reporting Services 2005 101 with a Smart Client

sqlpro — Wed, 13 Sep 2006 14:45:00 GMT

i found them finally

they are under "Report" menu and not on right click !

RE: Reporting Services 2005 101 with a Smart Client

Asif Sayed — Wed, 13 Sep 2006 13:31:00 GMT

Stacy,

Please make sure the reportviewer1.ProcessingMode = Local

This should resolve the issue.

Regards,

Asif

RE: Reporting Services 2005 101 with a Smart Client

Asif Sayed — Tue, 12 Sep 2006 13:09:00 GMT

Thats strange! I am getting email regularly on gmail account, never got any complaint. If you are sending through Gmail then make sure to change the file extension from .ZIP to anything else as Gmail will not let you attache ZIP file, which has any executables in side. Or try sending me at asif_to@yahoo.com

Regards,

Asif

RE: Reporting Services 2005 101 with a Smart Client

Stacy Parrish — Tue, 12 Sep 2006 13:02:00 GMT

Asif,

your email you reference is Asif.blog@gmail.com, correct? I zipped the project and I am getting failure from the postmaster

My project name is rswin1, any other thoughts?

Stacy

RE: Reporting Services 2005 101 with a Smart Client

Asif Sayed — Tue, 12 Sep 2006 12:07:00 GMT

Hi Stacy,

Please make sure you have the correct project name specified, I hope it is "rsWin1"?

reportViewer1.LocalReport.ReportEmbeddedResource = "rsWin1.rptProductList.rdlc";

If you wish, you can zip the entire project and email it to me at: asif.blog at gmail dot com.

Regards,

Asif

RE: Reporting Services 2005 101 with a Smart Client

Stacy Parrish — Tue, 12 Sep 2006 11:59:00 GMT

I have tried numerous times to resolve the error I am getting with this and put up my watch window and it says my reader object drReport is throwing an exception but the application runs and displays the report viewer with the message "The source of the report definition has not been specified. I am forwarding my code...any help appreciated.

private void Form1_Load(object sender, EventArgs e)

{

//use following if you use standard security

string cnString = @"Data Source= sparrishlpt2\stacy;Initial Catalog=northwind; Integrated Security=SSPI";

//declare Connection, command and other related objects

SqlConnection conReport = new SqlConnection(cnString);

SqlCommand cmdReport = new SqlCommand();

SqlDataReader drReport;

DataSet dsReport = new dsProduct();

try

{

//open connection

conReport.Open();

//prepare connection object to get the data through reader and populate into dataset

cmdReport.CommandType = CommandType.Text;

cmdReport.Connection = conReport;

cmdReport.CommandText = "Select TOP 5 * FROM Products Order By ProductName";

//read data from command object

drReport = cmdReport.ExecuteReader();

//new cool thing with ADO.NET... load data directly from reader to dataset

dsReport.Tables[0].Load(drReport);

//close reader and connection

drReport.Close();

conReport.Close();

//provide local report information to viewer

reportViewer1.LocalReport.ReportEmbeddedResource = "rsWin1.rptProductList.rdlc";

//prepare report data source

ReportDataSource rds = new ReportDataSource();

rds.Name = "dsProduct_dtProductList";

rds.Value = dsReport.Tables[0];

reportViewer1.LocalReport.DataSources.Add(rds);

//load report viewer

reportViewer1.RefreshReport();

}

catch (Exception ex)

{

//display generic error message back to user

MessageBox.Show(ex.Message);

}

finally

{

//check if connection is still open then attempt to close it

if (conReport.State == ConnectionState.Open)

{

conReport.Close();

}

RE: Reporting Services 2005 101 with a Smart Client

Biz — Thu, 07 Sep 2006 19:27:00 GMT

Hi Asif,

I chaged my database name exactly same and it is showing the error again.

any idea,

Bis

RE: Reporting Services 2005 101 with a Smart Client

sqlpro — Wed, 06 Sep 2006 14:48:00 GMT

Yes, am on non-designer surface.

btw when i creating solution i chose "Windows Application" from templates.

does it make any difference ?

btw i need to use it as "Windows Application" bcoz i've other forms ,classess etc., in my solution not just this report.

RE: Reporting Services 2005 101 with a Smart Client

Asif Sayed — Wed, 06 Sep 2006 09:34:00 GMT

Sqlpro,

Please make sure to right-click on non-designer surface.. anywhere on gray area.

Bismi,

Please make sure to have this following fixed:

'dsProduct_DataTable1'

It should be your dataset name and '_' and your datatable name.

Thanks for your feedback

Regards,

Asif

RE: Reporting Services 2005 101 with a Smart Client

Biz — Tue, 05 Sep 2006 22:35:00 GMT

Hi..

Thank you very much for your tutorial. it is very clear ..

But to me.. I am quite new to C#. so I cant get that part.

What I did, i just copied your code to my Form1_load event. Do I have to do anything more to get the class working. Its giving me error like:

at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomParser.CodeTypeDeclarationFromCodeClass(CodeClass vsClass)at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomParser.Parse(TextReader codeStream)at Microsoft.VisualStudio.Design.Serialization.CodeDom.MergedCodeDomParser.System.CodeDom.Compiler.ICodeParser.Parse(TextReader stream)at System.CodeDom.Compiler.CodeDomProvider.Parse(TextReader codeStream)at Microsoft.VisualStudio.Shell.Design.Serialization.CodeDom.CodeDomDocDataAdapter.get_CompileUnit()at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager)at System.ComponentModel.Design.Serialization.BasicDesignerLoader.BeginLoad(IDesignerLoaderHost host)

But I managed to get that error out somehow.

and it is giving me error:

a datasource instance has not been supplied for the data source 'dsProduct_DataTable1'

can u help...

RE: Reporting Services 2005 101 with a Smart Client

sqlpro — Tue, 05 Sep 2006 21:12:00 GMT

Asif

first thank you very much for the nice useful article.

i've one question,you said in ur article that

When new report is added to project, by default, all you will see in report designer is the body section. Right click on report designer surface anywhere other then body and select Page Header.

but if i right click i dont get any option for "page header" !! why ?

btw am using VS2005 standard edition.

RE: Reporting Services 2005 101 with a Smart Client

Asif Sayed — Tue, 05 Sep 2006 13:11:00 GMT

Hi Judie,

Looks like you are having difficulty binding your dataset with the report. Makes sure you have following code done properly:

//prepare report data source

ReportDataSource rds = new ReportDataSource();

rds.Name = "dsProduct_dtProductList";

rds.Value = dsReport.Tables[0];

rpvAbraKaDabra.LocalReport.DataSources.Add(rds);

Make sure the rds.Name property reflect the exact name of your dataset_datatable.

If you don’t mind, you can always send me your code; I can help you debug it. My email: asif.blog@gmail.com

Regards,

Asif

RE: Reporting Services 2005 101 with a Smart Client

Judith Webber — Tue, 05 Sep 2006 12:34:00 GMT

I found this article interesting and so I thought I would give it a go. After working through some connnection and data population issues I have found something I can't seem to get past....I get all the way to the point where the report is going to render and I get the following message where the report should be showing...."A data source instance has not been supplied for the data source". If you have any ideas about what I have done wrong I would love to know because it is bugging me that I can't seem to get something that appears so straghtforward to work. I found several refrences to this on the web but none seemed to help....

Thanks,

Judie

RE: Reporting Services 2005 101 with a Smart Client

Asif Sayed — Tue, 05 Sep 2006 09:39:00 GMT

Vasant,

I am glad that you found the language of article easy. Trust me it is much more challenging to address beginner audience compare to pros.

Kevin,

Yes, you are right. This article is not addressing “server-side” of reporting services. With introduction of VS 2005, Microsoft has empowered developers to design and host reporting services as “client-side” or local. Perhaps report extension .rdlc (c-client?) says it all; on sever-side we continue to have the extension as .rdl.

Please feel free to get in touch, if I can be any help further at: asif.blog@gmail.com

Regards,

Asif

RE: Reporting Services 2005 101 with a Smart Client

Kevin O'Donovan — Tue, 05 Sep 2006 07:20:00 GMT

Am I missing something (like it wasn't meant to be perhaps), or has this not actually got anything to do with report server? I initially saw reporting services 2005 and read it as report server 2005, but this appears to be about the report designer built into VS2005, which is not connected at all with the SQL Server application.Not meant as a criticism, just wondering if I've got the wrong end of the stickKev

RE: Reporting Services 2005 101 with a Smart Client

Vasant Raj — Tue, 05 Sep 2006 01:05:00 GMT

Simple and easy to understand language used...

Good article

Reporting Services 2005 101 with a Smart Client

Asif Sayed — Tue, 29 Aug 2006 09:49:00 GMT

Comments posted to this topic are about the content posted at temp