Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mr2tho

    sql syntax - Sql Server - Visual Studio 2005

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

    SIMPLE SQL JOINS HELP

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

    SIMPLE SQL JOINS HELP

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

    SIMPLE SQL JOINS HELP

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

    Just curious on Group By

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

    Just curious on Group By

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

    SIMPLE SQL JOINS HELP

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

    Query Analayzer Exec Stored Procedure Help

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

    Query Analayzer Exec Stored Procedure Help

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

    Picture size too large, help

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

    Picture size too large, help

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

    Formula to keep together

    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?
  13. mr2tho

    Formula to keep together

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

    Formula to keep together

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

    Formula to keep together

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

    Formula to keep together

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

    Simple Formula fail if no records

    Thank you very much Lbass and I appologize not giving you the number of locations, too. But I appreciated your answer more this way because now I learned more. What you said makes sense. I am a little disappointed from Crystal that I have to make a subreport just to show the selected parameter...
  18. mr2tho

    Simple Formula fail if no records

    I am just using the formula only to show what parameters were selected. It's a simple label. The parameter allows only one code to be entered.
  19. mr2tho

    Simple Formula fail if no records

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

    Drill Down Problem

    Thank you lbass, you have been very helpful. I hope you getting paid for all the helps you have been doing for all the people. I am reading your other posts to other people, too, they're valuable. I didn't know CR has such a good help, I've just found it out, great, I really liked it. You're...

Part and Inventory Search

Back
Top