Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting Services 2005 101 with a Smart Client


Reporting Services 2005 101 with a Smart Client

Author
Message
Asif Sayed
Asif Sayed
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 3
Comments posted to this topic are about the content posted at temp
Vasant Raj
Vasant Raj
SSC Veteran
SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)

Group: General Forum Members
Points: 235 Visits: 137

Simple and easy to understand language used...

Good article


Kevin O'Donovan
Kevin O'Donovan
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

Group: General Forum Members
Points: 41 Visits: 84
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



Asif Sayed
Asif Sayed
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 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


Judith Webber
Judith Webber
SSChasing Mays
SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)

Group: General Forum Members
Points: 645 Visits: 182

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


Asif Sayed
Asif Sayed
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 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


sqlpro
sqlpro
Old Hand
Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)

Group: General Forum Members
Points: 385 Visits: 143
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.




Biz
Biz
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 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...


Asif Sayed
Asif Sayed
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 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


sqlpro
sqlpro
Old Hand
Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)Old Hand (385 reputation)

Group: General Forum Members
Points: 385 Visits: 143
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.




Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search