How to write a MDX expression to pass the value of a multiselected filter while working with ReportAction in Cubes.
I know how to pass the currently selected value, but want to pass the more than one value selected in the filter.
Im facing problem in one of the reports while passing multivalue parameter from ssrs to SP.
please note that in cases suppose there are single word in multivalue paramtere then its works corretly,in that scenario i have made one function see below:-
[Code]....
and did changes in sp as follow :-
[Code]....
im using ssrs2005.
I have created an ASP.NET page and included a ReportViewer on the page.
I have created a report with a parameter for an item ID for a row from the database.
After generating a multivalue parameter, I send it to the report, but only the first item in the list is displaying.
In my included code, I am using a FOR loop to generate a list of ID's I want to print a detail for (one detail per page), but eventually I am going to allow a user to select the ID's from a GridView, generate the reports and then print.
Here is the parameter definition from the report:
<ReportParameters>
<ReportParameter Name="ParmWorkOrderID">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
---------
Here is the code that build the multivalue parameter:
List<ReportParameter> paramList = new List<ReportParameter>();
ReportParameter param = new ReportParameter("ParmWorkOrderID");
// Create the ArrayList of values to pass
ArrayList values = new ArrayList();
for (int i = 19; i < 50; i++)
{
param.Values.Add(i.ToString());
}
// Add the parameter to the list of ReportParameters
paramList.Add(param);
// Set the reports parameters
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] {param});
-------------------------------------------
Finally, here is the filter I have on the report:
<Filters>
<Filter>
<FilterExpression>=Fields!WorkOrderID.Value.ToString</FilterExpression>
<Operator>In</Operator>
<FilterValues>
<FilterValue>Parameters!ParmWorkOrderID.Value</FilterValue>
</FilterValues>
</Filter>
</Filters>
So, why won't the reporting engine pump out one page or row (if I use a table on the report) for each of the ID's sent over as parameters?
my qyery is Select * from UserTable .
i set my parameter as @UserId,checked multivalue check box.
in Available values-from query-i set my value and label field.
default value is null.
when i click the preview tab,multiple UserId with check box appear in drop down list...
when i select any one userid ..i get the result for all the userid list instead i want only the selected userid's information...
I have a textbox labeled BudgetUsed with the following Color expression: =IIF(ReportItems!BudgetUsed.Value > 1 or ReportItems!BudgetUsed="Div/0","Red","Black") When I display the report, even when the value meets 1 of the criteria in my IIF statement, it still shows up as Black when it should be Red.
If I take out one of the criteria from my original expression, and change it to:
=IIF(ReportItems!BudgetUsed.Value > 1,"Red","Black")
Or change it to:
=IIF(ReportItems!BudgetUsed="Div/0","Red","Black")
The values in the BudgetUsed textbox display correctly in Red. Why can't I use the 2 criteria together using the OR operator? When used alone, both work, so I don't think it's a syntax issue.
i've written the code in expression field...
=format(sum(fields!salary.value),"##,##,##,##,##,##,##0.00")
the code is for printing the number in this format(12,23,23,34,123.00)
now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas
are printed.. i dont want to print the extra commas.. how the word length is there that much it
should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...
i've tried by removing some of the #'s but it is for fixed number..
writting the following Field Expression in SSRS
View 2 RepliesI am creating a report and I have several paragraphs of text making up my document inside those paragraphs I have data from my database so its made up of static and data driven fields. I need to bold and under line some of my fields inside my expression. I tried creating several columns and putting in my fields in other columns and that does work however it doesn't look that great sometimes there are large gaps in my text between the static and the dynamic.
here is an example of one of about 14 paragrahs in my report.
="The Borrower hereby notifies MACED that it will use "& FormatCurrency(Fields!TotalAmount.Value) & " to fund the costs reflected in this Requisition No. " & Fields!pk_ReqID.Value & ". The above described loan proceeds will be used for the following purposes and in the following amounts:"
As you can see thats one large field I have it works great other than I need to bold and underline my Value and my date can this be done inside my expression in some way like FormatCurrency(Fields!TotalAmount.Value,"BOLD")
i am using .rdlc report .I have three fields like length,width ,height.I want to display Length X Width X Height.This is not multiplication .i want to show in a single column.
View 2 RepliesI am very new to the SSRS arena and have not yet developed any reports with this. I'm creating a website which requires reporting...as new reports are developed within SSRS, how do those suddenly appear in the asp.net application for selection by a user? I like to have the ability for an administrator to create new reports and allow the ASP.net application to somehow offer it dynamically as a selection. Keep in mind, some of the reports may require input parameters...those parameters would also need to be displayed from the asp.net application also.
Can this be done dynamically some how or does it require actual coding is needed to the website, every time new reports are introduced in order to display the report along with the parameters needed?
SQL Server BIDS client 2005, when launched, displays a "Splash" screen that should allow selection of 1 of 3 apps. I am trying to get to Reporting Services but the launch skips right by and goes into Analysis Services.
View 2 RepliesI want to Add product with Solr.net Schema file. my database Table is
Category table - catid, catname
Brand table - brandid, brandname
Item table - productid, productname, productdesc
Filter table- key, value
Note:- if i add all with a Table then data Repeatation occur. so if u have better solution then please suggest me with an examle.
i have DropDownList with sql select commend
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource_department" DataTextField="Department"
DataValueField="Department_No" AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource_department" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [Department_No], [Department], [Code] FROM [Departments]">
</asp:SqlDataSource>
in the behind code, i can get the value using "DropDownList1.SelectedItem.Value" for Department_No and "DropDownList1.SelectedItem.Text" for Department
but i want also get the selected value "Code"
I once asked for a way to let a linkbutton pass more than one value in the commandArgument and then I reached the approach where I pass a string of multiple values separated by any character and split it into it's original parts...that didn't work out I don't know what was wrong with the splitting!
Now I tried the only solution I got, which is created a user control of the LinkButton and add properties to accept any values nedeed!...could you please tell me what's wrong with my 2 approaches and which is better ?
The first question can be found here : link text
and this is the code for the user control approach >>
MultivaluedLinkButton.ascx :
<asp:LinkButton ID="LnkBtnSort" runat="server" Text="Sort" OnClick="LnkBtnSort_Clicked"/>
MultivaluedLinkButton.ascx.cs :
public partial class MultivaluedLinkButton : System.Web.UI.UserControl
{
public event EventHandler Click;
private int _sortingType;
private string _sortingFactor;
private string _text;
public int SortingType
{
set { _sortingType = value; }
get { return _sortingType; }
}
public string SortingFactor
{
set { _sortingFactor = value; }
get { return _sortingFactor.ToString(); }
}
//public string Text
//{
// set { _text = value; }
// get { return _text.ToString(); }
//}
protected void LnkBtnSort_Clicked(object sender, EventArgs e)
{
if( Click != null )
{
this.Click(this, EventArgs.Empty);
}
}
}
Finally, Here's the implementation of my control inside an aspx page:
protected void MultivaluedLinkButton1_Clicked(object sender, EventArgs e)
{
MultivaluedLinkButton ctrl = (MultivaluedLinkButton)sender;
using (SqlConnection cn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
{
using (SqlCommand cm1 = new SqlCommand(commandString2, cn1))
{
cm1.Parameters.Add("@arrange_by_id", System.Data.SqlDbType.Int);
cm1.Parameters["@arrange_by_id"].Value = ctrl.SortingType;
cn1.Open();
using (SqlDataReader dr1 = cm1.ExecuteReader())
{
SortBy_rpt.DataSource = dr1;
SortBy_rpt.DataBind();
}
}
}
}
The item template of the repeater in the implementation page :
<ItemTemplate>
<uc1:MultivaluedLinkButton ID="MultivaluedLinkButton1" runat="server" OnClick="MultivaluedLinkButton1_Clicked" SortingType='<%#Eval("arrange_by_id")%>' />
</ItemTemplate>
I have a parameter Owner with 1,2,3 options in dropdown.
On selection of option 1 , a country parameter should be enabled with all countries' values defaulted.
Option 2 should enable Region parameter with all the Regions values selected and country parameter should be displayed.
Option 3 should disable both Region & Country Parameter.
I am using SSRS 2005 with Enesys tool as add on.
I want to know, how do i send a multivalue parameter from C# to Stored Procedure which is used in WHERE CLAUSE in IN statement?
for eg:
CREATE PROCEDURE [dbo].[sp_GetPolicyDivOff1]
@Insid varchar(5000)=null
AS
SET NOCOUNT ON
SELECT MST_GroupCompany.GC_Name,MST_DivisionalOffice.DIV_Name FROM MST_DivisionalOffice INNER JOIN MST_GroupCompany ON
MST_DivisionalOffice.DIV_FK_GC_ID=MST_GroupCompany.GC_ID where GC_Name IN(@Insid)
i Want to show data for single employee like this like this
Emp Id : xyz
Emp Name : abc
-------------------------------------------------------
Child name Date of birth education
abc 12/12/2000 o levels
I write inline expression and binding expression in the server head section:
[Code]....
[Code]....
But both kinds of expression aren't parsed or executed except the ResovleUrl menthod. The html renders like this:
<head><link rel="stylesheet" type="text/css" href="<%= Request.ApplicationPath %>themes/style1.css" /><link rel="stylesheet" type="text/css" href="<%# Request.ApplicationPath %>themes/style2.css" />
<link rel="stylesheet" type="text/css" href="/themes/style3.css" />
<script type="text/javascript" src="/js/jwork.js"></script>
</head>
As I know, the inline expression in the attributes of server control can't be parsed but the binding expression should if we invoke the DataBind method. But the above case breaks the rule.
I'm trying to use the validator to work on a email form to ensure that they enter a valid from email address. That part works. I also want to add to the expression the text that I pre-populate in the txtbox ("Enter your email address") so on postback, after sending the message, I can clear the fields and repopulate that box.
How do I add that wording to the current expression: w+([-+.']w+)*@w+([-.]w+)*.w+([-.]w+)*
I am using Regular Expression validator for a text box. The below is working fine.It is not performing validation when I enter values like 0000..001.How can I modify validation expression? But it would allow values like 100,...5000 i.e zeros after a number.
<asp:RegularExpressionValidator ID="reg2" runat="server" ControlToValidate="rng2"
ValidationExpression="^[0-9]+" ErrorMessage="*Please Enter a Valid Number for Second Range."
ForeColor="Red" Font-Bold="True"></asp:RegularExpressionValidator>
I was wondering if anyone can help me work out what the user has selected in this selection changed event?his is what I have so far:
protected void rblNavigation_SelectedIndexChanged(object sender, EventArgs e)
{
string url = (GetCurrentPageName()).ToString() + "?" + Request.ServerVariables["QUERY_STRING"];
[code]...
The problem is that rblNavigation.SelectedValue is not the value that the user has selected to trigger this event. How do I get the value the user has just selected?I'm using C# and this selection event is inside my MasterPage.
I need some help in regular expression.I am validating the textbox text when updating the records.When i click the update button,the first 5 letters should be equal to CM000 or cm000.How to validate this using regular expression in asp.net. does anyone know validationexpression for this.
View 1 Repliesi have to check if an input string is valid based on the given regular expression.. this is the regular expression.
(a(bb+aaa+((ab)*bb+(aba)*aa)(a+b)*) + (b(aa+bbb+((ba)*aa+(bab)*bb)(a+b)*)
+ is an OR
* is a LOOP, it is optional, it may be done as many as a user wants.
i've tried many ways to solve the problem that my professor gave me but my knowledge isn't that enough to solve this problem..
I have question is it possible to install Report Manager (IIS Service) on different server than Reporting Services is installed? I would like have IIS service (Report Manager) on one server and Reporting Services mechanism on the second one. Do you think this solution is possible?
View 2 Repliesit possible to pass the query dynamically to sql server report from .net or from any other source.
View 1 Replies