Dear all professional,
If exports the report as Excel format, how can I set the page margin in excel as 0.5cm ?
Thanks
View Complete Post
Hi.I have a report where I hide or show a set of columns based upon the user selections in the paramters dropdown list. User could select option 1, option 2 or both. Requirement is that if they select option 1 then I need to hide the option 2 related columns. If they select option 2 then I hide the option 1 related columns. The tricky part is that they can also select both options then I need to show both options related columns. Normally I create dynamic column titles and column fields with the IIF statements and show only one set depending upon the selection and adjust the right margin. In this case I need to leave the right margin to the maximum columns width so it could accommodate the selection of both sets of columns. The issue comes in When they select only one set of columns that leaves some ugly large white space in the right margin which is visible while previewing or printing report. Is there any way to fix this issue? This is SQL server 2005 reporting services.Thanks for your help.
is there a way to make the first column of a report use the an alternating background color?
I have the background color set for the entire row however it does not work for the first column if the color is set to an expression. If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).
In the file below only the textbox for part number does not show an alternating background. All others work correctly.
<TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="PartNumber"> <rd:DefaultName>PartNumber</rd:DefaultName> 
Hiii Coders ,
I have created my website. Now what is my requirement is that on higher resolution it should be centralized means margin from both sides should be same.
How can i get it working
plz provide me some code snippet plz
thanx and regards
I downloaded report viewer 2010 from here
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=a941c6b2-64dd-4d03-9ca7-4017a0d164fd
Now I want to actually use it in a website. How do I do that? Do I have to modify some part of web.config? Specifically, what do I need to change?
Hi all
I have a button "Show Report" to show some data from table
what I should write under this button to populate the reports ?
Hi,
Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.
Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent
Jewel
HI all,
May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer Control for displaying the Report on my Asp.net Page .
I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control If any one have experince before please share the ideas.
Best Regards
I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".
On properties of image control i have the following properties set:
MIMEType= "image/png"
Source = Database
Value ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"
Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)
However, when i run the report the image just displays an X, what am i missing?
HI I m sorry to say this But this task too urgent.
Ex- i have two tables in my db name called Comdetails, deptdetails.
TCS is a one company name stored in ComDetails and Company_ID took as primany key,
TCS having 10 department stored in deptdetails and Company_ID as foreign key.
so now in DB we have available one company with 10 departments.
so now i need to generate report , i m using report.rdlc and reportviewer.
i hope upto now its clear.
my task-
1- i have two pages in a report in page 1 i m doing designing report like top i need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of re
how to get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services
Thanks in advance
An error has occurred during report processing. A data source instance has not been supplied for the data source "PatientDetailsReport_DataTable1". i am using two to three rdlc reports in my page for single report viewer when i first load the page i got the output in reportviewer but when i try to load other rdlc report then am getting the above mentioned error.i cleared all the datasources for the report viewer before giving new datasource but am getting the same error pls someone help
I am trying to print crystal repot directly from a C# application, which is calling webservice. I am able to display report in crystalreportviewer by passing the webservice call to datasource. However, is there anyway, I can print directly without showing the report?
Alternatively, I was trying return ReportDocument object from webservice, which would solve my problem, but I was unable to return the ReportDocument because of serialization issue. Is it even possible? Thank you
Arya
Hi All,
I created a simple crystal report using visual studio 2008 (GAC INSTALLED VERSION 10.5.3700.0) . It is working fine locally. When I deploy it to the server when I click on the report I am seeing the empty report with "LOAD REPORT FAILED" Text. How can I resolve this Issue?
I checked the GAC and made sure that Both are using the same version of Crystal reports . Can some one help me how to resolve this issue?
I was getting a load report failed error on the server before (locally it was working fine). I tried everything one of the solutions that helped me partially was adding below lines to the code.
ext.SetDatabaseLogon("UserId", "Password","DataBaseTest","ServerName");
When I add the above Line to Local Mechine it is working fine and returning data.(Records)
But When I publish this code to server I am getting a screen that has
Server Name : Filled
DataBaseName : EMPTY
UserName :Filled
Passsword:Filled
screen and I am unable to enter the databaseName.
Scenario 2:
ext.SetDataSource("DataBaseTest");
When I add these 2 lines to local mechine all the crystal report with heading and date is coming up but the data from the sql server is not appearing. Actually this is loading the report correctly but unable to get the data from the data base. (Not displaying any records although it is supposed to display 100 Recs)
When I deploy it to the server it is acting the same way.Displaying the record with heading , date, page number etc, but no data
Do you know what should I do to
Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for
User name Data Name Password
each time.
Is there a way to avoid this and I save these authentication in my page once.
I am using VS2005, C#.
Any Help will be appriciated.
Thanks Asif
Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DATA" requested by the login. The login failed. Error in File C:\Windows\TEMP\NewQuote {573CE511-64B7-4161-B9DF-0E58EB1EDA19}.rpt: Unable to connect: incorrect log on parameters.
I get the above message when loading the crystal report from the Intranet via IIS but it works fine from the localhost the report loads ok and picks up my parameters. This is my Code behind Page.
Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load Dim Count As Int32 Count = Int32.Parse(Label1.Text) Dim ConnInfo As New ConnectionInfo With ConnInfo .ServerName = "\\Server1\Sqlexpress" .DatabaseName = "DATA" .UserID = "sa" .Password = "1181
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend