Showing posts with label system. Show all posts
Showing posts with label system. Show all posts

Monday, March 12, 2012

Nested filtering in Ad Hoc reports?

There are many business users in my office who would like an AD HOC reporting system. I am not in a position to install the entire suite and check it out myself. I have seen some presentations and i like the tool for the most part ...I have some questions if anyone can help....

1. Can the user specify more than one condition in the filter. Like Name = X AND Address = Y AND Job = Z

2. Can the users sort on more than one column ?
3. Can the users group by on more than one column. Nested grouping ?

I'm assuming by "Ad Hoc" reports you mean creating reports using Report Builder.

If so, then the answer to all three of your questions is YES.

Friday, March 9, 2012

Neither System.DbNull or NULL?

How to set NULL values inside VB Script .Net? Both causes error:

.FECHAAP = NULL

.FECHAAP = System.DBNull

.FECHAAP = Nothing

-Jamie

|||Thanks