I am trying to setup SQL Reporting Services on my machine. When I open the SQL Reporting Configuration Tool I cannot setup the report server instance (see attached image). Maybe I need to setu...
I need to dynamically change the page top and bottom margin based upon values that come from a table.
For example, if a table value is "ABC" for a particular page, then I need a 1 inch top ...
Is it possible to locate reports from the table and print. I am unable to activate the report finder nor does the OK OR Cancel buttons operate. Is the function possible.
We can set order as Ascending or Descending.
But as per requirement in one of my project they want Display of Measure as Customised.
there are 3 columns
Direct Expenses, Overhead Exense A...
I have a SSAS cube which I am reporting on using an SSRS matrix.
I have given the impression of drilldown by hiding a column and then allowed the visibility to toggled using another cell.
...
I have successfully setup everything for SQLSERVER Reporting...Now when I try to go to the sqlreports page (http://npl77/Reports_NPLSQLSERVER) for me I get a windows login popup that is asking...
This worked in Crystal 8.5 and the report has been converted to Crystal 10 - using the same data - Please help.....
shared stringvar current := "";
shared stringvar over30 := "";
shared ...
I need to create a matrix report with column heading I have the base of the report done but adding column names is not easy is there an easy of doing this? I don't want the rows to go down I ...
Is it possible to include an ASP.net form in SSRS
Here is the scenario:
I have custom code to sum the totals of a column (I had to perform calculations originally). Works perfectly! What I need to do is now take the value of the textbox (R...
Hello experts,
What is happening makes no sense. I have been working with SSRS for about a year so I am not a beginner. I have a Stored Procedure that returns records when I run it in the D...
ok so i have this code that finaly works the way i want it to.
How can use this code to create a report for sql server reporting services
the only part i want the end user to be able to ...
I have a crystal report that contains a subreport. In the subreport details there are columns, the columns have conditional formatting to display a color based on what is in the field. When ...
Hi all,
I have two temp tables, one performs a main query (#temp_acct_codes) and holds the results. The other one takes the data from the first one and sums the hours_already_worked and al...
I used SQL server connection with SSRS and it worked fine with me by calling a stored procedure, when i tried a report with ODBC connection with the same stored procedure, its given an error c...
Heres a very simple expression that I'm too tired to play with anymore:
If {Command.RestPain}= -1
Then 'No Pain'
Else {Command.RestPain};
restPain is set as an integer in the SQL Serv...
We have a sql reporting Services, I upload the report from IE local/reports , can someone tell how I can find out where the reports is located when uploaded? Can I access /copy the rdl file th...
I have an interesting problem. I have a list of clients and email addresses associated with them. For simplicity's sake, this is a short sample of a table
Client ID, EMailAddress
1, joe@ex...
In my SSRS view, dates are formatted like this 2/13/2008 12:00:00 AM . If my date falls between 07/01/2007 and 06/30/2008 (for example), I want a field to say FY 2008 and so on, for each...
I need to locate the SSRS log files since I have had the following error:
Failure sending mail: The report server has encountered a configuration error. See the report server log files for ...
How to add a note in Report parameters section in reporting services?
I am trying to write a formula to return dateformat in month-year. I tried the following code but I still cant get rid of the comma from the year. eg. its returning September-2,008.
totext(m...
I'm having an issue with a concatenated formula field on a Crystal Report displaying decimals. I need it to be display an integer.
My formula: "Total Cards: " & Count({tblKAN_Cards.Card_ID}, ...
I have a report that pulls data from 2 different views, so the results look like the below. Basically, the only connection between the 2 views are the ID number.
View 1:
ID: 123
Data
...
Does anyone know where can i find a report writer that is also a scheduler. i need to write reports in sql and then export them in excel and send them to a bunch of people?
Thanks.
