I have a ReportViewer control and the PDF download function is working fine. However, the table does not fit to the page of the PDF and part of it appear in 2nd page. I want to have that report fits into one single PDF page.
How can we set the page setting property when it compile the PDF file ?
I need to validate a textbox to ensure the submit date is older than Today. I wanted to use a CompareValidator to do that, but unfortunately the following code doesn't work:
<asp:CompareValidator ID="cvtbDateExpiration" ControlToValidate="tbDateExpiration"
Operator="GreaterThan" Type="Date" ValueToCompare="<%= DateTime.Today %>"
ErrorMessage="Card has expired" runat="server" />
The compiler tells me that ValueToCompare="<%= DateTime.Today %>" is wrong: "This is not scriptlet. Will be output as plain text."
Is there a simple way to achieve this (without setting it using the Code Behind)?
I'm generating the rdlc at runtime and I'm using LoadReportDefinition(memorystream) to provide the definition to report viewer. It works fine but when I export it to pdf or excel, the file extension comes in as .xls[1] or .pdf[1].
I have tried giving the DisplayName property but it doesn't work.
I need to set a style property of an element to the value returned from a code-behind property. I have done this in the past, but it now seems everything I try fails. I get an error telling me that the literal is not formed correctly.These are some of the arrangements I have tried:
[Code]....
I deploy our web in IIS but when i try to use the reporting services
the message pops up:
The request failed with HTTP status 401: Unauthorized.
but when i try to build and debug from visual studio
i can use the reporting services
I have a class called paycheckProperties where I have a property called GrossHoursWorked set like this:
[Code]....
In the form's codebehind I am first declaring an instance of this class:
[Code]....
then trying to set the value of the property to the value of a form control like this:
[Code]....
I'm not doing somethign correctly though because I'm getting an object reference is not set to an instance of an object error. What am I doing wrong?
I have a user control in asp.net that i need to dynmically set properties for. The propety and property values are in a dictionary, for example:
Dictionary<string, string> propertyValues;
Control c = Page.LoadControl("~/Control.ascx")
I can currently set the properties on the control using reflection, however, with .net 4 and the new dynamic keyword, is there an easier way to do it, for example, something like this:
dynamic c = Page.LoadControl("~/control.ascx");
foreach(var itemin propertyValues)
{
c.item.key = item.value;
}
this obviously doesnt work because item.key is a string and not a property.
I have a vb.net web site. Currently it is generating reports via ReportViewer. The datasouce for the all reports is set at the deploying of the report.
ReportViewer is configured in the aspx page
<rsweb:ReportViewer ID="myReportViewer" runat="server" ShowParameterPrompts="true"
ZoomMode="Percent" Height="1100px" Width="1000px" BorderWidth="1">
</rsweb:ReportViewer>
I am setting up the ReportViewer using the following code.
Dim _cred As New ReportServerCredentials(Session("_ApplUser"), Session("_ApplPswd"), Session("_ApplDom"))
'Set the processing mode for the ReportViewer to Remote
myReportViewer.ZoomPercent = 100
myReportViewer.Width = Unit.Percentage(100)
myReportViewer.Height = Unit.Percentage(100)
myReportViewer.ProcessingMode = ProcessingMode.Remote
Dim _SrvRpt As ServerReport
_SrvRpt = myReportViewer.ServerReport
_SrvRpt.ReportServerCredentials = _cred
'Set the report server URL and report path
_SrvRpt.ReportServerUrl = New Uri(Session("_RSConn"))
_SrvRpt.ReportPath = Session("_RSFold") + _rr.Report_Path
myReportViewer.ServerReport.Refresh()
lblTitle.Text = _rr.Report_Title
myReportViewer.ServerReport.Refresh()
myReportViewer.Visible = True
What I want to do is dynamically set the datasource for a report at runtime. That is, I have 2 datasources already configured in my Report Manager. I want to have the vb.net pick which datasource based on a enviornment variable. So, if Env 1, then use Datasource 1 in the Report Manager. Of Env 2 then use Datasource 2 in the Report Manager. I have seen what looks like software for doing this Locally but no for Remote.
I have an RDLC report and an aspx page with a MicrosoftReportviewer control. The objectDataSource retrieves ALL records.
Now I want to filter the reports results So in the rdlc report I create a report parameter by clicking on the report, report parameter menu. The name of the parameter is Zip.
Then in my code behind I put the following code in a button click event
Dim params(0) As Microsoft.Reporting.WebForms.ReportParameter
params(0) = New Microsoft.Reporting.WebForms.ReportParameter("Zip", "78734")
ReportViewer1.LocalReport.SetParameters(params)
ReportViewer1.LocalReport.Refresh()
When I click the button the results are not filtered. The results have not changed.
i have an already existing schema (in a xsd file). now i need to prepare a report, so in the rdlc page i take a table. now how can i set the schema as a dataset to the table?(i'm getting an error -- "the table 'table1' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets.").
View 1 RepliesI'm trying to create a report (rdl) againt SP list.
I have a Date parameter, just 1.
When a user is selecting a date. It checks against my queried date, a day before and a day after. It works fine.
When a user is NOT selecting the date. I want the my queried date between a MINIMUM date and a MAXIMUM date. Since I couldn't find the Min & Max date in SSRS report filtering, I trying to hard code the date.
I tried DateValue(...with variety of different format...), as well as CDate(...with variety of different format...).
None of them is working. What exactly is the format SSRS accepting?
As for my CDate(Fields!ows_Date.Value)'s result, it is displaying as "yyyy-mm-dd hh:mm:ss", I also tried that format, and still, not working.
<Filter>
<FilterExpression>=CDate(Fields!ows_Date.Value)</FilterExpression>
<Operator>Between</Operator>
<FilterValues>
<FilterValue>=IIf(IsDate(Parameters!DateParameter.Value), DateAdd("d", -1, Parameters!DateParameter.Value),
DateValue("01/01/1900"))</FilterValue>
<FilterValue>=IIf(IsDate(Parameters!DateParameter.Value), DateAdd("d", 1, Parameters!DateParameter.Value), DateValue("01/01/2100"))</FilterValue>
</FilterValues>
</Filter>
I have created a user custom control, and what I would like to do is to pass it the text value from a label where I can carry out some other processing.
View 2 RepliesHow to set proprety for List dynamically. I have a WebPage class having properties. strNodeName is one of the property of this class which is the parameters of method. I want to set the string strTitle according to the parameter strNodeName i.e., set
strTitle = _list[i].Title.ToString();
I want Title to be the strNodeName.
Like if strNodeName = Author, then
strTitle = _list[i].Author.ToString();
if strNodeName = CoAuthor, then
strTitle = _list[i].CoAuthor.ToString(); 
Below is my code.
[Code]....
here's my situation - I've created some ActionFilterAttributes that I want to apply to a custom Controller class that my other controllers can inherit from. The problem is, I need to set a property on the attribute from the final inheriting controller. So I have something like this :
[Code]....
[Code]....
I have a requirement to create a XML file from sql server data.I need to schedule this job to run at specific intervals of time.I don't know, if I could do with Reporting services.I would like to know, if it's possible with Sql server reporting services? how to do that.
View 2 Replieshow can i bind data to gridview when using compiles query? load all country
[code]....
I have just installed the Ajax Control Toolkit (Headache that it was).Now the latest finding is that it all works fine (i.e. compiles with no errors or warnings) when the project is stored on local (C:) drive but it doesn't work when the project is stored on a mapped network (L:) drive.
(This is all in Visual Studio by the way, just the development stage. Deployment to a server a different issue all together!)So if I press F5 to run the app with the Project located on the network drive I get the following error
Warning 1 Unable to update auto-refresh reference 'ajaxcontroltoolkit.dll'. Cannot find assembly 'C:Documents and SettingscawleymLocal SettingsApplication DataMicrosoftVisualStudio9.0ProjectAssembliesol2vglxn01AjaxControlToolkit.dll'. L:Information
& AnalysisDeveloper ArchiveCawleyMRecord Tracking (Asp.Net)Binajaxcontroltoolkit.dll.refresh L:...Record Tracking (Asp.Net)
along with several
Warning 2 Validation (XHTML 1.0 Transitional): This name contains uppercase characters, which is not allowed. L:Information & AnalysisDeveloper ArchiveCawleyMRecord Tracking (Asp.Net)SectionRecord TrackingApplicationPatient_Record.aspx
201 32 L:...Record Tracking (Asp.Net)
which I think come from a snowball effect from the first error.why it can't run from this location!
I am creating a class library which will have business logic and i want to call this from SQL Server 2005 DTS. What i want to know is how to consume a WCF service from this class library project and compile it in a dll. How to deal with app.config created when servie is refered in class library? Could somebody send me a link to any article which can help me to implement the same in my current project?
View 11 RepliesI have created a web application will will eventually be the holding place for several reports. Rather than creating a new webform for each report, I want to use the same report viewer for all of the reports. I have created an AccountSummary dataset (AccountSummaryDS.xsd) that has two tables, one for the header information and one for the details. I have two webforms in the app, a Default.aspx that captures the necessary employee information for the query and the ReportForm.aspx that has the reportviewer control.
I came up with the code below for a Windows form application but am having issues translating it to be used in a webform.
[Code]....
i am tryin to make an inherited custom label control.
what i want is i want to have a property for the label where one can select languages.
like <label id="lbl" language="">
so when the user gives "language" property he must be provided with an option of "EN" and "AR" like an intellisense.
I am trying to build a web user control and set some default values for its properties in the code-behind like this:
[DefaultValue(typeof(int), "50")]
public int Height { get; set; }
[DefaultValue(typeof(string), "string.Empty")]
public string FamilyName { get; set; }
[DefaultValue(typeof(Color), "Orange")]
public System.Drawing.Color ForeColor { get; set; }
When I add the user control to the page and call it without any properties:
<uc1:Usercontrol ID="uc" runat="server" />
the default values are not set and every property is 0 or null.
When I add a WebPart to a page, I need to set a Property in the class that builds the WebPart.
In the CatalogZone, I declare:
[Code]....
In the CatalogPart1 class, I instantiate MyWebPart:
[Code]....
MyWebPart.PagePartID contains the correct value.
This calls MyWebPart which contains the property:
[Code]....
but vPagePartID is equal to nothing.
What am I doing wrong?
How do I get the value of PagePartID to MyWebPart?
I am using a master page and web content forms in my project. I have a panel on my web content page which opens a popup window using window.open. When opening the popup window, I disable the panel on the web content form.
When I close the popup window, I want the panel to be enabled. I am trying to do this using javascript, but I am not sure how can I set the enable property of the panel to true using javascript.
I wrote an ActiveX control using .net Framework 2.0 WMI to extract user's printer property. In my test environment I had to install .net framework and use the configuration tool to change the security zone to full trust. Would I have to do the same manually on all client machines? It would be fine if all client has to do is click "yes" to install an ActiveX but another if they actually have to run configuration steps themselves to change the trust level. If the client can't do it without running a manual setup I would need to create classic none .net ActiveX control to do the same thing. Can I use VS 2008 to create none .net ActiveX controls? How do I exact printer property without WMI?
View 4 RepliesWe have a website with a huge amount of Cached objects stored in static variables within App_Code. Whenever we push an App_Code change to our production webservers it recycles the IIS pool and flushes the cache. It does not flush the cache however when we push out changes to .aspx and .aspx.cs files.
I need to have a bunch of classes that will be updated several times a day to be able to be referenced in App_Code. I would like either a section of my App_Code which I can update several times a day without cycling IIS and flushing my cache, or the ability to reference classes outside of App_Code from within App_Code.