Search results for query: *

I am trying to set up a procedure to take care of truncating and shrinking the t-logs of all the user db's on my server. I keep getting a syntax error on the "USE @database" line. what the heck am I missing??? USE Master DECLARE @fileName varchar(50) DECLARE @database varchar (100) DECLARE...

Thought I posted this yesterday but don't see it.... New to RS and have a report with two detail lines that I need to keep together rather than splitting over pages. I can do it in Crystal Reports but can't seem to find where it's done in RS.

For some reason our full text catalog won't seem to repopulate. The database is SQL2K running in SQL7 compatibility mode on a cluster. One table in the catalog. Remote to the primary machine in the cluster is the only way to stop and start Full Text search. In EM on cluster machine, I can...

Is is possible? So far, we're figuring not having not met with success....

Have set up a DTC relationship between a server running SQL2k and one running SQL2k5, in trying to fire off a trigger to update the 2k5 database, get the following: "New transaction cannot enlist in the specified transaction coordinator" The db firing the trigger is actually running in SQL7...

Source db is on a SQL 2k platform, running in SQL 7.0 compatibility mode. Destination is a SQL 2k5 db. Source db does not use Window authentication (I didn't set it up) but the app it backs up handles it with local logins. Destination db also has it's own local logins (nope, didn't set that...

CR 8.5 (I'm stuck with it at the moment) I am either stoopid or simply having a brain cramp. But I'll be darned if I can figure out how to simply, include records where a parameter value might be null? In this report, I have two parameter elements, one a number and the other a letter. In my...

We have a CR11 report that prints its details in a numerical order, grouped by a string value. At the end of each group, we need to create a page number index but the index itself is grouped differently. So the data looks like: {Group Header:} Committee A Bill 1 A Cow bill Bill 2 Another...

I have a need to produce a report in a "two column" layout, much like the pages of a magazine. Each "column" with contain a number of data elements. Want the layout to be "typical" where it starts in the upper left, goes down the left hand side of the page and then, at the bottom, starts again...

I am at a loss. I am setting up an isolated client and server pair to send off to a contractor so that they can duplicate our environment here for a specific piece of software support. I client is WinXP pro, set up as one of our front line user machines. I was able to properly configure it...

I have a rather complex report with 10 gh/gf combos to get proper sorting and control breaks. Not all are displayed. GH1 .. GH3 ... GH8 GH9 GH10 .. GF10a,b .. GF1 PF RF The footers contain subreports that with detail sums and formats. I've tried myriad combinations of keep together, keep...

I must be missing something. I'm in Crystal 9. I have a cross tab report that has month names as column headings derived from meeting dates in a SQL table. The date field is a smalldatetime and I have a formula that derives the month name from the date: MonthName...

This one has my mystified. We have several servers hosting SQL Server. All are either new 2k installs or 2k upgrades. Our programmer here was trying to create a User Defined function on a db in Query Analyzer on one of the servers. Errors abound! When she brought it to me, we started...

just need to simply deliver some CR11 reports to a couple of offices via an intranet webpage. Have found REFERENCES to configuring RAS but connot find a place that actually tells me WHERE to go to do it....

I was glad to see that CR made it easier to edit an exported report result in v. 11. Problem is, it doesn't export underscores. I have some numerical totals and columns of numbers with underlines. All are lost when exported. Anyone have a way around this issue? Thanks! Nik

Whats the skinny on the SQL Server limitation in joining two tables from separate databases where the one of the fields in the output is of datatype TEXT? I've tried it in Access and Crystal.

I am convinced I am barking up the wrong tree..... My CR9 report uses several parameters to select data, one of which allows multiple values. I want to put a note in the header of the report to let the user know which parameters he or she has selected. Basically something that looks like...

Has anyone else encountered discrepancies between how a report is formatted in CR and how it appears and prints via ActiveX? In addition to the other post I made recently, I am working on another report with a report header, page header and 2 detail sections (A and B). A has single instances of...

What am I doing wrong. I have a simple report, set up in landscape legal format. The first column is a concatenation of a string and number (field1 & CStr(field2)). The number is always a whole number. But regardless, when viewed in ActiveX viewer, the number portion has 2 decimal places...

I am at a loss. It seems so simple. Here's the HTML: HREF="http://inet/reports/Bill_Titles.rpt?init=html_page&user0=xxxxxxx&password0=yyyyyyyy" I click the link, the page comes up nicely asking for my user name and password (DB is predefined). Regardless if I have a user0 and...