Repeater - Multiple Datasources?

Jun 4, 2008

I need to set a Repeater.Datasource to one of three stored procedures depending on what button the user selects.  How do I set it up please?

<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ABCConnectionString %>"
SelectCommand="???????????????" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="???????????????????" Name="?????????????" PropertyName="Text" Type="string" />
</SelectParameters>
</asp:SqlDataSource>

 protected void btnKeyWordSearch_Click(object sender, ImageClickEventArgs e)
{
    mode = 1;
    StoredProcdureName = "KWSearch";
    KWords = tbxKWordText.Text;
}
protected void btnCompanyNameSearch_Click(object sender, ImageClickEventArgs e)
{
    mode = 1;
    StoredProcdureName = "NAMESearch";
    CoName = tbxCoNameText.Text;
}
protected void btnBrandNameSearch_Click(object sender, ImageClickEventArgs e)
{
    mode = 1;
    StoredProcdureName = "BRANDSearch";
    Brand = tbxBrandText.Text;
}

View 1 Replies


ADVERTISEMENT

Query Multiple Datasources

Sep 7, 1999

Does anyone know of a tool or method that would allow me to join MS SQL and Oracle 7.3 tables for a query?

View 2 Replies View Related

Using Multiple Datasources In A Dataset

Jan 30, 2007

Hi,

I have to design a tabular report where the data in all the columns of the table comes from the cube, but for one column where the data comes from the ODS table.

Could anyone please let me know if it is possible to combine the results of the query from a cube with query from an ODS table and display together in a single report?

Any thoughts on this would be greatly appreciated

Thanks.

View 1 Replies View Related

Problem With Repeater

Sep 21, 2006

I'm new to ASP.NET and i've been banging my head aganist this problem for a few days now.I have a repeater and then a repeater inside that repeater. <asp:SqlDataSource ID="sqlRepeater1" runat="server" ConnectionString="<%$ ConnectionStrings:Inspections_DBCS %>" SelectCommand="SELECT count(*) as mycount FROM insuranceco with (NOLOCK) where insurancecoid=@insurancecoid" OnSelecting="sqlRepeater_Selecting" > <SelectParameters> <asp:Parameter DefaultValue='' Name="insurancecoid" Type="String" /> </SelectParameters> </asp:SqlDataSource> <% 'sqlRepeater1.SelectParameters["insurancecoid"].DefaultValue = "123"; %>This returns:Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30451: Name 'sqlRepeater1' is not declared.Source Error:Line 38: Line 39: <% Line 40: sqlRepeater1.SelectParameters["insurancecoid"].DefaultValue = "123";Line 41: %>Line 42: I tried a solution i saw on the web about using the onselecting event but that didn't pan out either Protected Sub sqlRepeater_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) 'Handles sqlRepeater1.Selecting WithEvents 'Response.Write(e.Command.Parameters.Add) 'e.Command.Parameters.Add(e.Command.CreateParameter("P1", "test")) 'e.Command.Parameters.Add("P1", "value")I have to be doing something wrong because i would think there has to be a way to reference variables when you are going from repeater to repeater i just dont know.Please help my mask of sanity is starting to slip off.Thanks

View 4 Replies View Related

Linq-to-SQL And ASP:Repeater

May 25, 2008

Hi there,
In 2005.NET, if I used an asp:repeater, I would load the data from source and then manipulate it like so://load the data from source using a predefined connection and SQL Statement.private void LoadMyDataFromSource(){        try        {            connection.Open();            OleDbDataReader myReader = comm.ExecuteReader();                        rptrCatList.DataSource = myReader;            rptrCatList.DataBind();             myReader.Close();           }        finally        {            connection.Close();        }} //catch the ItemDataBound event and manipulate the data how I wish before it's loaded into the Repeater.protected void rptrCatList_ItemDataBound(object sender, RepeaterItemEventArgs e)      {        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)        {            int title = 4; //this is the index of the column I wish to manipulate((Label)e.Item.FindControl("lblTitle")).Text = ((IDataRecord)e.Item.DataItem).GetString(title) + ":"       }   }This would give me all the flexbility I ever needed. But now I wish to use linq and since the IDataRecord relies on dataReader sources, I cannot obtain the same flexbility. Can anyone point me in the right direction for obtaining the same kind of flexbility but using a linq-to-SQL dataContext? I wish to manipulate mostData that comes through from my source, so: //loadng the data in via my linq-to-sql context.private void LoadProducts()    {        MyDataContext db = new MyDataContext ();        var all = from p in db.Products_IncontinenceStandards                  where p.Product_Cat == "Category1"                  select p;        rpterCat.DataSource = all;        rpterCat.DataBind();    }This is where I get stuck because, even though I can still capture the ItemDataBound event since I have databound the Repeater to the linqSource, I can't access the individual fields (or this is what I think I can't do!), Does anyone know how to relate to this so I can create the same effect? Many Thanks,Nathan Channon
 

View 4 Replies View Related

How To Take Single Value From Sql Query For Repeater ?

Oct 29, 2006

So I have code to fill my repeater with a data: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        Dim cnn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings("db_ConnStr").ConnectionString)        Dim cmd1 As Data.SqlClient.SqlDataAdapter = New Data.SqlClient.SqlDataAdapter("SELECT aspnet_Users.UserName, COUNT(forum_posts.post_id) AS IlePost, forum_posts_1.post_content, forum_posts_1.topic_id, forum_posts_1.post_id, forum_posts_1.post_date FROM aspnet_Users INNER JOIN forum_posts ON aspnet_Users.uID = forum_posts.user_id INNER JOIN forum_posts AS forum_posts_1 ON aspnet_Users.uID = forum_posts_1.user_id GROUP BY aspnet_Users.UserName, forum_posts_1.post_content, forum_posts_1.topic_id, forum_posts_1.post_id, forum_posts_1.post_date HAVING (forum_posts_1.topic_id = @topic_id) ORDER BY forum_posts_1.post_date ASC", cnn)        cmd1.SelectCommand.Parameters.AddWithValue("@topic_id", Request.QueryString("ID"))        Dim ds As Data.DataSet = New Data.DataSet        cnn.Open()        cmd1.Fill(ds, "posts")        Repeater1.DataSource = ds.Tables("posts")        Page.DataBind()        cnn.Close()    End Sub And I want to take the value from column which I bolded - IlePost. I want take this out at compare with some condition. For example:Dim label as label = Repeater1.Findcontrol("Label1")If COLUMN < 10 thenlabel.text = "Less than 10"elselabel.text = "More than 10"I hope you understand me :-) 

View 1 Replies View Related

Nested Repeater Query

Mar 11, 2007

Hello Everyone,I am trying to create a query for the purpose of a nested repeater relation. The information needs to be pulled from one table. I have shortened the columns to the ones that are required.table - PagesIDPageNameParentPageIDSo, take the following example:ID 14, PageName - Service A, ParentPage ID = 6ID 15, PageName - Service B, ParentPage ID = 6ID 36 PageName - Client 1, ParentPage ID = 14ID 37 PageName - Client 2, ParentPage ID = 14ID 38 PageName - Client 3, ParentPage ID = 15ID 39 PageName - Client 4, ParentPage ID = 15 So, I want to create a query that will get my nested repeater to display as follows:Service A    Client 1    Client 2Service B    Client 3    Client 4What I have come up with so far is:SELECT * from tbl_Pages WHERE ParentPageID IN  (Select ID From tbl_Pages)SELECT p.ParentPageID, p.PageName, p.ID FROM tbl_Pages pThe relation would be based off ParentPageID. I keep getting errors that either there is no unique value or the relation is null. What am I am missing here? 

View 5 Replies View Related

Identifying The Servercontrol In Repeater

Jun 15, 2007

Hell Sir,
   I am using  repeater control to show the result after search .and using checkbox control in itemtemplate row .After searchresult i am facing a problem in identifying the checked checkboxes in the itemtemplate of repeater control .
Please provide appropriate solution ....
                                                    thanks for ur attention...

View 3 Replies View Related

Basic SQL Question And ASP.net Repeater

May 14, 2008

Hi,

I'm coming from a language called Progress and need some basic help with SQL and ASP.net

Here's my item table from database with 6 recordscolor fruit

red applered bananared cherryblue appleblue bananablue cherry

My goal is to put in HTML tables like so..



red





apple
banana
cherry









blue





apple
banana
cherry

I was going to use the ASP.net Repeater control by doing with some SQL statement that will produce this 6 records with a calculated field..
color fruit firstColorInFruitGroupred apple yesred banana nored cherry noblue apple yesblue banana noblue cherry no
So basically when I see a yes thats when I know its a <TH>"heading" 
When I see a no, thats when I see that its a <TD> "data" 
How would I write this SQL statement? or is there a better way of doing this? Thanks much! 
  

View 7 Replies View Related

Need SQL To Perform Repeater Paging

Feb 15, 2005

I want to build some paging functionality into my repeater (b4 you ask, datagrid not providing flexibility required for presentation).

I will have no problem with the VB logic but I will need to execute SQL that only returns results from x to y (e.g. results 21 thru 40 for page 2). I know I can do something like 'SELECT TOP 20 * FROM...', or something like it, for page 1. But, I'm not sure if it's possible to build SQL for the pages greater than 1. Any suggestions.

Thanks
Martin

View 1 Replies View Related

Repeater And Stored PRocedure

Aug 29, 2005

Q1 - I want to compare file names uploaded by users with the name of the file present in the database. I have a repeated control that shows the data alongwith an array of <input type=file> that is createddynamically when the data is displayed in the repeater control. (So there is an input tag within the ItemTEmplate tag in the repeater)Now I want to compare the names of the files uploaded by the user with the values as displayed in the repeater. Is there a way I can do this? So I need to be able to get the data (for example Name) as displayed in the repeater control into a variable like Dim strName As String. Something like: Dim strName As String = (value from the repeater control) Can I do this? How?
Q2 - I want to return a value from a stored procedure that will be stored in a variable in VB and will be used for comparison. So, I want to return a 0 or 1 and then use .ReturnValue method to store this value. The problem that I am facing is that I am using a cursor. And as soon as return is called in the SP it exitsthe procedure and returns only one value (1 if found 0 otherwise) So it does not loop through the completecursor. What can I do to fix this? CODE:
OPEN cur1--print 'Cursor Open'FETCH NEXT FROM cur1 INTO @varFile, @varFileEx, @varFileSt
WHILE @@FETCH_STATUS = 0BEGINIF (@varFile = @FileName AND @varFileEx = @FileExt)BEGINset  @varReturn = 0ENDELSE BEGINset @varReturn = 1ENDFETCH NEXT FROM cur_FileSystem INTO @varFileName, @varFileExt, @varFileStatusreturn (@varReturn)ENDCLOSE cur_FileSystemDEALLOCATE cur_FileSystem
Please help. Thanks

View 2 Replies View Related

Help With UPDATE With SqlDataSource And A Repeater

Jan 15, 2006

Hi,
I have a repeater which i need to build editing capabilities into in a similar way as the GridView, just a little unsure how to tie it together.  Ideally i would like to use a GridView as this would do all of the work for me however it looks like I need to go with the repeater due to the nested nature of the data I am working with.
What is the best way to go about updating the data source from within a repeater?  I have already built the edit interface with some MultiViews in the Repeater control and handling the ItemCommand event, just not sure how to actually update the data source.
Can I still use the SqlDataSource wizard to generate all of the SQL for me?  If so, within the ItemCommand event handler I have the data i want to update back to the database by using the FindControl method and retrieving the Text, but how do i get this data into the SqlDataSource object and update the database?
Are there any samples available which show how to update a datasource using a repeater?
Your help is much appreciated
trenyboy

View 6 Replies View Related

Whats Wrong With Following Repeater And Sqldatasource?

Dec 6, 2006

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.  
 original source code
 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>" SelectCommand="SELECT [authorID], [firstname] FROM [author] where id=1" ></asp:SqlDataSource>
<asp:Repeater ID="rpt" DataSourceID="SqlDataSource1" runat="server">
<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Style="z-index: 100; left: 65px; position: absolute;
top: 59px" Text='<%# authorID %>' ></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server" Style="z-index: 101; left: 66px; position: absolute;
top: 96px" Text='<%# firstName %>'></asp:TextBox>
</ItemTemplate>
</asp:Repeater>
 
<asp:Button ID="Button1" runat="server" Style="z-index: 102; left: 46px; position: absolute;
top: 164px" Text="next" />
<asp:Button ID="Button2" runat="server" Style="z-index: 103; left: 102px; position: absolute;
top: 163px" Text="first" />
<asp:Button ID="Button3" runat="server" Style="z-index: 104; left: 156px; position: absolute;
top: 162px" Text="prev" />
<asp:Button ID="Button4" runat="server" Style="z-index: 106; left: 208px; position: absolute;
top: 162px" Text="last" />
 
</div>
</form>
Compiler Error Message: CS0103: The name 'authorID' does not exist in the current contextSource Error:





Line 13: <asp:Repeater ID="rpt" DataSourceID="SqlDataSource1" runat="server">
Line 14: <ItemTemplate>
Line 15: <asp:TextBox ID="TextBox1" runat="server" Style="z-index: 100; left: 65px; position: absolute;
Line 16: top: 59px" Text='<%# authorID %>' ></asp:TextBox>
Line 17: <asp:TextBox ID="TextBox2" runat="server" Style="z-index: 101; left: 66px; position: absolute;

View 1 Replies View Related

Check For Null In Repeater Date Field

Jan 27, 2008

I'm about ready to pull my hair out.  I have a repeater control, and a date field.  If the field is a valid date, I'll use it to calculate and display the person's age.  Otherwise, I want to display "N/A".  My problem is trying to determine if the date field is null or not.I'm using SQL Server 2005 which allows Nulls in the date field, and for many records I don't have a birth date.  It makes sense for these records to leave the date Null.  This is my code:Protected Sub Repeater1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles Repeater1.ItemDataBound    If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType = ListItemType.AlternatingItem Then        Dim LabelIcon As Label = CType(e.Item.FindControl("LabelIcon"), Label)        Dim LblAge As Label = CType(e.Item.FindControl("LblAge"), Label)        Dim inmate As WAP.prisonmembersRow = CType(CType(e.Item.DataItem, System.Data.DataRowView).Row, WAP.prisonmembersRow)        If System.IO.File.Exists(Server.MapPath("~/images/picts/" & inmate.FILE2 & ".jpg")) Then            LabelIcon.Visible = True        End If        If inmate.DATE_OF_BIRTH Is DBNull.Value Then            If IsDate(inmate.DATE_OF_BIRTH) Then                LblAge.Text = "Age: N/A"            Else                LblAge.Text = "Age: " & GetBirthdate(inmate.DATE_OF_BIRTH)            End If        End If    End IfEnd Sub How can I resolve this?Diane 

View 7 Replies View Related

Using Date Field In Search String To Bind To Repeater

Apr 5, 2004

i am trying to search an SQL database to retrieve all names from employee table who have a birthday today. this needs to automatically fill in the date parameter with the system date. this is what i have so far:


sub page_load(sender as object, e as eventargs)
dtmDate=DateTime.Now.ToString("M")
con = New SqlConnection("Server=Localhost;UID=******;PWD=*****;Database=Pubs")

cmd = New SqlCommand("Select fname, lname From Employee where dob='& dtmDate'", con)

con.open()
dtrBday = cmd.ExecuteReader()

rptBday.DataSource=dtrBday
rptBday.DataBind()
dtrBday.Close()



I know this isnt quite right. i get errors when it hits my repeater.

the error i am getting is :Syntax error converting string to smalldatetime data type.
if someone could give me a push in the right direction here it would be greatly appreciated.

View 2 Replies View Related

Cannot See Shared Datasources

Apr 9, 2008

I am new to reporting services, working with RS2000. Roles and security have previously been set up.

Shared Datasources have been created. How is access granted to shared datasources?


Some users have access but we haven't been able to create new users with access to the shared datasources.

Thanks

View 1 Replies View Related

How Do I Join Two OLE Datasources

Apr 16, 2008



One being a query which sums up claims for a group of members. Col A beign the memberID and B and C being amounts.

Now I set the output to Isosrted = true and set the output column A sorted property to 1.

The other OLE source is a table. Col A being member and b,c,d.. being name, address...
I set the same properties for column a and I am trying to use a merge join.

The first two sources return 2245 rows and after the merge I end up with 648.

What would cause the merge to strip some records out?

Thanks.

View 5 Replies View Related

SSIS And Datasources

Feb 12, 2007

I have several SSIS packages which I have setup using a datasource to connect to the database. I should be able to switch between databases by just changing the server and database on the datasource but for some reason the ssis package keeps on using the old database. I have the connection managers setup to reference the datasource and can see the connection manager pointing to the new database but when I run a task by right clicking on it and choosing execute task it calls the stored procedure in the old database. I know it is doing this because I renamed the stored procedure in the old database and the task errored out saying it could not find the stored procedure. Can someone please tell me what I am doing wrong?

View 4 Replies View Related

Dynamic Report With Several Datasources

Feb 15, 2007

Hello,

I am currently working with SQL 2005 Reporting Services and MS Visual studio 2005.

In my SQL server I have data about organizations, so that each organization's data is stored in an individual database.
In addition, the number of organizations/databases is variable. I know the number of organizations and the name of each one (that it agrees with the name of its database)
because there is a database (organizationsDB) with a table (organizationsTB) containing the list of the organizations.

So, It would be possible to create a report containing a summary of each organization? .... for example a table in which each row contains data of each organization.

Could you give me any ideas?

Thanks in advance!

View 4 Replies View Related

OLEDB Datasources And Parameters

Feb 1, 2006

I have discovered some shortcomings in the way inline table valued function parameters are treated in the OLEDB datasource. You can select the user designed function ine the Generic Query Builder and test it with the required parameters. However when you attempt to set up the parameters for the result ing SQL Command Text you get and error message to the effect that the parameters cannot be retrieved from the datasource. Once again this is disappointing because Report Services seems to deal with the parameters perfectly well.

Dick Campbell

View 2 Replies View Related

One Or More DataSources Is Missing Credentials

Dec 14, 2006

Get this when selecting parameter value in Report Manager

Report is working fine in preview







Up to me, it has nothing to do with credentials

I have some analysis server reports.

I have a single value report parameter, the report runs fine with the default value, when I select another value than the default one, I get above message immediately.

I got the error since I rebuild the report with SP2 CTP.

Strange thing is that the other single value parameter of the report works fine (year)

And that I get the error also with other reports, and on the same dimension (Organisation)

And that I do not have the error when I change the parameter to multi-value (but as the report is not written for multiple values...)



MDX queries are as follows:

SELECT NON EMPTY { KPIValue("KPINewBiz"), KPIGoal("KPINewBiz"), KPIStatus("KPINewBiz"), KPITrend("KPINewBiz") } ON COLUMNS,

NONEMPTY

([Reps].[Organisation].[Organisation].ALLMEMBERS

*[Reps].[Rep].[Rep].ALLMEMBERS

*[Date].[Year].[Year].ALLMEMBERS

*[Date].[Month].[Month].ALLMEMBERS

,[Measures].[Gross Sales]

)

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM ( SELECT ( STRTOSET(@ByYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ByOrganisation, CONSTRAINED) ) ON COLUMNS FROM [Sales])) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS



WITH MEMBER [Measures].[ParameterCaption] AS '[Reps].[Organisation].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Reps].[Organisation].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Reps].[Organisation].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,

NONEMPTY([Reps].[Organisation].[Organisation].ALLMEMBERS,[Measures].[Gross Sales]) ON ROWS FROM [Sales]

WITH MEMBER [Measures].[ParameterCaption] AS '[Date].[Year].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Date].[Year].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Date].[Year].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , NONEMPTY([Date].[Year].[Year].ALLMEMBERS,[Measures].[Gross Sales]) ON ROWS FROM [Sales]

Discovered something else that is very strange, you change the value of the parameter, you get the error, you hit the back button, and you can run the report with the new parameter



Did one more test, changed the order of the parameters, is now going wrong on the other parameter, Year.

So, it is always on the first parameter.

Correction, I have put a multi-value parameter as first, I still have the problem, it is always on the first single value parameter
























I have the same problem.

Up to me, it has nothing to do with credentials

I have some analysis server reports.

I have a single value report parameter, the report runs fine with the default value, when I select another value than the default one, I get above message immediately.

I got the error since I rebuild the report with SP2 CTP.

Strange thing is that the other single value parameter of the report works fine (year)

And that I get the error also with other reports, and on the same dimension (Organisation)

And that I do not have the error when I change the parameter to multi-value (but as the report is not written for multiple values...)



MDX queries are as follows:

SELECT NON EMPTY { KPIValue("KPINewBiz"), KPIGoal("KPINewBiz"), KPIStatus("KPINewBiz"), KPITrend("KPINewBiz") } ON COLUMNS,

NONEMPTY

([Reps].[Organisation].[Organisation].ALLMEMBERS

*[Reps].[Rep].[Rep].ALLMEMBERS

*[Date].[Year].[Year].ALLMEMBERS

*[Date].[Month].[Month].ALLMEMBERS

,[Measures].[Gross Sales]

)

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM ( SELECT ( STRTOSET(@ByYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ByOrganisation, CONSTRAINED) ) ON COLUMNS FROM [Sales])) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS



WITH MEMBER [Measures].[ParameterCaption] AS '[Reps].[Organisation].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Reps].[Organisation].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Reps].[Organisation].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,

NONEMPTY([Reps].[Organisation].[Organisation].ALLMEMBERS,[Measures].[Gross Sales]) ON ROWS FROM [Sales]

WITH MEMBER [Measures].[ParameterCaption] AS '[Date].[Year].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Date].[Year].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Date].[Year].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , NONEMPTY([Date].[Year].[Year].ALLMEMBERS,[Measures].[Gross Sales]) ON ROWS FROM [Sales]

Discovered something else that is very strange, you change the value of the parameter, you get the error, you hit the back button, and you can run the report with the new parameter


View 3 Replies View Related

Joining Across Datasources In Ssrs

Apr 3, 2008



is there a way to bring in oracle and sql tables into the same report and join them together on common fields? also, if this is possible, i am trying to join them in the native UI and not the generic query designer mode.

i am hoping that through fully qualifying the tables as you bring them in, that this may be possible.
any suggesions would be greatly appreciated...

thanks!

-dk

View 3 Replies View Related

Combine 2 Datasources In One Report?

May 4, 2007

I have loaded up the newest latests, greatest Visual Studio, SQL reporting etc. I have a need to pull in data from multiple sources. Currently I have DTS packages I have to run to dump information into 1 data source to report on. Has anybody figured out a way to have multipled data sources available when in the query builder?



I am scratching my head on this one.

View 5 Replies View Related

Error When Trying To Create Datasources

Jan 19, 2006

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

View 3 Replies View Related

An SQLDataSource On 2 Other DataSources? Show In A GridView

May 19, 2008

Hi,I have two SQLDataSources called "LeagueTableHome" an "LeagueTableAway" on my page.
I want to create another SQLDataSource called "LeagueTableTotal" on my page which adds up all the totals from each of the other two sources.
The datasource looks like this:
Team, Pld, W, D, L, F, A, Agg, Pts
my code for LeagueTableHome looks like this:
SELECT HomeTeam, 1 AS Pld, CASE WHEN HomeScore > AwayScore THEN 1 ELSE 0 END AS Won, CASE WHEN HomeScore = AwayScore THEN 1 ELSE 0 END AS Draw, CASE WHEN HomeScore < AwayScore THEN 1 ELSE 0 END AS Lost, HomeScore AS Scored, AwayScore AS Against, HomeScore - AwayScore AS Agg, CASE WHEN HomeScore > AwayScore THEN 3 ELSE 0 END AS Pts FROM tblFixtures WHERE (CompID = 1) AND (HomeScore IS NOT NULL)
I want then to show LeagueTableTotal in a GridView.
Can anybody help?
 

View 4 Replies View Related

Custom Component: How Can I Have Two Input Datasources?

Mar 27, 2008

Hi all. Can you help me? I'm trying to build a custom component that recieves two datasources (like for instance the union all) . I first started by adding a new IDTSInput90 in the ProvideComponentProperties, but when I tried to use the component I got an error that has very helpful :

===================================

The component could not be added to the Data Flow task.
Could not initialize the component. There is a potential problem in the ProvideComponentProperties method. (Microsoft Visual Studio)

===================================

Error at Data Flow Task [Replica Transformation [1289]]: System.Runtime.InteropServices.COMException (0xC0048004): Exception from HRESULT: 0xC0048004
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutputCollection90.get_Item(Object Index)
at MyCustomSSISComponent.SampleComponentComponent.ProvideComponentProperties()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProvideComponentProperties(IDTSManagedComponentWrapper90 wrapper)


===================================

Exception from HRESULT: 0xC0048004 (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProvideComponentProperties(IDTSManagedComponentWrapper90 wrapper)
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ProvideComponentProperties()
at Microsoft.DataTransformationServices.Design.PipelineTaskDesigner.AddNewComponent(String clsid, Boolean throwOnError)

This is my ProvideComponentProperties:





Code Snippet

public override void ProvideComponentProperties()
{
RemoveAllInputsOutputsAndCustomProperties();

ComponentMetaData.UsesDispositions = true;

IDTSInput90 input = ComponentMetaData.InputCollection.New();
input.Name = "Staging Data";
input.ErrorRowDisposition = DTSRowDisposition.RD_FailComponent;

IDTSInput90 input2 = ComponentMetaData.InputCollection.New();
input2.Name = "Replica Data";
input2.ErrorRowDisposition = DTSRowDisposition.RD_FailComponent;

// Add the output
IDTSOutput90 output = ComponentMetaData.OutputCollection.New();
output.Name = "Replica Output";
output.SynchronousInputID = input.ID;
output.ExclusionGroup = 1;

// Add the error output
AddErrorOutput("StagingErrorOutput", input.ID, output.ExclusionGroup);

// Adds columns
AddXmlColumn();

IDTSOutputColumn90 column0 = ComponentMetaData.OutputCollection[1].OutputColumnCollection.New();
column0.Name = m_SyncStatusColumnName;
column0.SetDataTypeProperties(DataType.DT_STR, 1, 0, 0, 1252);

IDTSOutputColumn90 column1 = ComponentMetaData.OutputCollection[2].OutputColumnCollection.New();
column1.Name = m_AS400ImportedDateColumnName;
column1.SetDataTypeProperties(DataType.DT_DATE, 0, 0, 0, 0);

}

Since I'm new to SSIS I'm following Josh's SSIS Xmlify Data Flow Task sample.

Thanks.

View 3 Replies View Related

Reporting Services Variable Datasources

Dec 20, 2006

I need to create a report with variable datasources. Any one knows the best way to do that?

When I try creating variables on the select statement of the dataset it errors out.

I I trayng something like this: select * from @server.@database.dbo.errorlog but It does not recognize the variables. Any suggestions??

View 3 Replies View Related

XML Datasources : Datasets Don't Find All The Nodes

Nov 20, 2007

Hello,


we use SQL Server 2005 Reporting Services with XML Datasources, but we have the following issue :


with a xml like this :
<Root>

<A>a</A>
<B>b</B>
<L>Item 1</L>
<L>Item 2</L>
<C>c</C>
</Root>


If we use the query Root, the resulting dataset is :
A B C
a b c

But with this query : Root/L, the dataset is :
L A B
Item 1 a b
Item 2 a b

The dataset doesn't find the "C" node.

Anyone have an idea ?

PS : I don't control the xml structure, so I can't displace the "C" node.

View 1 Replies View Related

Configuring SSRS Datasources With Different Domain Credentials

Dec 17, 2007

We are having our SSRS (Sql Server Reporting Services) Servers deployed in Domain1 to connect to the Domain1 data sources. Now, when we configure the SSRS datasources (which is in Domain1) to run under €œDomain2/User€? credentials , it€™s taking 60 minutes to render a report whereas when we configure the SSRS datasources to run under €œDomain1/User€? account it€™s taking only 5 seconds.

I would like to know €œWhy there is a latency difference while configuring the SSRS data sources with different domain credentials (Domain1Domain2)?€?

Any pointers to Support KB or any other related articles would be really great.

View 2 Replies View Related

SSRS Report Deployment And Shared Datasources

Mar 12, 2008

Hi,

I have got a quistion in regards to SQL Server Reporting Services 2005. We're currently using the SSRS in one of our applciations with 20+ reports. We need to deplaoy 2 instances of an applciation: Test and Production. These applcaitions are running off two different databases in SQL Server [DBName]_Test and [DBName]_Live. So far all of our reports have been written to use a shared datasource. This worked fine untill we had to deploy a Live instance of the application, where the shared datasource is overwritten with the live one.

Now we have manually created a new shared datasource called [DataSource]_Live. However, whenever we need to redeploy the reports from visual studio, we then have to go though each report and point it to a correct datasource. This is extremly manual process - and takes up a lot of time...

Surely there must be an easier way around this (without duplicating the reporting project in VS.NET / or having to modify the datasource fr each report manually each time)?

Thanks in advance,
Nick Goloborodko


View 2 Replies View Related

SQL Server Compact Edition Is Not In The List Of DataSources

Jan 19, 2007

Hi everyone, I am using VS2005, just installed SP1, and the help -> about window reflects this. I have also installed the SQL Server Compact Edition SDK, but when i try to add a new data source connection (following the MANY tutorials on this), i do not see an option for SQL Server Compact Edition nor do i see an option for SQL Server Mobile. I am at my wits end and i just got started! Yikes... Any thoughts on how to proceed?

View 17 Replies View Related

Dynamicly Load Tables For DataSources/DataDestinations

Apr 1, 2006

Hi everybody,

The names of the tables that sould be transfered from the production system to the DWH are stored in a table in the production system. Yet I haven't found a proper way to dynamicly define these tables as DataSources and DataDestinations within an Integration Services project.

I hope somebody can help me. Thanks.

View 1 Replies View Related

Sql2005,SSRS How Create Dataset From 2 Datasources

Oct 10, 2007

I can add more datasources and how can i frame my query based on the tables present in the various datasources?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved