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 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...

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...

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?

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...

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...

I'm building a macro to pull information from multiple worksheets. The source of the data for each sheet is a csv file. I will be building a form where the user can browse and import the csv files. How can I write the VBA to pull File1.csv file into Worksheet1, File2.csv file into Worksheet2...

I hope someone can help me with this. I am using sql server 2005 report services, report builder for ad-hoc reporting. I only am able to use some views and i am not able to get to the fields, tables etc., just views.....At itself this might not be a problem. When making a new field i have a...

Hellow world, A little question, but driving me crazy.... i have a module: Randomizer This module has the following code: dim nID as string _______________ function nRandom() as String If nID = "" Then nID = Round(Rnd(Now()) + Rnd(Right(1, 3)) * 100000) ' Rnd(Now()) + Rnd(Right(1, 3)) *...

Quite a simple question (but the answer may rather be large i suppose) I use ms-access 2000 db is access based on oracle a user works with the db in access for viewing reports and so on. during the day access is open as application and the user is going to do something else. After returning to...

Function fOSUserName() As String On Error GoTo fOSUserName_Err fOSUserName = Environ("Username") ' of vba.environ("Username") Environ ("Username") fOSUserName_Exit: Exit Function fOSUserName_Err: MsgBox Error$ Resume fOSUserName_Exit End Function Above mentioned code i use to...

Hellow, Little question, hopefully not a big answer :) i have four oracle db'ses mydb_db_test, mydb_db_production, mydb_db_develop within access i have linked tables from the first one; let's say: mydb_db_test.tblOne, mydb_db_test.tblTwo What i want to do is: 1) import the same tables from...

Hellow, I searched for a proper thread which could help me, but unfortunately the thread i think it could help me no longer exists. i'm searching for a way to deselect items in a listbox (or deselect all items at once by pushing a button); cannot find a way to do this. Could anyone please...

a maybe simple question: With the mid function one can make sure that a part of a text is token to display on a report, output or whatever. But how to do the following: "John Isaac" "William Bill" "Michael Robert" In the report the following has to be visible: "John" "William" "Michael" The...

Another question. One of my tables contains a date/time field format: dd/mm/yyyy; in the format property of a table column usually (type: text) the indent can be set to left with "!" (without the " of course); however, i would like the date/time column to the left as well in stead of to the...

I have four linked tables within my access db; i need to change the connection string; of course i can refresh by the menu (linked table manager) and choose the right odbc-connection, but i want to be able to do this for the four tables at once by a button. At this moment i have made a local...

how do i change a connection string from passthrough query; i have about 100 passtrhough querys with of course a connection to a databse (oracle). With one button in a form i want to be able to change the connection to another database (oracle). Thanks for the reply!

I have a problem, which i cannot solve: 1st: i created a [shift]-bypass module and behind a textbox a code which if doubleclicked a password is asked, to disable or enable the [SHIFT] key for opening the db the next time it is started up (found in a trhead here somewhere how to) 2nd: i have a...