Search results

Hellow everyone, I have the following query: SELECT Year, School, Number FROM tblStudentNumber GROUP BY Year, Number, School ORDER BY School, Year (quite simple :) I want divide the field [number] with a sum over the numbers, within a school group... Something like...

Hello everyone, I have a report with 1 chart in it. At the series of the chart, there is an action property in this action property i have filled in another report with the appropiate parameters, so when clicking on one of the series of the chart, the other report will open. My question is...

i found the solution for this. Quite easy though! in the designer right click on the series of the graphic part (the columns) in the submenu click on series properties then click on Action then click on radiobutton () report and select the detailled report then click on the button [Add] and...

update: I have found a part of the solution: I thought i had published a major version of the dashboard page, but appearantly i did not. Upcoming question is though: Why can i only view the dashboard when i give the user FULL CONTROL rights. When the user has read and/or view rights, he cannot...

I have a question about the sharepoint webparts. I would like to connect two webparts to eachother as follows: if i click the first webpart, the second webpart will show the information ==== the regular information of sharepoint doesn't help me very much further, so please advise how i can...

I have made a concept dashboard in which a couple of reports (made in Report Designer) are opened. I have two users in this test: the administrator and user1. The administrator and user1 both can log in to the main page (http://server//) but when the user1 doubleclicks on the dashboard he gets...

the report manager site isn't available when sharepoint is installed. Because of sharepoint takes over the report manager (with the sharepoint report designer add-on there are special utilities available in configuration manager of the sharepoint for handling reports, authorisation, settings)...

the report manager is not available anymore when the sharepoint services are installed; therefor the authorisation has to be made at another level. I tried a couple of things out within sharepoint (target audience) but it didn't quite work... Thanks for your answer though! any other tips...

Hellow, Since there is - as far as i found it - no forum for questions about microsoft visual studio BI Report Designer within SQL report 2008, i thought this was the most applicable place to post my question :) I have several reports which are deployed to a dashboard page (sharepoint). I...

i am new concerning this...but i try to design the report in the SQL Server Report Designer (MS Visual Studio). The connection is with ODBC to an access db. I don´t think i can use the trick of the snapshot within the MS VIsual studio designer+ maybe another suggestion?

Thanks in advance! I will look at the hyperlink

In my report i have inserted a chart. This chart has several columns as result. My question is that i want to open a new report when clicking on one of the columns in the chart. Every column refers to another detail information. please advise?

I have managed to solve the problem :) For some reason the datasource was not linked (within sharepoint) to the report, so i manually linked the datasource to the report in sharepoint, now it is working!

i foudnd the solution. I had to configure the config file (reportingservices.config) and make the SecureConnectionLevel value set to 0. Default this value is set to 2 (for use with SSL) I have though another problem: Deploying the report seems to work, the following steps are taken: 1. deploy...

The following error occured when i try to deploy a report project to the report server (sharepoint integrated reporting services). The underlying connection was closed: An unexpected error occurred on a send In the properties of the report project the right information has been given (checked...

thanks for the answer. I have maintained this by making a parameter with using with multiple values; adding default values results in a combobox in which i can select some options, but i cant seem to get it together with query values. Anyhow, thanks for your information.

have tried several things. Won't help though. - made a parameter - made another datasource from the same table - used the other datasource for selecting query within the parameter - filtered this within the report result: none please anyone?

First let me apologize in advance for maybe writing this question in the wrong area of this forum. Please advise if wrong, where i had to write the question. Question: in the report designer i made a simple report (connected to sample db AdventureWorks) with 1 parameter. I want this...

As i said it works...But i have a slight problem, probably with some long file names, which doesn't fit in in the worksheet names, and the code stops at the points where the filename is too long, a couple of names are equal to the filename, but some names which are (too) long(?) are skipped and...

found it Sub ImportCSV() Dim strPath As String Dim strFile As String ' strPath = "C:\temp\" strFile = Dir(strPath & "*.csv") Do While strFile <> "" With ActiveWorkbook.Worksheets.Add With .QueryTables.Add(Connection:="TEXT;" & strPath & strFile, _...