Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Reporting Services 2005 101 with a Smart Client Expand / Collapse
Author
Message
Posted Tuesday, August 29, 2006 9:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2008 2:21 PM
Points: 18, Visits: 3
Comments posted to this topic are about the content posted at temp
Post #304698
Posted Tuesday, September 5, 2006 1:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136

Simple and easy to understand language used... 

Good article

Post #306184
Posted Tuesday, September 5, 2006 7:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 5, 2013 4:35 AM
Points: 31, Visits: 79
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 stick

Kev



Post #306246
Posted Tuesday, September 5, 2006 9:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2008 2:21 PM
Points: 18, Visits: 3

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

Post #306309
Posted Tuesday, September 5, 2006 12:34 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 8:22 AM
Points: 645, Visits: 180

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

Post #306378
Posted Tuesday, September 5, 2006 1:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2008 2:21 PM
Points: 18, Visits: 3

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

 

Post #306380
Posted Tuesday, September 5, 2006 9:12 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 4:22 PM
Points: 360, Visits: 102
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.



Post #306450
Posted Tuesday, September 5, 2006 10:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, August 31, 2014 10:45 PM
Points: 65, Visits: 300

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...

 

 

Post #306464
Posted Wednesday, September 6, 2006 9:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2008 2:21 PM
Points: 18, Visits: 3

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

Post #306571
Posted Wednesday, September 6, 2006 2:48 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 4:22 PM
Points: 360, Visits: 102
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.



Post #306703
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse