Search results for query: *

I went with a stored procedure to do everything.

Sorry about that I am looking to export to either a text file or a tab delimited

I am using CR 8.5 and CE 8. I am trying to export a report to ASCII and the only options I have to choose from are six (6) canned export types (Crystal Reports 8, Crystal Reports 7, Microsoft Excel, Microsoft Word, Rich Text Format, Adobe Acrobat). Is there a way to export to ASCII or add...

I have a stored proc that is pulling all the data I need. What I am trying to accomplish is the correct layout. I need to group by client and have totals for each client. I have multiple clients that I want to show on each page with similiar data. Then go to a new page and show the next set...

Each View uses about 10 tables. I believe that I have found another way to go. I am just going to create one proceedure that will do everything that I need and use a union at the end.

Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (256) was exceeded. What I am trying to do is build multiple views that I can then join together to build one large data pull. So far I have two views in the final select. Each of these...

This did not work. When I did this I got multiple row headings not a list of what is in the cross-tab. Here is an example of what I have today Jan Feb Total Total 5 8 13 100 80 180 20 10 13.9 Here is what I am looking for Jan...

I am using Crystal 8.5 and I have a cross-tab with 20 rows of data. How do I now label each of the rows of the cross-tab? As it is now the only label on it is Total. Thanks.

I am using 8.5 and I have created a cross tab which when printing will populate three pages along the header of the cross tab. Is there a way to format the page header of the report to print on every page even though crystal sees it as only one page when printing or running to screen.

rosemary, We are not using rdc so I am off to write the proceedures. thanx eric

I am trying to pass a run time parameter from a wrapper to the udf inside of the sql expression editor. dbo.udf(?p_parameter_1,?p_parameter_2) The udf was to evaluate the parameters and pass back a boolean that I could then filter on. I am trying to stay away from a stored procedure bcse I...

Is there a way to send parameters into a sql statement udf inside of crystal reports.

I cannot use filtering criteria because it will add table2.field2 = 123456 to the WHERE clause and force an inner join. It needs to be part of the join. Any other ideas?

I want to do the following using visual linking expert: select .... from table1 left join table2 on table1.field1 = table2.field1 and table2.field2 = 123456 Is there a way to accomplish this in crystal without modifying the SQL directly and without using a WHERE which would force an inner join?

I am using a stored proceedure for my data set. I receive this error (Invalid Discriptor Index) when I try to run my crystal report. When I run the SP in query analyzer with the same run time parameters I get my desired results. What could be causing this error.

I am trying to copy Header2a into Header2b thru 2g. The header has a very large amount of formulas, formatting and spacing. When I highlight the whole header and do a copy and paste I get a partial copy and paste or it does not copy at all. Is there a limit to how large an area or data that...