Search results for query: *

Can anyone tell me how to change the authentication mode in MSDE from windows authentication to mixed authentication? Thank you!

Can someone tell me what the OJ in in the joining claus of the sql query passed from CR is? I have a report that is doubling some fields. If I past the sql query into query analyzer, it does the same thing, but if I take the oj off, works fine. What in the world is it? Thanks, Sarah

Is there a way to have a formula field that uses two groups? I want to select the max grouped by one thing, then the sum of that grouped by something else. Here's the syntax I've got, and it gives me a summary/running total field could not be created...

Crystal 8, sql 2000 I am trying to change a table from inside the sql query window, but I can't make crystal see the fields. It doesn't give me an error, it just won't see it. If I were to change the table in sql, I would verify database to make it see it - how can I make it see the changed...

We have a client whose sql server will not start. We've tried starting from the service manager, it just won't start. We tried starting it through enterprise manager, and it gives the message connection failded - check sql server connection properties. Does anyone have any ideas?

I have a report that's made up of three subreports. On my station, I can preview it fine. On the customer's site, I can only see one of the subreports. When I preview the report there, if I double-click on the place the subreport should be, it will bring it up. Does anyone know why this...

We have a report that we're having some trouble with, and I need to check some stuff out in it, but Crystal will not allow me to open it - I get a message that just says "Dos error", and then kicks me out of crystal. Has anyone encountered this before, and does anyone have any ideas...

I have a name field that is formated like Smith, John D. Can someone tell me what the best way to reformat it to John D. Smith would be? I could drop back out to sql and do it, but if I can, I'd rather do it in crystal. Crystal 8, sql 2000.

Help! I created a script of some views, and ran it on a client's server, not realizing that the option to script depentant objects would drop all tables the views were depentand on. The table I dropped has ALL their data on it! Can anyone tell me of the best way to recover the table, or can...

Often, when I create reports, I will have multiple sets of data that I preview from the report. (One at a time). The report is actually ran from a view. The view's name will never change, but the database name often will. In the 'Set Location' tab, there is a 'table' name. It is...

I have multiple subreports, and I need to pass the number of records in each subreport back up to my main report. I will have 50+ subreports on this report - can I use this many shared variables?

Can anyone help me with a way to make the caption on my main report display the number of records in the subreport without attaching the subreport database to the main report? What I am trying to build is a main report with many on-demand drill-down subreports. The caption for each subreport...