Search results for query: *

Hi, I am working on a data entry in Visual Studio 2005 and SQL Server 2005. The Data Entry form is going to be crosstab. The Column and row of the crosstab table is in an list table (ltbl), so I am trying to make it dynamic. I made a stored procudure that returns crosstab according to the...

I have a view with multiple tables that has a goup by. I am in the process of adding new filters for some of the columns in different tables. When I add a column to filter, I can click it to "GroupBy" or click on "WHERE" on the Show Criteria pane of the view. I don't need to see the value. Is...

Hi, I have two views with exact same column names... One of the view has 4500 records, the other has 4508 records. How can I see this 8 records, vwA-vwB? I have been playing with all kind of join, I just couldn't get 8 records :) Your help would be appreciated. Have a great night.

Hi, I am trying to get rid of an error message in Crystal Report 9.0 which is using a stored procedure. All reports using a stored proc work fine except that one. And it only gives an error message when the parameters passed causes the sp to return no records... Lets have a look on what's...

Hi, I am updating a tax report which has a form in picture format on the background and our textboxes on the front.It's around 1 MB. I don't know how the previous developer did it but that is actually a low number. Because I went online downloaded the new 2006 tax as pdf, using screenshots I...

Crystal 9.0. I have three groups. If I go to Section Expert, "Keep together" is checked for all of them. When I go to Group Expert, click on options, Check "Keep Group Together" then it's sometimes trying to put the whole group in a new page causing lot of half full pages... Okay What I am...

I have a very simple function for a label. My parameter: {?LocationCode} 1) if parameter is seleted to be All it should show "All locations" (This always works) 2) if a parameter is selected I want to show the description as well for the selected one. Sometimes there's no records for the...

I have two Drill Down problems. Even if you help me on one of them, it would be appreciated. I am using Crystal Rpt 9. I have a parameter basically asking A or B. If A is selected: I need two Groups: For First Group: I made a function @Group1, really simple: if {?parameter}="A" then...

Hi, I am using Crystal 9. Lets say I have three groups state and cities and parks I want to do this State1 City1 (in same page as the state name) park1 park2 City2 (should start in a new page) park1 park2 City3 (should start in a new page) park1 park2 State2 (should...