Newest Excel Questions | Wyzant Ask An Expert

205 Answered Questions for the topic Excel

Excel Microsoft Excel Ssrs Reporting Services

05/25/19

Dynamic tablix creation on SSRS?

Scenario: I have a table of open orders by vendor, I need to be able to generate an excel file with a list of every vendor's open orders separated on each tab. I need then need to set up a... more

Follows • 1

Answers •1

Excel Microsoft Excel Email Sql Server 2008

05/23/19

tsql to export and attach SSRS report to email?

I don't think there's an easy way to do this, but here goes. We have an `SSRS` report that can be invoked with `http://MyServer/ReportServer/Pages/ReportViewer.aspx?%2fSales%2fSalesReport` We... more

Follows • 1

Answers •1

Excel Microsoft Excel Vb.net Export

05/23/19

SSRS with parameters export to excel using textbox?

I have a Reporting Services (SSRS) rdl report with parameters. The user can select multiple values in one of the parameters. I need to export the report to Excel file using a hyperlink with a... more

Follows • 1

Answers •1

Excel Math Microsoft Excel Accounting

05/23/19

Excel formula that multiplies the value of a cell times 2 only if it is under $.99?

Hello and thank you for your help! I am writing a formula to help me calculate coupon deals for my shopping trip. My store doubles coupons $.99 or under, so I need a formula that does the... more

Follows • 1

Answers •2

Excel Microsoft Excel Formulas Ssrs

05/20/19

How to export SSRS 2008 R2 report(.rdl) to excel with formulas?

I want to export SSRS 2008 R2 report (.rdl) to excel with formulas. Is OfficeWriter API has this feature? If yes, can anyone please help me on this? Thanks in adv.

Follows • 1

Answers •1

Excel Microsoft Excel Ms Access Ssrs

05/19/19

Alternatives to pulling data from ATOM Data Feed?

I did some extensive searching and was unable to find the answer to my question: Are there alternatives to pulling data using ATOM Data Feeds other than Microsoft Powerpivot? I am trying to set up... more

Follows • 1

Answers •1

Excel Microsoft Excel Vba Dataset

05/19/19

Excel VBA Code to pull SSRS data as a dataset?

I can’t seem to find a solution for my problem no matter how much I Google. (Please excuse my verbosity in the following explanation) My process is that I have to go to the SSRS web page, run my... more

Follows • 1

Answers •1

Excel Microsoft Excel Ssrs Reporting Services

05/15/19

OfficeWriter designer .net for excel - parameters dialog not showing?

I am trying to view an SSRS report (2008 R2 .rdl) with parameters in OfficeWriter designer .NET for excel but its not showing the parameters dialog also not displaying any alert/error. How can i... more

Follows • 1

Answers •1

Excel Microsoft Excel Ssrs Reporting Services

05/13/19

Excel as a data source in SSRS Query a Specific Column of a Sheet?

I want to query the data from an excel file utilizing ODBC System DSN for Excel 12.0. What will be the right syntax to query specific columns from a worksheet and not the whole worksheet like... more

Follows • 1

Answers •1

Excel Microsoft Excel Ssrs Reporting Services

05/12/19

Connection String for ODBC on report server?

I want to create a datasource on report server from an excel. I put my excel to report server. Than i wrote a connection string, but it did not work. What is wrong? "Data... more

Follows • 1

Answers •1

Excel Microsoft Excel Visual Studio Ssrs

05/11/19

ssrs exporting to excel as csv?

I am calling SSRS reports from an in house piece of software. All the reports made before me render as xlsx or xls and mine continuously are rendering as csv files which is messing up my... more

Follows • 1

Answers •1

Excel Microsoft Excel Export Ssrs

05/11/19

Save Excel File with a Timestamp when Exporting a Report in SSRS 2016?

I've been fiddling around with SSRS 2016 and tried, without any success, to add a timestamp to the saved excel file when exporting a report. Is there a way, preferably one that isn't much of a... more

Follows • 1

Answers •1

Excel Microsoft Excel Report Ssrs

05/11/19

SSRS: creating a report optimized for exporting to Excel?

I have a client that needs a particular report that he can export to excel. I haven’t started to build the report, but I’m thinking the best way to do this is to keep the report as simple as... more

Follows • 1

Answers •1

Excel Microsoft Excel Ssrs Reporting Services

05/11/19

SSRS footer text color not changing?

We are applying a stylesheet to SSRS report footer. Footer Font color is set dynamically based on the configuration in the database. When report is exported into Excel, footer color is always... more

Follows • 1

Answers •1

Excel Microsoft Excel

04/28/19

Need help regarding Excel formula

If multiple values are given in Excel sheets, then how to calculate the any percentage on fixed value for example we have 18000 thousand rupees but we need to Calculate any percentage on only 15000... more

Follows • 2

Answers •1