Search results for query: *

I found it you should use the join function. So join(parameters!<yourparameter>,", ") will return all multi value values delimited by your delimiter specification.

because the switchboard automatically creates a table. probably they didn't give it priority to automate the table creation towards a sql server database. There are different ways of making a menu so don't feel sad about it

Within this blog they talk about support but not about development (they propose to use linked tables). So..I guess at least you will find no new adp features.

The graphic options of rep 2005 seem to be a little bit poverish. A)Is it possible to sort the legend? alphabetically or numerically? b) is it possible to specify the order of the legend items to be shown? c) is it possible to colour the legend items your own specified way?

will only take first value

I heard the rumour that ADP's are being phased out by Microsoft. Access 12 supports it runtime but doesn't support development of ADP's so this type of solution will gradually totally disappear. Can someone acknowledge this en give some background information about the 'why' and the best...

Currently I show the parameters shown on my report by displaying them in my query as a separate column(I use sprocs for my reports). In this way i'm able to show all values chosen in a multiple parameter field. Is there an alternative way to simply display all the values in the multi value...

I would advise your boss to migrate to MySQL I do both MSSQL and open source software, in my opinion open source has a lower TCO and the biggest benefit is the active communitu, both oracle and MS charge for support services

I'm using the text box connect method to have graphs shown by user's choice within my report. So when they click the + sign they'll be given extra graphs. is it possible when the reports are exported to do the following: - suppress the text within the text boxes - automatically show all extra...

Suppose i select a specific group of production items, let's say Group B. This group involves 20 production items individually assigned a productionid. And besides the group parameter I have a production item parameter. Would it be possible to change the list shown within the production...

I found it. You need to check your SQL Server agent service properties and use an account which is mapped into the linked server security tab

I've setup a linked server on my localserver. Both servers sql server 2000. Within the security tab of my linked server i've mapped my username to the username valid on the linked server. Within my stored procedure i refer to the linked server. When executing the stored procedure within...

I'm programming a microsoft access project, to provide full security I use views as datasources with the 'with view metadata' clause. Within one data-entry form I want the records to be sorted different from the primary key. Normally I would use the 'order by' clause but when using this my...

Do graphs have a property to have them automatically grow in height and/or width when there's too much data to be displayed at the x-axis or y-axis?

Thanks unclerico it worked! All i need to change is when users select all, he probably generates a query with %. All i need to do is to validate the parameters in my report procedure, if a % is being passed the where clause is different

Thanks unclerico i will be giving it a try using the split funcion. Xlbo, i'm using reporting services 2005 which makes it able to use multiple value parameters. Though passing the values to a sproc gives problems so i will be trying unclerico's idea

I've used a datasource which connects to the database containing this procedure. I've selected this procedure, the report automatically took over the parameters. Within report parameters i've set the parameters line and empno to multiple value I'm trying to pass multiple values to the...

Hi, When trying to pass the multiple parameter to my stored procedure the report remains empty. I've used method 1 to pass an arry from this website http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm here's my proc: CREATE PROCEDURE dbo.Qry_MSSRS_Myproc @Begindate...

By the way: I'm using schema.ini in an adp based on access2003/sql server 2000

i'm using schema.ini to export several tables to text files. Within the schema.ini I've specified to use , as field separator and to not use " " as text markers. The schema.ini is being placed within the export map. Odd things happen. Sometimes it works but working on another client computer...