Wednesday, March 28, 2012
how to assign ado.net dataset as sql report datasource
i dont find how to assign customize dataset to sql report datasource.
plz give me reply ASAPIf your talking about ASP.NET Datasets as the data source of your report you
will have to develope a Custom Data Extension bacause Reporting Services
doesn't support it.
You can find more information about it here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5ug2.asp
Maria Isabel Henao
"sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
news:C6935DE6-C28A-4064-9F33-D805F83C2CEF@.microsoft.com...
> hi,
> i dont find how to assign customize dataset to sql report datasource.
> plz give me reply ASAP|||Thx Maria,
but can i get the sample code or any running application code. i used
an article
http://msdn.microsoft.com/library/default.asp?url=/library/en-2k/html/RSDSetEx3.asp
but when i have implimented this it gives me hostname could not be parsed
error
what can i do'
"Maria Isabel Henao" wrote:
> If your talking about ASP.NET Datasets as the data source of your report you
> will have to develope a Custom Data Extension bacause Reporting Services
> doesn't support it.
> You can find more information about it here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5ug2.asp
> Maria Isabel Henao
>
> "sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
> news:C6935DE6-C28A-4064-9F33-D805F83C2CEF@.microsoft.com...
> > hi,
> >
> > i dont find how to assign customize dataset to sql report datasource.
> > plz give me reply ASAP
>
>|||Looking for the original link I used to build my own dataset extension I
found this one that might be useful for you:
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
"sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
news:342AD658-1664-406C-B18A-2FCBD6361BE2@.microsoft.com...
> Thx Maria,
> but can i get the sample code or any running application code. i used
> an article
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-2k/html/RSDSetEx3.asp
> but when i have implimented this it gives me hostname could not be parsed
> error
> what can i do'
>
>
> "Maria Isabel Henao" wrote:
> > If your talking about ASP.NET Datasets as the data source of your report
you
> > will have to develope a Custom Data Extension bacause Reporting Services
> > doesn't support it.
> >
> > You can find more information about it here:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5ug2.asp
> >
> > Maria Isabel Henao
> >
> >
> > "sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
> > news:C6935DE6-C28A-4064-9F33-D805F83C2CEF@.microsoft.com...
> > > hi,
> > >
> > > i dont find how to assign customize dataset to sql report
datasource.
> > > plz give me reply ASAP
> >
> >
> >
Wednesday, March 21, 2012
How To add the value of a variable to column in a DataSet
Hi,
i'm working on a Data Flow which uses a "Flat Sile Source" to read a CSV-file and then sends the transformed data to a "OLE DB Destination".
What i need is a way to add a column to my transformed data which contains a value from a User-Variable.
My User-Variable contains the key for the data, and this one value shall replicate to all Rows in the DataSet.
So anybody know of an existing Data Flow component, which can do this?
Regards, Martin
How about the Derived Column component? Or have I completely misunderstood the point?
Ed
|||The Derived Column did exactly what i needed - thanks for the help!
How To add the value of a variable to column in a DataSet
Hi,
i'm working on a Data Flow which uses a "Flat Sile Source" to read a CSV-file and then sends the transformed data to a "OLE DB Destination".
What i need is a way to add a column to my transformed data which contains a value from a User-Variable.
My User-Variable contains the key for the data, and this one value shall replicate to all Rows in the DataSet.
So anybody know of an existing Data Flow component, which can do this?
Regards, Martin
How about the Derived Column component? Or have I completely misunderstood the point?
Ed
|||The Derived Column did exactly what i needed - thanks for the help!
Friday, March 9, 2012
How to add Drill down option in the Dataset ( + )
Dear Friends,
I have created a Dataset and displayed in the report. In the report, its showing as expanded values by default. There is no option for me to Collapse and Expand.
If I create a Table with Report Wizard, I am getting the Collapse & Expand ( + ) option in the report.
Is there anyway, I can add the Collapse / Expand in the Dataset kind of reports.
Thanks.
Warm Regards
Rakin
Singapore.
If you investigate the report that is generated through the report wizard, you will notice that the toggle-effect is achieved by setting the Visibility property e.g. of table rows to be toggled by a certain other textbox.
Please also check RS BOL for more information how to add toggles in report designer: http://msdn2.microsoft.com/en-us/library/ms156456.aspx
-- Robert
|||Thanks Robert.
Now I am able to do that. It works fine.
Regards
Rakin.
Wednesday, March 7, 2012
How to add an image dynamically using an URL
and file names of a group of GIF images from a database table, and (2)
dynamically construct an URL for each images, and finally (3) using the
URLs to dynamically add the images into the report pages.
Since I have millions of images stored in a virtual directory, I cannot
add them all into my report project.
Thanks in advance if anybody have any solution and can share it with
me!
TommyYou will need SP1 of RS 2000 which supports retrieving "external" images
through http://. Check section 4.1.4 of the SP1 readme for details.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tommy" <qtao@.doe.k12.de.us> wrote in message
news:1114002588.814601.73710@.g14g2000cwa.googlegroups.com...
>I need to generate a report which (1)using a dataset to get the path
> and file names of a group of GIF images from a database table, and (2)
> dynamically construct an URL for each images, and finally (3) using the
> URLs to dynamically add the images into the report pages.
> Since I have millions of images stored in a virtual directory, I cannot
> add them all into my report project.
> Thanks in advance if anybody have any solution and can share it with
> me!
> Tommy
>
How to add a new column to a Dataset
I have had to add a new column to a mobile 5 database in VS2005. I obviously have added it in the wrong way. I have two applications that use the same db. The .net application accesses the table with the new column fine., this is where I added it first. When I try to add the column to the Compact framework (Pocket Pc) app I get this error when I try to run the application. In both applications the Server explorer shows the new column.
The column name is not valid. [ Node name (if any) = ,Column name = GUID ]
As long as I remove the GUID column from the tableadapter.fill sql the program runs the same as before.( even though the sql executes in the query designer with the GUID column in the sql statement.)
How do I add the column so that the Dataset.designer.cs gets updated and can load the new column?
Thanks I hope this make sense.
Jon Stroh
Rename the column to something other than "GUID"...
Friday, February 24, 2012
How to add a calcualted field in Matrix?
Hello.. I would like to know how this can be done in RS (SQL2000)...
In the dataset I have... sales, company, and year. What I want to display is such...
2005 2006 Growth
companyA $1,000,000 $500,000 100%
companyB $50,000 $100,000 -50%
How do I add a column in a Matrix to calculate the growth based on the sales? Thanks!
-Joseph
you would have to add growth to your dataset as a calculation in of the years. So for MDX you would add a calculated member to the time dimension and calculate growth in that.Sunday, February 19, 2012
how to access sum(Some_Column) in SQL
total value to the original one. (So I could pass this new dataset into a bar
chart to plot)
I know the sum(Some_column) is in the report domain, since we can access
this value in designer. But my question is how can I pick it out using SQL
statement to build another dataset. Or if there is better way to construct
the new dataset.
Micosoft gurus, please help. I am doing a consulting project at client side
for MS. Do not want to blow this one :)
--
SincerelyHave you tried using the ReportItems collection to reference the sum
field,and use it as a parameter into the other query?
ie
ReportItems!Textbox1.Value
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:7D89CBF3-D016-459F-B3F3-B1FC58DE3B3A@.microsoft.com...
> I am trying to build a new dataset based on existing set, by appending a
> total value to the original one. (So I could pass this new dataset into a
bar
> chart to plot)
> I know the sum(Some_column) is in the report domain, since we can access
> this value in designer. But my question is how can I pick it out using SQL
> statement to build another dataset. Or if there is better way to construct
> the new dataset.
> Micosoft gurus, please help. I am doing a consulting project at client
side
> for MS. Do not want to blow this one :)
> --
> Sincerely
How to Access SqlDataSource Fields from Code?
I have <asp:SqlDataSource> in aspx page that is being used by an updateable GridView. However, there are a couple fields in the dataset that contain filenames that I want to access directly in code and place them into some image tags on the page.
This line should give me access to the dataset but how to I access the fields?
Dim myDataSourceAs DataView =DirectCast(SqlDataSourceGridView.[Select](DataSourceSelectArguments.Empty), DataView)
When the SqlDataSource is a DataReader I would access it with the code below but since this SqlDataSource is a DataSet I can't access it with this code.
If myDataSource.ReadThen
If Convert.IsDBNull(myDataSource("CusAgentPhoto"))Then
ImageAgent.ImageUrl ="/photos/nophoto.gif"
Else
ImageAgent.ImageUrl = AgentImagePath & myDataSource("CusAgentPhoto").ToString
EndIf
IfConvert.IsDBNull(myDataSource("CusCompanyLogo"))Then
ImageCompany.ImageUrl="/photos/nophoto.gif"
Else
ImageCompany.ImageUrl=OfficeImagePath & myDataSource("CusCompanyLogo").ToString
EndIf
End If
What would be the correct way to get at the DataSet fields that contain the filenames?
Programmatically accessing values from datasource controls:http://www.mikesdotnetting.com/Article.aspx?ArticleID=45
Also, How to conditionally show an image:http://www.mikesdotnetting.com/Article.aspx?ArticleID=18
|||That was the info I needed. Excellent reference!