View Complete Post
IÃÂ have a reportÃÂ created in SSRS 2005 which is running on our new SSRS 2008 box.ÃÂ It has 3 nested levels of visibility so the recipient canÃÂ click the twist tie toÃÂ viewÃÂ different levelsÃÂ of detail.ÃÂ Each Zone has many Districts and each District has many Stores.ÃÂ The report renders displaying the summary of the Zones.ÃÂ If you click onÃÂ the twist tie on the Zone it opens up a list of Districts.ÃÂ If you click on the twist tie on a district, it opens up a list of stores.ÃÂ If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.The report renders fine in report manager.ÃÂ The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.ÃÂ The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts andÃÂ Stores.ÃÂ The client is not happy about this.ÃÂ This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.I tried converting the report to SSRS 2008, but that did not solve my problem.ÃÂ Is there anyway to fix the export process to Excel?ÃÂ ThanksCarolP.S. I tried to upload the code, but it caused my question to be too many characters
I have was asked to built a report model on the cube for some users and being new to report builder 3.0.
I am having a weird issue. Lets Say I have following DIMS and FACTS. I have a cube built on top this Dimensional model.
Two measure Groups/mearsures : ClassFact/ClassHours and FacilitatorFact/FacilitatorHours.
used Many to Many relationship for FacilitatorDIM and ClassFact measuregoup. I now browse the cube it works excellent.
The problem Starts
Now a report model is built on top of it, then in the query wizard when I pull both groups and then FName the Classhours(measure) Disappears.
Does Report Modes supports Many to Many or am I missing something? Any help will be appreciated.
ClassDIM (ClassID, ClassName)
FacilitatorDIM ( FID, FName)
ClassFact( ClassID, Classhours)
FacilitatorFACT(FID, ClassID, FacilitatorHours)
SELECT ClassID = 1 , ClassDurationHours = 100.0
SELECT ClassID = 2 , ClassDurationHour
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>
In my organization we use nested groups.
For a particular usage, we have a group (let's assume that
the group name "kuku"), and the names of all the nested groups under it contains
"kuku" as well.
We may assume that no other group in the LDAP has "kuku" in
I need to create a filter which will return all the users
which belong to one of the "kuku"s group.
Obviously, using this filter will bring only the head kukus
(&(&(objectclass=user)(objectclass=person))(memberOf=CN=kuku,cn=.rest of the
How can I use wild card to fetch all users which belong to
For example: (&(&(objectclass=user)(objectclass=person))(memberOf=CN=.*kuku.*))
I downloaded report viewer 2010 from here
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?
I have a button "Show Report" to show some data from table
what I should write under this button to populate the reports ?
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
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.
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:
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.
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
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?