I have the below format of the Date in sql server 2010-07-14 11:49:27.000 and i want to display the date in format MMM dd, yyyy 11:49 AM on the report i tried the below but it is giving the out put like ' 14 July 2007 12:00AM
=CDate(First(Fields!CreatedDate.Value)).ToString("MMM dd, yyyy hh:mm tt")
How i solve this.
I am having a rdlc report i added and heading lteaxt box and value as =today() in the browser it showed as 03/06/2011 12.00 hrs. when i formated as dd/mm/yyyy format in coustum format it shows as 06/00/2011
View 2 RepliesMy rdlc tabular report has Total Variance column . It values can (+) or (-) . So i need to show those values in different colours . Are there any way to do it.
View 4 RepliesI'm designing a layout for a report in VS2008 using SSRS/RDLC format. And every time I setup a part of that report i test it on my workstation to see if everything is ok. But, today, i finished the first page of that report and uploaded it to my hosting server (were it's going to be used), and when i press the button to convert the report to .pdf and download it the layout is completely ruined :-/ When i do the same thing in my workstation every thing 'comes out' beautifully, but up on the server it doesn't .
View 2 RepliesI'm creating a RDLC report in C#. Is it possible to insert the content of a Word 2003 document (with formatting) in it (either in design time or programmatically) before exporting to PDF. The final result will be a PDF file containing the initial report (fields from database) and the Word document content following it.
Why this? I need to give the user the possibility to fill a form, attach a word document and export the all to PDF as I described earlier (ASP.NET). I don't have Word installed on the server so I can't Interact with its COM objects.
Oracle Date Formating Null date as 00/00/0000
View 3 RepliesI added a new report template from the Reporting section of the Installed Templates (rdlc extension). I have successfully created a connection and am rtrieving data into textboxes that I have placed on the report. My problem is that I want to do a Test in the Expression template, but I cannot seem to do 'if else' statements.Can anybody give an example of how to perform conditional processing for a textbox on an rdlc page. i.e. The expressino for just populating a textbox might be:
[Code]....
What I want to be able to do is something like
[Code]....
Coding for this control seem to take VB/VBA Style syntax.
how to convert rdl to rdlc in asp.net?i create report using report builder i want to set it to report viewer in asp.net and display it the problem is that when i create the datasource in report builder i don't now where the report builder store dataSet that i create while building the reporti read topic about converting rdl to rdlc but my porblem is i can't create dataset in asp.net with parameter and i can't find the path to dataset in report bulider to add it to asp.net as an existing item??
View 1 RepliesI want to know how to open an RDLC Report in a pop up. I have taken an asp.net web application. I have added an rdlc and created a dataset and a report with the data from datasaet. In the web form I have taken a report viewer control and have binded the report. Now i have a view report button. When I click on viewReport button, the report should open as a popup. if there are any parameters like drop downs in the main page these also should be passed to the popup.
View 1 RepliesIf I have an XML file, can I use it as a datasource for a RDLC file?
View 4 RepliesI 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 am working with rdlc reports. I have an asp.net web form where i'll select a parameter (substance name)from a dropdown. When I click on view reports button, the report should open in a pop up. I am passing the ID(substance ID) from dropdown in query string to the popup page.
When I click on view reports button, the report should open in a pop up. For this I have taken report viewer control in another aspx page. The code in the aspx.cs page which contains the report viewer control is as follows :
I have taken two rdlc reports. The main report has the parameter SubstanceID. The child report has parameter substance name.When I click on one particular textbox in main report it should navigate to another report. So, in textbox properties of main report in Navigation tab,I am giving "jump to report"--child report name and parameters "@SubstanceName" and its Parametervalue as :
=Fields!SubstanceName.Value.
When I work out this report in server side reporting(ReportServerProject) it works as expected.But in coding it throws an error :
An error occurred during local report processing.
An attempt was made to set a report parameter '@SubstanceName' that is not defined in this report.
I have taken a report viewer and two ObjectDataSources....one for parent report and other for child report.
The code for the page that contains report viewer is as follows:
In page Load : Binding Parent report
[code]....
I am having a strange problem with and RDLC report with two tables in it. The tables are not related, nut I need them both on the same report. In my project, I created a typed dataset with two datatables in it (no tableadapters). IN my rdlc, added two datasets, one for each of the datatables. I then built the two tables in the report to use the appropriate dataset. When the application runs, I manually add data to the typed datasets and then add them as reportdatasources, etc. Now, all of this works fine if I have only one dataset in the rdlc. But, when I have two, I get an exception when I call lc.render(...). Digging through the inner exceptions, I end up with "DataSet1" as the inner most exception message.
View 1 RepliesI have a report which has 2 subreport, due to some problem i was asked to show the details of the subreport in one report, so i am trying with list and grouping, but when i am tring to get details in a dataset with multiple table binding with datasource is binding only first table who to read the other tables... if i am using one datasource with multiple table adapters grouping and filter in designing is not allowed, how to overcome this problem. if i don't want to use any subreport is there any way of doing it ..
View 3 RepliesI am using Report viewer in asp.net. i am getting all the fields .. my question is while clicking the content from one field i want to open a pdf document (for eg: i am displaying the Details of a Student ,in that details report Mark Certificate is one of the column .in that i am displaying the name of the document . while clicking the name of the certificate i want to open a pdf document which having the mark statement )
View 1 Repliesi want to show my footer in rdlc report only in last page ?how do i do it?
View 2 RepliesI create a rdlc file with table, That table shows dataset value in dynamicaly. It is working fine. But i can't able to set table border value. And also i want to show alternative rows in difference background color... (I just simply say how to design a table in rdlc file(dynamic or static)?)
View 1 RepliesIn rdlc, if we set the visibilty of any element to hidden, the element gets invisible but the space is left out.
I want to set a list and few textboxes to invisble but the space should also collapse.
I have a main report, one subreport1 that is embedded in the main report. Now I have another subreport2 that needs to go under subreport2.How do I do that? Where do I add subreport2, is it to main report or subreport1.
View 2 RepliesAfter being thoroughly frustrated with the typed datasets using the xsd designer, i built a custom class as an alternative. When I built it, I used the ComponentModel.DataObjectMethodType and ComponentModel.DataObject so that I could access them from the wizards. In the aspx file where the rdlc resides, using the wizard, I can select an objectdatasource and set the typename and selectmethod and add the object to the file. But when I go into the reportviewer, it doesn't show up as a project datasource for me to be able to add it to the reportviewer even after rebuilding the website. A few google searches didn't help so here I am asking if anyone can point me down the correct path.
View 5 RepliesI have a .rdlc report created in Visual Studio and Upon executing, I wish to have the user be able to export the resulting data to Excel. How would I go about doing this
View 2 RepliesHow can i extend the 30 second timeout of the object datasource used in the reportviewer in local mode? I need to resolve this week.
View 3 RepliesI'm putting some reports together and I need to populate these reports with data from my EF Model.
I'm currently attempting to do this with Microsoft Reporting, but alas so far unsuccessful. I've tried providing an enumerated list as a data source which it seemed to accept with no problems, but I get an:
error:
A data source instance has not been supplied for the data source 'Quote'.
When I view the page in that the report viewer control is on.
Also - while on the topic of reporting (probably not suitable for this thread) - I'm wondering how I'd go about creating a master/detail report, and how I'd provide an enumerable data type of single record for the master?
I have a rdlc report.When rdlc is openning i want to save rdlc report automatically as a pdf file.
View 8 Repliesi was trying to create rdlc report on the fly based on the fields selected.
after some research i found using rdlc/matrix i could create the reports on the fly. i found it from this link.
[URL]
but rdlc/matrix report is based on the xslt templte. How can i create the xslt matrix tempalte for this purpose.
