Recent content by mr2tho

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

Could you maybe give the sql syntax that would be giving me the only one record as in the example above.

Can someone profesional can at least write that what I am thinking is not possible so that I wouldn't be looking into that. I would really appreciate it. Thanks for all comments in advance.

Actually this doesn't work for me because a view doesn't have primary keys. I need the whole different record. The two views are supposed to give the same records, one of them is giving couple extra. Let me see if I can explain: View1 1 970-010-1641 1641 2 970-010-1621 1621 3...

No, I am working in SQL 2000. You probably didn't notice I was mentioning about the Show Criteria Pane which is the second from top of the four panes in view in SQL 2k...But in SQL syntax the question would be difference of having after the group by or not having a "having" instead having a...

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.

Well, now I see that the one of the calculated variables was null and that was the reason...Thank you guys very much and have a great day guys, appreciated...

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

But I think the crystal reports is converting to bmp anyway if you start with jpg (unless I can specifically start with a format that crystal directly accepts). I am starting with a JPG 100KB and you know the rest. I can also start with a pdf, too if possible. Is the application you have...

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

Is it possible to do the same thing for the group1 footer to have the totals in group footer1 (which is just one line) to print in the same page as group2?

Perfect, perfect, perfect...Welcome to the tricks of Crystal Reports. If you have training classes, I'll be in your class. Thanks.

Good morning and thanks synapsevampire, It really is not important but putting a New page would give me lot of half full pages, worse than having a keepgrouptogether on group1. My main purpose was to see if you people already apply some tricks for this kind of formating problems beause I am...

You know that kind a fixed it but in a little lousy way. I loved everything except the same heading is now at the end of the page as well as the beginning of the next page. I did have the heading on the next page though, I give you credit. Thanks Is there any other way or a way to get rid of...