Search results for query: *

Hi lbass, the problem I'm having is that when I click on "Chart Option", nothing happens. I've worked around the problem by creating a new formula for the date field in question and used that as the data for x-axis. Oddly that makes it display horizontally instead of the 45 degrees with the...

In Crystal 8, I have created a "Line Chart with markers at data points". On the x-axis, I display a date field (ex: 07/31/2010) and it is displaying at 45 degrees. How do I make it display horizontally? In Design mode, I click on the x-axis date field in the chart, then right-click on it, and...

Never mind. I searched the forum and found the answer as well. By using join function. Thanks anyway.

Hi, I created a dynamic parameter that displays values of a table field. In addition, it is set up to allow user to choose multiple values. How do I display all the chosen values of the parameter field in a heading? I'm using Crystal XI. Thanks in advance.

I figured out how to do this. Thanks.

Hello, 1) How do I set up a parameter field prompt to allow the user to make multiple choices instead of just one? 2) I would also like the prompt to dynamically display all the values from the field. So if the field values are changed, the change is reflected in the list displayed to user...

Thank you for explanation. Now I understand.

Yes, 256 should be fine. The date range should never span more than 31 days. I got everything to work. Can you explain what is the "Master..spt_Values"? It doesn't seen to exist as a real table or a system table. Is it a virtual table and what is it for? Also what does it mean when...

Hi gmmastros, that worked just fine. Thank you. I'm not familiar with the "Master..spt_Values" table. What is this table for and what does it mean when screening on Type='P'?

Oh, I didn't see the inner join part. I thought you were just showing me how to create a view. Let me give this a try. Thanks!

It's not creating the view that I'm having an issue with, it is that the DECLARE statement is throwing an error within the CREATE VIEW. It states there is a syntax error, but it works fine if I just run it straight in query analyzer. I suppose the question is, can you have a DECLARE statement...

Hi bborissov, I just got a request to make the suggested query into a sql view so it can be called from a Crystal Report. When I put your suggested code into a CREATE VIEW, I get an error message that the DECLARE has invalid syntax. The same code runs fine from Query Analyzer, so I'm guessing...

Thank you bborissov. That worked! Have a great weekend!

Hi, Below is simple representation a table_A. table_A Company Volume Begtime Endtime ------------------------------------- ABC 1000 03/01/2009 03/05/2009 ABC 3500 03/05/2009 03/08/2009 My desired output are records that are duplicated for each of the 2 date...