Search results for query: *

I am trying to create a report from order header and order lines tables. I am getting the error: An error has occurred during report processing. Exception of type System.OutOfMemoryException was thrown. These are very large tables. I have experimented and got data if it was restricted to one...

Yes

I tried it on another machine and got the same results.

If I change the available values to non-queried and place several there, then the default value works just fine.

SP2 didn't help, I still can't get a default value to work

sp1, I will try sp2.

I have been trying other reports using different parameters and found that if I use a query for the available values and not use the "All" addition I still can't select a default value. I think the problem is something other than the table variable we created. And yes I was using the exact...

classid

I created the following query for the parameter available values. DECLARE @classlist TABLE (id int IDENTITY (1, 1), classid Char(15), clasdscr Char(31)) INSERT INTO @classlist (Classid, ClasDscr) VALUES ('All', 'All Classes') INSERT INTO @classlist SELECT classid, clasdscr FROM...

I am only using a query to populate the available values not the default values. This is the query: SELECT CLASSID, CLASDSCR FROM RM00201 UNION SELECT 'ALL', '-ALL CLASSES' If I use the value of ALL for a default value it works but the default value does not work for any of the other values...

Hi All, I have created a report parameter with a query for the list of available values. This works well and you are able to see the values and select the one you want and the report displays the correct records. When I try to assign a non-queried value to the default value the report seems to...